SQMS 전체 ERD 구성
테이블 (50)
dbo.ACCP_CHK_LIST
- ACCP_CHK_LIST_ID — bigint — 기본 키 — NOT NULL
- MTRL_ACCP_TS_ID — nvarchar(30) — NOT NULL
- MTRL_PRJT_DTL_ID — bigint
- PRJT_CHK_LST_ID — nvarchar(30)
- MTRL_SITE_DTL_ID — nvarchar(30)
- SITE_CHK_LST_ID — nvarchar(30)
- ACCP_CHK_RSLT — nvarchar(30)
- MSRS — nvarchar(2000)
- CHK_MTD — nvarchar(4000)
- CHK_STD — nvarchar(4000)
- CHK_CONTENT — ntext
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.ADM_AGREEMENT
- AGMT_SEQ — bigint — 기본 키 — NOT NULL
- USER_ID — nvarchar(15) — NOT NULL
- USER_TYPE — nvarchar(30)
- AGREE_FRST — char(1)
- AGREE_SCND — char(1)
- AGREE_THRD — char(1)
- AGREE_DTTM — datetime
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.ADM_CERT_NUM
- NUM — bigint — 기본 키 — NOT NULL
- USER_ID — nvarchar(15)
- USER_TYPE — nvarchar(30)
- REQ_TYPE — nvarchar(20)
- CERT_NUM — nvarchar(20)
- CERT_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.ADM_QLTY_COST_ELEC
- QLTY_COST_UTIL_ID — nvarchar(30) — 기본 키 — NOT NULL
- ELEC_PRICE_01 — float
- ELEC_PRICE_02 — float
- ELEC_PRICE_03 — float
- ELEC_COST_AVG — float
- USE_YN — char(1)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.ADM_QLTY_COST_MASTER
- QLTY_COST_ID — nvarchar(30) — 기본 키 — NOT NULL
- BASE_PRICE_TYPE — nvarchar(10) — NOT NULL
- PUBLIC_TYPE — nvarchar(2)
- WORK_DAY — int
- EFCT_DT — nvarchar(8) — NOT NULL
- TECHNICIAN — int
- SUPR_EGNR — int
- EXPR_EGNR — int
- MID_EGNR — int
- BGIN_EGNR — int
- EXPR_SKIL_TECH — int
- MIDL_SKIL_TECH — int
- BGIN_SKIL_TECH — int
- EXPR_QLTY_MNGR — int
- ADVC_QLTY_MNGR — int
- MIDL_QLTY_MNGR — int
- BGIN_QLTY_MNGR — int
- USE_YN — char(1)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.ADM_QLTY_COST_UTIL_MASTER
- QLTY_COST_UTIL_ID — nvarchar(30) — 기본 키 — NOT NULL
- PUBLIC_TYPE — nvarchar(2)
- WORK_DAY — int
- EFCT_DT — nvarchar(8) — NOT NULL
- ELEC_COST_TOTAL_SUM — float
- ELEC_COST_TOTAL_AVG — float
- WATER_COST_TOTAL_SUM — float
- WATER_COST_TOTAL_AVG — float
- GAS_COST_TOTAL_SUM — float
- GAS_COST_TOTAL_AVG — float
- GAS_COST_CALC — float
- USE_YN — char(1)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.ADM_QLTY_TEST_INSTT
- SITE_MSTR_ID — nvarchar(30) — 기본 키 — NOT NULL
- TEST_INSTT_ID — nvarchar(15) — 기본 키 — NOT NULL
- TEST_INSTT_NAME — nvarchar(150)
- USER_NM — nvarchar(30)
- EMAIL — nvarchar(50)
- CTTPC — nvarchar(30)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.ADM_QTLY_COST_GAS
- QLTY_COST_GAS_ID — int — 기본 키 — NOT NULL
- QLTY_COST_UTIL_ID — nvarchar(30) — NOT NULL
- AREA — nvarchar(30) — NOT NULL
- GAS_PRICE_01 — float
- GAS_PRICE_02 — float
- GAS_PRICE_03 — float
- GAS_COST_AVG — float
- GAS_COST_SORT — int
- USE_YN — char(1)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.ADM_QTLY_COST_WATER
- QLTY_COST_WATER_ID — int — 기본 키 — NOT NULL
- QLTY_COST_UTIL_ID — nvarchar(30) — NOT NULL
- AREA — nvarchar(30) — NOT NULL
- WATER_PRICE_01 — float
- WATER_PRICE_02 — float
- WATER_COST_SUM — float
- WATER_COST_SORT — int
- USE_YN — char(1)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.ADM_SITE_MAPPING
- ADM_SITE_MAP_ID — bigint — 기본 키 — NOT NULL
- USER_ID — nvarchar(15)
- USER_TYPE — nvarchar(30)
- SITE_MSTR_ID — nvarchar(30)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.ADM_USER_MNGT
- ADM_USER_MNGT_ID — bigint — 기본 키 — NOT NULL
- USER_TYPE — nvarchar(30)
- TRADE_ID — nvarchar(15)
- TRADE_NM — nvarchar(150)
- USER_ID — nvarchar(15)
- USER_NM — nvarchar(30)
- USER_TITLE — nvarchar(500)
- JOB_ROLE_NM — nvarchar(100)
- EMAIL — nvarchar(50)
- HP — nvarchar(30)
- TRADE_TYPE — char(1)
- USE_START_DT — nvarchar(10)
- USE_END_DT — nvarchar(10)
- PW_CHG_DATE — datetime
- FINAL_LOGIN_DTTM — datetime
- LOGIN_FAIL_CNT — int
- LOCK_YN — char(1)
- LOCK_DTTM — datetime
- DORMANT_YN — char(1)
- DORMANT_DTTM — datetime
- DISABLE_YN — char(1)
- DISABLE_DTTM — datetime
- CREATE_SYS — nvarchar(10)
- GROUP_AUTH_DTL_ID — nvarchar(30)
- FIRST_LOGIN_YN — char(1)
- LOGIN_IP — nvarchar(100)
- CHANGE_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.AGNCY_APRV_USER_INFO
- USER_ID — nvarchar(15) — 기본 키 — NOT NULL
- APRV_START_DT — nvarchar(8) — 기본 키 — NOT NULL
- APRV_END_DT — nvarchar(8)
- AGNCY_APRV_RESN — nvarchar(500)
- AGNCY_USER_ID — nvarchar(15)
- AGNCY_USER_NM — nvarchar(30)
- AGNCY_JOB_TITLE — nvarchar(50)
- AGNCY_JOB_ROLE_NM — nvarchar(100)
- AGNCY_TRADE_ID — nvarchar(15)
- AGNCY_TRADE_NM — nvarchar(150)
- AGNCY_TRADE_TYPE — char(1)
- AGNCY_TRADE_TYPE_NM — nvarchar(100)
- AGNCY_USER_TYPE — nvarchar(30)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.APRV_INFO
- APRV_INFO_ID — nvarchar(30) — 기본 키 — NOT NULL
- SITE_MSTR_ID — nvarchar(30) — NOT NULL
- APRV_OPTN_TYPE — nvarchar(30)
- DOC_TYPE — nvarchar(30)
- DOC_SEQ — nvarchar(300)
- CODE_TYPE — nvarchar(30)
- CODE_DTL_TYPE — nvarchar(30)
- TITLE — nvarchar(500)
- DOC_OZ_FILE_NM — nvarchar(100)
- DOC_OZ_PARAM01 — nvarchar(100)
- DOC_OZ_PARAM02 — nvarchar(100)
- DOC_OZ_PARAM03 — nvarchar(100)
- DOC_OZ_PARAM04 — nvarchar(100)
- DOC_OZ_PARAM05 — nvarchar(100)
- DOC_OZ_PARAM06 — nvarchar(100)
- DOC_OZ_PARAM07 — nvarchar(100)
- DOC_OZ_PARAM08 — nvarchar(100)
- DOC_OZ_PARAM09 — nvarchar(100)
- DOC_OZ_PARAM10 — nvarchar(100)
- DOC_OZ_PARAM11 — nvarchar(100)
- DOC_OZ_PARAM12 — nvarchar(100)
- DOC_OZ_PARAM13 — nvarchar(100)
- DOC_OZ_PARAM14 — nvarchar(100)
- DOC_OZ_PARAM15 — nvarchar(100)
- DOC_OZ_PARAM16 — nvarchar(100)
- DOC_OZ_PARAM17 — nvarchar(100)
- DOC_OZ_PARAM18 — nvarchar(100)
- DOC_OZ_PARAM19 — nvarchar(100)
- DOC_OZ_PARAM20 — nvarchar(100)
- APRV_FILE_CONNECT_ID — nvarchar(30)
- APRV_NUM — int
- FINL_MANAGER_ORDER — int
- FINL_APRV_USER_ID — nvarchar(15)
- FINL_APRV_TYPE — nvarchar(10)
- FINL_APRV_RST — nvarchar(10)
- FINL_APRV_YN — char(1)
- HELP_YN — char(1)
- SHARE_YN — char(1)
- COMMENT — nvarchar(4000) — varchar(4000) COLLATE Korean_Wansung_CI_AS DEFAULT NULL NUL
- END_DATE — nvarchar(8)
- DRFT_DTTM — datetime
- DRAFTER_ID — nvarchar(15)
- DRAFTER_NM — nvarchar(30)
- APRV_ORDER — int
- DCSN_COMPT_YN — char(1)
- FILE_TYPE — nvarchar(50)
- DOC_NAME — nvarchar(200)
- APRV_PROGRS_STATE — char(1)
- FINL_APRV_USER_NM — nvarchar(30)
- OFFLN_FILE_TYPE — nvarchar(50)
- OFFLN_FILE_CONNECT_ID — nvarchar(30)
- DEL_YN — char(1)
- IN_USER — nvarchar(15) — NOT NULL
- IN_DTTM — datetime
- UP_USER — nvarchar(15) — NOT NULL
- UP_DTTM — datetime
dbo.APRV_INFO_ETC
- APRV_INFO_ID — nvarchar(30) — 기본 키 — NOT NULL
- APRV_INFO_DTL_ID — nvarchar(30) — 기본 키 — NOT NULL
- USER_DIV — nvarchar(10)
- USER_ID — nvarchar(15)
- CHCK_YN — char(1)
- CHCK_DTTM — datetime
- HELP_USER_NM — nvarchar(30)
- HELP_JOB_TITLE — nvarchar(50)
- HELP_JOB_ROLE_NM — nvarchar(100)
- HELP_TRADE_ID — nvarchar(15)
- HELP_TRADE_NM — nvarchar(150)
- HELP_TRADE_TYPE — char(1)
- HELP_TRADE_TYPE_NM — nvarchar(100)
- HELP_USER_TYPE — nvarchar(30)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.APRV_LINE
- APRV_LINE_ID — nvarchar(30) — 기본 키 — NOT NULL
- USER_ID — nvarchar(15) — NOT NULL
- SITE_MSTR_ID — nvarchar(30)
- APRV_LINE_NM — nvarchar(150)
- APRV_USER_1 — nvarchar(15)
- APRV_USER_TYPE_1 — nvarchar(30)
- APRV_USER_NM_1 — nvarchar(30)
- APRV_DTY_CD_1 — nvarchar(10)
- APRV_JOB_TITLE_1 — nvarchar(50)
- APRV_TRADE_ID_1 — nvarchar(15)
- APRV_TRADE_NM_1 — nvarchar(150)
- APRV_USER_2 — nvarchar(15)
- APRV_USER_TYPE_2 — nvarchar(30)
- APRV_USER_NM_2 — nvarchar(30)
- APRV_DTY_CD_2 — nvarchar(10)
- APRV_JOB_TITLE_2 — nvarchar(50)
- APRV_TRADE_ID_2 — nvarchar(15)
- APRV_TRADE_NM_2 — nvarchar(150)
- APRV_USER_3 — nvarchar(15)
- APRV_USER_TYPE_3 — nvarchar(30)
- APRV_USER_NM_3 — nvarchar(30)
- APRV_DTY_CD_3 — nvarchar(10)
- APRV_JOB_TITLE_3 — nvarchar(50)
- APRV_TRADE_ID_3 — nvarchar(15)
- APRV_TRADE_NM_3 — nvarchar(150)
- APRV_USER_4 — nvarchar(15)
- APRV_USER_TYPE_4 — nvarchar(30)
- APRV_USER_NM_4 — nvarchar(30)
- APRV_DTY_CD_4 — nvarchar(10)
- APRV_JOB_TITLE_4 — nvarchar(50)
- APRV_TRADE_ID_4 — nvarchar(15)
- APRV_TRADE_NM_4 — nvarchar(150)
- APRV_USER_5 — nvarchar(15)
- APRV_USER_TYPE_5 — nvarchar(30)
- APRV_USER_NM_5 — nvarchar(30)
- APRV_DTY_CD_5 — nvarchar(10)
- APRV_JOB_TITLE_5 — nvarchar(50)
- APRV_TRADE_ID_5 — nvarchar(15)
- APRV_TRADE_NM_5 — nvarchar(150)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.APRV_OPTN_INFO
- APRV_OPTN_INFO_ID — nvarchar(30) — 기본 키 — NOT NULL
- SITE_MSTR_ID — nvarchar(30)
- APRV_OPTN_TYPE — nvarchar(30)
- CODE_TYPE — nvarchar(30)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.APRV_USER_INFO
- APRV_INFO_ID — nvarchar(30) — 기본 키 — NOT NULL
- APRV_ORDER — int — 기본 키 — NOT NULL
- DTY_CD — nvarchar(10)
- USER_ID — nvarchar(15)
- USER_NM — nvarchar(30)
- USER_TYPE — nvarchar(30)
- FILE_SGN_ARCV_ID — nvarchar(100)
- DTL_COMMENT — nvarchar(4000) — varchar(4000) COLLATE Korean_Wansung_CI_AS DEFAULT NULL NUL
- APRV_STATE — char(1)
- APRV_DTTM — datetime
- AGNCY_APRV_YN — char(1)
- AGNCY_USER_ID — nvarchar(15)
- AGNCY_USER_NM — nvarchar(30)
- JOB_TITLE — nvarchar(50)
- JOB_ROLE_NM — nvarchar(100)
- TRADE_ID — nvarchar(15)
- TRADE_NM — nvarchar(150)
- TRADE_TYPE — char(1)
- TRADE_TYPE_NM — nvarchar(100)
- DCSN_YN — char(1)
- RETN_RESN_CN — nvarchar(4000)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.BS_DEFECT_MNG
- BS_DEFECT_MNG_ID — nvarchar(30) — 기본 키 — NOT NULL
- MAIN_CODE_ID — nvarchar(30) — NOT NULL
- MID_CODE_ID — nvarchar(30) — NOT NULL
- SUB_CODE_ID — nvarchar(30) — NOT NULL
- DEFECT_TYPE_CODE — nvarchar(30) — NOT NULL
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.BS_DEFECT_PNTR_MNG
- BS_DEFECT_PNTR_MNG_ID — nvarchar(30) — 기본 키 — NOT NULL
- SITE_MSTR_ID — nvarchar(30) — NOT NULL
- MAIN_CODE_ID — nvarchar(30)
- MID_CODE_ID — nvarchar(30)
- SUB_CODE_ID — nvarchar(30)
- SPACE_TYPE_CODE — nvarchar(30)
- BS_SPACE_MNG_ID — nvarchar(30)
- TRADE_ID — nvarchar(15)
- STAND_DONG — nvarchar(4)
- ADDR_HO — nvarchar(5)
- ADDR_FLOOR — nvarchar(3)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.BS_DEFECT_PROS_CNFM
- BS_DEFECT_PROS_CNFM_ID — nvarchar(30) — 기본 키 — NOT NULL
- SITE_MSTR_ID — nvarchar(30) — NOT NULL
- BS_DEFECT_REG_MNG_ID — nvarchar(30) — NOT NULL
- BS_ASIGN_YN — char(1)
- TRADE_ID — nvarchar(15)
- BS_ASIGN_DT — nvarchar(8)
- BS_PRCS_ORDER — int
- BS_PRCS_DT — nvarchar(8)
- BS_DFPS_FILE_CONNECT_ID — nvarchar(30)
- BS_CNFM_TYPE_CODE — nvarchar(30)
- BS_CNFM_DT — nvarchar(8)
- BS_CNFM_CONTS — nvarchar(2000)
- BS_DFCF_FILE_CONNECT_ID — nvarchar(30)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.BS_DEFECT_REG_MNG
- BS_DEFECT_REG_MNG_ID — nvarchar(30) — 기본 키 — NOT NULL
- SITE_MSTR_ID — nvarchar(30) — NOT NULL
- SPACE_TYPE_CODE — nvarchar(30) — NOT NULL
- BS_SPACE_MNG_ID — nvarchar(30) — NOT NULL
- BS_DEFECT_MNG_ID — nvarchar(30) — NOT NULL
- BS_DEFECT_CONTS — nvarchar(30)
- STAND_DONG — nvarchar(4)
- ADDR_HO — nvarchar(5)
- ADDR_FLOOR — nvarchar(3)
- BS_INSP_DT — nvarchar(8)
- BS_INSPR_ID — nvarchar(30)
- BS_INSPR_NAME — nvarchar(30)
- BS_INSPR_TYPE — nvarchar(30)
- BS_INSP_EMGC — char(1)
- BS_INSP_MTRL — char(1)
- BS_INSP_POP — char(1)
- BS_FILE_CONNECT_ID — nvarchar(30)
- BS_ASIGN_TYPE — char(1)
- TRADE_ID — nvarchar(15)
- BS_ASIGN_DT — nvarchar(8)
- BS_PRCS_ORDER — int
- BS_PRCS_DT — nvarchar(8)
- BS_CNFM_TYPE_CODE — nvarchar(30)
- BS_CNFM_DT — nvarchar(8)
- BS_CNFM_CONTS — nvarchar(2000)
- BS_DEFECT_PROS_CNFM_ID — nvarchar(30)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.BS_DEFRCT_CNTS_MNG
- BS_DEFRCT_CNTS_MNG_ID — bigint — 기본 키 — NOT NULL
- SITE_MSTR_ID — nvarchar(30) — NOT NULL
- BS_DEFECT_CNTS — nvarchar(500)
- BS_DEFECT_MNG_ID — nvarchar(30)
- CNTS_ORDER — int
- USE_YN — char(1)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.BS_SPACE_DEFECT_MNG
- BS_SPACE_DEFECT_MNG_ID — nvarchar(30) — 기본 키 — NOT NULL
- SITE_MSTR_ID — nvarchar(30) — NOT NULL
- BS_SPACE_MNG_ID — nvarchar(30) — NOT NULL
- MAIN_CODE_ID — nvarchar(30) — NOT NULL
- MID_CODE_ID — nvarchar(30) — NOT NULL
- SUB_CODE_ID — nvarchar(30) — NOT NULL
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.BS_SPACE_MNG
- BS_SPACE_MNG_ID — nvarchar(30) — 기본 키 — NOT NULL
- SPACE_TYPE_CODE — nvarchar(30) — NOT NULL
- BS_SPACE_MNG_NAME — nvarchar(100)
- USE_YN — char(1)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CMNT_BOARD_COMMENT_INFO
- BOARD_COMMENT_ID — nvarchar(100) — 기본 키 — NOT NULL
- FREE_BOARD_ID — nvarchar(100) — NOT NULL
- CONTENTS — ntext
- DEL_YN — char(1)
- IN_USER — nvarchar(10)
- IN_DTTM — datetime
- UP_USER — nvarchar(10)
- UP_DTTM — datetime
dbo.CMNT_DATA_ARCHIVE_INFO
- DATA_ARCHIVE_ID — nvarchar(100) — 기본 키 — NOT NULL
- TITLE — nvarchar(500)
- CONTENTS — ntext
- ARCHIVE_TYPE — nvarchar(100)
- VIEWS — int
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CMNT_DOC_CHANGE_INFO
- DOC_CHANGE_ID — nvarchar(100) — 기본 키 — NOT NULL
- TITLE — nvarchar(500)
- CONTENTS — ntext
- VIEWS — int
- DEL_YN — char(1)
- IN_USER — nvarchar(10)
- IN_DTTM — datetime
- UP_USER — nvarchar(10)
- UP_DTTM — datetime
dbo.CMNT_DOC_COMMENT_INFO
- DOC_COMMENT_ID — nvarchar(100) — 기본 키 — NOT NULL
- DOC_CHANGE_ID — nvarchar(100) — NOT NULL
- CONTENTS — ntext
- DEL_YN — char(1)
- IN_USER — nvarchar(10)
- IN_DTTM — datetime
- UP_USER — nvarchar(10)
- UP_DTTM — datetime
dbo.CMNT_FREE_BOARD_INFO
- FREE_BOARD_ID — nvarchar(100) — 기본 키 — NOT NULL
- TITLE — nvarchar(500)
- CONTENTS — ntext
- VIEWS — int
- DEL_YN — char(1)
- IN_USER — nvarchar(10)
- IN_DTTM — datetime
- UP_USER — nvarchar(10)
- UP_DTTM — datetime
dbo.CMNT_NOTICE_INFO
- NOTICE_ID — nvarchar(100) — 기본 키 — NOT NULL
- TITLE — nvarchar(500)
- CONTENTS — ntext
- NOTICE_TYPE — nvarchar(20)
- MOB_ALARM_YN — char(1)
- SHOW_YN — char(1)
- POPUP_YN — char(1)
- POPUP_START_DATE — nvarchar(10)
- POPUP_END_DATE — nvarchar(10)
- VIEWS — int
- DEL_YN — char(1)
- IN_USER — nvarchar(10)
- IN_DTTM — datetime
- UP_USER — nvarchar(10)
- UP_DTTM — datetime
dbo.CODE_MULTI_LANG
- CODE_MULTI_LANG_ID — int — 기본 키 — NOT NULL
- LANG_CODE — nvarchar(2) — NOT NULL
- MAIN_CODE_ID — nvarchar(30)
- MID_CODE_ID — nvarchar(30)
- TRANS_CODE_NAME — nvarchar(200) — NOT NULL
- DEL_YN — char(1) — NOT NULL
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.COM_NUM_SETT_MAIN
- COM_NUM_SETT_ID — bigint — 기본 키 — NOT NULL
- CODE_TYPE — nvarchar(30)
- CODE_DTL_TYPE — nvarchar(30)
- NUMB_CODE — int
- REQUST_SAMENSS_YN — char(1)
- USE_START_DT — nvarchar(10)
- (112)) — NULL
- USE_END_DT — nvarchar(10)
- USE_YN — char(1)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.COM_NUM_SETT_TYPE
- COM_NUM_SETT_ID — bigint — 기본 키 — NOT NULL
- COM_NUM_DTL_SEQ — bigint — 기본 키 — NOT NULL
- NUMR_TYPE — nvarchar(30)
- NUMR_TYPE_NM — nvarchar(50)
- NUMR_TYPE_CD — nvarchar(30)
- NUMR_DESC — nvarchar(200)
- YEAR_TYPE — char(1)
- SEQ_RESETUP_YN — char(1)
- SORT_SEQ — int
- USE_YN — char(1)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CONC_COMP_STRG_DETAIL
- CONC_COMP_STRG_DTL_ID — bigint — 기본 키 — NOT NULL
- CONC_COMP_STRG_LST_ID — nvarchar(30) — NOT NULL
- STRG_TEST_TYPE — nvarchar(20)
- SORT — nvarchar(30)
- CONC_LOT_NUM — nvarchar(2)
- CONC_ATCL_NUM — nvarchar(2)
- CONC_ATCL_SAMPLE_NUM — nvarchar(2)
- CONC_BRKG_LOAD — nvarchar(15)
- CONC_DIAMETER — nvarchar(15)
- CONC_BEING_PARTIAL — nvarchar(15)
- CONC_COMP_STR — nvarchar(15)
- CONC_STR_CORC_CNT — nvarchar(15)
- CORC_COMP_STR — nvarchar(15)
- ATC_AVG_STR_CORC — nvarchar(15)
- LOT_AVG_STR_CORC — nvarchar(15)
- STRG_TEST_EXP_DT — nvarchar(20)
- STRG_TEST_DT — nvarchar(20)
- PASS_STANDARD — nvarchar(15)
- PASS_YN — char(1)
- FILE_IMAGE_RGT — nvarchar(2)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CONC_COMP_STRG_LIST
- CONC_COMP_STRG_LST_ID — nvarchar(30) — 기본 키 — NOT NULL
- SITE_MSTR_ID — nvarchar(30)
- CONC_POUR_DTL_ID — nvarchar(30)
- DOC_SEQ — nvarchar(300)
- APRV_INFO_ID — nvarchar(30)
- STRG_TEST_TYPE — nvarchar(20)
- STRG_TEST_EXP_DT — nvarchar(20)
- STRG_TEST_DT — nvarchar(20)
- STRG_TEST_END_DT — nvarchar(20)
- STRG_TEST_STATUS — nvarchar(30)
- TEST_YN — char(1)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CONC_DISP_SUPL_DETAIL
- CONC_DISP_SUPL_DTL_ID — bigint — 기본 키 — NOT NULL
- CONC_POUR_DTL_ID — nvarchar(30) — NOT NULL
- SITE_MSTR_ID — nvarchar(30) — NOT NULL
- DOC_SEQ — nvarchar(300)
- CONC_HOCHA — nvarchar(20)
- CONC_SUPPLY — nvarchar(15)
- CONC_DISP_SUPPLY — nvarchar(15)
- CONC_STATUS — nvarchar(30)
- CONC_DISP_REASON — nvarchar(30)
- CONC_IMAGE_FILE — nvarchar(30)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CONC_FINAL_POUR_SUPL_DETAIL
- CONC_FINAL_POSU_DTL_ID — bigint — 기본 키 — NOT NULL
- CONC_POUR_DTL_ID — nvarchar(30) — NOT NULL
- SITE_MSTR_ID — nvarchar(30) — NOT NULL
- DOC_SEQ — nvarchar(300) — NOT NULL
- CONC_FINAL_HOCHA_NM — nvarchar(20)
- CONC_LAST_POUR_AMT — nvarchar(15)
- CONC_POURS_AMT — nvarchar(15)
- CONC_DELI_ARRV_HOUR — nvarchar(2)
- CONC_DELI_ARRV_MINUTE — nvarchar(2)
- CONC_POUR_COMPL_HOUR — nvarchar(2)
- CONC_POUR_COMPL_MINUTE — nvarchar(2)
- CONC_FINAL_POUR_AMT — nvarchar(15)
- CONC_POUR_TEMP — nvarchar(15)
- CONC_POUR_END_DATE — nvarchar(10)
- CONC_DISP_SPL — nvarchar(15)
- FILE_SITE_FORMUL — char(1)
- FILE_SUPER_PRINT — char(1)
- FILE_DISP_COMMIT — char(1)
- FILE_SUPL_ID — nvarchar(30)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CONC_MRIT_CTEM_DETAIL
- CONC_MRIT_CTEM_DTL_ID — int — 기본 키 — NOT NULL
- CONC_MRIT_DTL_ID — nvarchar(30) — NOT NULL
- PUMP_STDR — nvarchar(30)
- PUMP_UNIT — nvarchar(3)
- VBRT_STDR — nvarchar(30)
- VBRT_UNIT — nvarchar(3)
- CR_PROD_STDR — nvarchar(30)
- CR_PROD_UNIT — nvarchar(3)
- ETC_STDR — nvarchar(30)
- ETC_UNIT — nvarchar(3)
- TYPE_NUM — int
- COMMENT — nvarchar(4000) — varchar(4000) COLLATE Korean_Wansung_CI_AS DEFAULT NULL NUL
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CONC_MRIT_PRPN_DETAIL
- CONC_MRIT_PRPN_DTL_ID — int — 기본 키 — NOT NULL
- CONC_MRIT_DTL_ID — nvarchar(30) — NOT NULL
- PS_CONC_EGNR — int
- PS_CRPT_EGNR — int
- PS_REBAR_EGNR — nvarchar(5)
- PS_PSTR — int
- PS_CR_EGNR — int
- CRPN_CRBN — nvarchar(5)
- CRPN_PFLM — nvarchar(5)
- CRPN_SPKR_EQMT — nvarchar(5)
- CRPN_SPKR_DTTM — int
- CRPN_NSHK_DTTM — int
- CRPN_NRSE_REBAR_DTTM — int
- CRPN_NFORM_DMTN_DTTM — int
- TYPE_NUM — int
- EXCAVATOR — nvarchar(3)
- TOWERCRAIN — nvarchar(3)
- ETC — nvarchar(50)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CONC_MRIT_RWMT_DETAIL
- CONC_MRIT_RWMT_DTL_ID — int — 기본 키 — NOT NULL
- CONC_MRIT_DTL_ID — nvarchar(30) — NOT NULL
- CEMENT_TYPE — nvarchar(30)
- AMTR_TYPE — nvarchar(30)
- ADTV_TYPE — nvarchar(30)
- DAY_FRML_TB — nvarchar(30)
- ETC — nvarchar(50)
- COMMENT — nvarchar(4000) — varchar(4000) COLLATE Korean_Wansung_CI_AS DEFAULT NULL NUL
- TYPE_NUM — int
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CONC_MRIT_TSEQ_DETAIL
- CONC_MRIT_DTL_ID — nvarchar(30) — 기본 키 — NOT NULL
- SITE_MSTR_ID — nvarchar(30) — NOT NULL
- TEST_EQMT_CLID — nvarchar(15)
- TEST_EQMT_TEMP — nvarchar(15)
- TEST_EQMT_AIR — nvarchar(15)
- TEST_EQMT_SLMP — nvarchar(15)
- TEST_EQMT_DEVICE — nvarchar(30)
- TEST_EQMT_COMP — nvarchar(30)
- TYPE_NUM — int
- FORM_DMLD_YN — char(1)
- COMP_DMLD_YN — char(1)
- PC_PCAL_DMLD_YN — char(1)
- FORM_DMLD_VAL — nvarchar(30)
- COMP_DMLD_VAL — nvarchar(30)
- PC_PCAL_DMLD_VAL — nvarchar(30)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CONC_POUR_DETAIL
- CONC_POUR_DTL_ID — nvarchar(30) — 기본 키 — NOT NULL
- CONC_MRIT_CTEM_DTL_ID — int
- CONC_MRIT_RWMT_DTL_ID — int
- CONC_MRIT_PRPN_DTL_ID — int
- CONC_POUR_OPTN_ID — bigint
- CONC_MRIT_DTL_ID — nvarchar(30)
- CONC_SPFC_FOML_ID — bigint
- SITE_MSTR_ID — nvarchar(30) — NOT NULL
- PTNR_ID — nvarchar(15)
- APRV_INFO_ID — nvarchar(30)
- DOC_SEQ — nvarchar(300)
- POUR_DAY — nvarchar(10)
- POUR_PROCESS — nvarchar(150)
- MATERIAL — nvarchar(15)
- STRUCTURE — nvarchar(150)
- POUR_PART — nvarchar(150)
- POUR_SUPPLY — nvarchar(15)
- TEST_EQMT_CLID — nvarchar(15)
- TEST_EQMT_TEMP — nvarchar(15)
- TEST_EQMT_AIR — nvarchar(15)
- TEST_EQMT_SLMP — nvarchar(15)
- TEST_EQMT_DEVICE — nvarchar(30)
- TEST_EQMT_COMP — nvarchar(30)
- PC_PCAL_CLID — nvarchar(15)
- PC_PCAL_TEMP_MIN — nvarchar(15)
- PC_PCAL_TEMP_MAX — nvarchar(15)
- PC_PCAL_AIR_MIN — nvarchar(15)
- PC_PCAL_AIR_MAX — nvarchar(15)
- PC_PCAL_SLMP_MIN — nvarchar(15)
- PC_PCAL_SLMP_MAX — nvarchar(15)
- PC_PCAL_UNIT_MIN — nvarchar(15)
- PC_PCAL_UNIT_MAX — nvarchar(15)
- CONC_MIX_SD — nvarchar(30)
- POUR_OPTION — nvarchar(30)
- CONC_TYPE — nvarchar(30)
- PCAL_FREQ — nvarchar(10)
- TEST_COMP_STRG_FREQ — nvarchar(10)
- TEST_COMP_STRG_CHK_7D — char(1)
- TEST_COMP_STRG_CHK_28D — char(1)
- TEST_COMP_STRG_CHK_91D — char(1)
- CONC_POURS_AMT — nvarchar(15)
- POUR_PROGRESS — nvarchar(30)
- VERTICAL_MATERIAL_CHK — nvarchar(5)
- HORIZONTAL_MATERIAL_CHK — nvarchar(5)
- FILLER_SUPPORT_MATERIAL_CHK — nvarchar(5)
- CONC_CP_PR_TYPE — nvarchar(30)
- FORM_DMLD_VAL — nvarchar(30)
- COMP_DMLD_VAL — nvarchar(30)
- AGS — nvarchar(30)
- USE_UNIT — char(1)
- W1 — nvarchar(15)
- W2 — nvarchar(15)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CONC_POUR_OPTION_DETAIL
- CONC_POUR_OPTN_ID — bigint — 기본 키 — NOT NULL
- CONC_SPFC_FOML_ID — bigint
- SITE_MSTR_ID — nvarchar(30) — NOT NULL
- PTNR_ID — nvarchar(15) — NOT NULL
- CONC_MIX_SD — nvarchar(30) — NOT NULL
- POUR_QNTM — nvarchar(30)
- CONC_POURS_AMT — nvarchar(15)
- PRPT_TEST_FREQ — nvarchar(10)
- CS_TEST_FREQ — nvarchar(10)
- PC_PCAL_CLID — nvarchar(15)
- PC_PCAL_TEMP_MIN — nvarchar(15)
- PC_PCAL_TEMP_MAX — nvarchar(15)
- PC_PCAL_AIR_MIN — nvarchar(15)
- PC_PCAL_AIR_MAX — nvarchar(15)
- PC_PCAL_SLMP_MIN — nvarchar(15)
- PC_PCAL_SLMP_MAX — nvarchar(15)
- PC_PCAL_UNIT_MIN — nvarchar(15)
- PC_PCAL_UNIT_MAX — nvarchar(15)
- PC_FORM_DMLD_PERP — nvarchar(15)
- PC_FORM_DMLD_HORI — nvarchar(15)
- PC_FORM_DMLD_ETC — nvarchar(30)
- PC_COMP_7D — nvarchar(15)
- PC_COMP_28D — nvarchar(15)
- PC_COMP_91D — nvarchar(15)
- CRTN_FCTR — nvarchar(15)
- VERTICAL_MATERIAL_CHK — nvarchar(5)
- HORIZONTAL_MATERIAL_CHK — nvarchar(5)
- FILLER_SUPPORT_MATERIAL_CHK — nvarchar(5)
- CURING_7D — char(1)
- CURING_28D — char(1)
- CURING_91D — char(1)
- USE_UNIT — char(1)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CONC_PRPT_TTMG_DETAIL
- CONC_PSPT_DTL_ID — bigint — 기본 키 — NOT NULL
- CONC_POUR_DTL_ID — nvarchar(30) — NOT NULL
- SITE_MSTR_ID — nvarchar(30)
- DOC_SEQ — nvarchar(300)
- CONC_HOCHA — nvarchar(20)
- CONC_TEMP — nvarchar(15)
- CONC_SLUMP — nvarchar(15)
- CONC_AIR_AMT — nvarchar(15)
- CL_DENSITY_1E — nvarchar(15)
- CL_DENSITY_2E — nvarchar(15)
- UNIT_QTY — nvarchar(15)
- PASS_JDT — nvarchar(30)
- CLID_PHOTO — nvarchar(30)
- FILE_BOARD — nvarchar(30)
- CONC_TEMP_PASS_YN — char(1)
- CONC_SLUMP_PASS_YN — char(1)
- CONC_AIR_AMT_PASS_YN — char(1)
- CL_DENSITY_PASS_YN — char(1)
- UNIT_QTY_PASS_YN — char(1)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CONC_SPFC_FOML_DETAIL
- CONC_SPFC_FOML_ID — bigint — 기본 키 — NOT NULL
- SITE_MSTR_ID — nvarchar(30) — NOT NULL
- PTNR_ID — nvarchar(15) — NOT NULL
- CONC_MIX_SD — nvarchar(30) — NOT NULL
- CONC_TYPE — nvarchar(30)
- CONC_CP_PR_TYPE — nvarchar(30)
- WB — nvarchar(10)
- SA — nvarchar(10)
- C1 — nvarchar(10)
- HSC — nvarchar(10)
- W1 — nvarchar(10)
- W2 — nvarchar(10)
- S1 — nvarchar(10)
- S2 — nvarchar(10)
- S3 — nvarchar(10)
- G1 — nvarchar(10)
- G2 — nvarchar(10)
- C2 — nvarchar(10)
- C3 — nvarchar(10)
- C4 — nvarchar(10)
- AD1 — nvarchar(10)
- AD2 — nvarchar(10)
- AD3 — nvarchar(10)
- DS_C1 — nvarchar(10)
- DS_HSC — nvarchar(10)
- DS_W1 — nvarchar(10)
- DS_W2 — nvarchar(10)
- DS_S1 — nvarchar(10)
- DS_S2 — nvarchar(10)
- DS_S3 — nvarchar(10)
- DS_G1 — nvarchar(10)
- DS_G2 — nvarchar(10)
- DS_C2 — nvarchar(10)
- DS_C3 — nvarchar(10)
- DS_C4 — nvarchar(10)
- DS_AD1 — nvarchar(10)
- DS_AD2 — nvarchar(10)
- DS_AD3 — nvarchar(10)
- AGS — nvarchar(30)
- CONC_MIX_FILE_ID — nvarchar(30)
- IN_DT — nvarchar(10)
- COMMENT — nvarchar(4000) — varchar(4000) COLLATE Korean_Wansung_CI_AS DEFAULT NULL NUL
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CONTS_MULTI_LANG
- CONTS_MULTI_LANG_ID — int — 기본 키 — NOT NULL
- LANG_CODE — nvarchar(3) — NOT NULL
- CONTS_PAGE — char(1)
- CONTS_PAGE_NAME — nvarchar(100)
- CONTS_LOC — int
- CONTS_TYPE — nvarchar(20)
- TRANS_CONTS_NAME — nvarchar(200)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CRCK_MNGT_DETAIL
- CRCK_MNGT_DTL_ID — int — 기본 키 — NOT NULL
- CRCK_MNGT_INFO_ID — nvarchar(30) — NOT NULL
- TEST_ORDER — nvarchar(20)
- CRCK_NUM — int
- CRACK_TYPE — nvarchar(2)
- START_DATE — nvarchar(10)
- CRACK_WIDTH — nvarchar(10)
- CRACK_LENGTH — nvarchar(10)
- END_DATE — nvarchar(10)
- TRADE_ID — nvarchar(15)
- USER_ID — nvarchar(15)
- IVTG_APRV_YN — char(1)
- SPTD_APRV_YN — char(1)
- REPAIR_METHOD — nvarchar(15)
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CRCK_MNGT_INFO
- CRCK_MNGT_INFO_ID — nvarchar(30) — 기본 키 — NOT NULL
- SITE_MSTR_ID — nvarchar(30) — NOT NULL
- CONC_POUR_DTL_ID — nvarchar(30) — NOT NULL
- CONC_POUR_SUB_NUM — int
- CRCK_STATUS — nvarchar(30)
- BFOR_DT — nvarchar(10)
- NEXT_DT — nvarchar(10)
- APRV_INFO_ID_NO1 — nvarchar(30)
- APRV_INFO_ID_NO2 — nvarchar(30)
- APRV_INFO_ID_NO3 — nvarchar(30)
- APRV_INFO_ID_NO4 — nvarchar(30)
- APRV_DT_REPR — nvarchar(10)
- APRV_DT_NO1 — nvarchar(10)
- APRV_DT_NO2 — nvarchar(10)
- APRV_DT_NO3 — nvarchar(10)
- APRV_DT_NO4 — nvarchar(10)
- PROGRESS_ORDER — nvarchar(5)
- CRCK_YN — char(1)
- CAUSE — nvarchar(1000)
- CARE_METHOD — nvarchar(1000)
- REMARK — nvarchar(1500)
- CRCK_MNGT_QR_URL — nvarchar(3000)
- CRCK_MNGT_QR — ntext
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.CRCK_SETUP_OPTION
- CRCK_SETUP_OPTN_ID — nvarchar(100) — 기본 키 — NOT NULL
- SITE_MSTR_ID — nvarchar(30) — NOT NULL
- CRCK_DATE_01 — int
- CRCK_DATE_02 — int
- CRCK_DATE_03 — int
- CRCK_DATE_REPR — int
- CRCK_DATE_04 — int
- DEL_YN — char(1)
- IN_USER — nvarchar(15)
- IN_DTTM — datetime
- UP_USER — nvarchar(15)
- UP_DTTM — datetime
dbo.DOC_NUM_SETT_DETAIL
- DOC_NUM_SETT_ID — nvarchar(30) — 기본 키 — NOT NULL
- DOC_NUM_CREAT_CD — nvarchar(280) — 기본 키 — NOT NULL
- DOC_NUM_CREAT_SEQ — bigint — 기본 키 — NOT NULL
- DOC_NUM_TYPE_BASE — nvarchar(150) — NOT NULL
- DOC_NUM_CREAT_BASE — nvarchar(280) — NOT NULL
- DOC_NUM_CREAT_BASE_CD — nvarchar(180) — NOT NULL
- DOC_NUM_SEQ — nvarchar(10)
- USE_YN — char(1) — NOT NULL
- DEL_YN — char(1) — NOT NULL
- IN_USER — nvarchar(15)
- IN_DTTM — datetime — NOT NULL
- UP_USER — nvarchar(15)
- UP_DTTM — datetime — NOT NULL