SQL IMPORT TEST
Tables (36)
APPROVAL
- APPRVLINE_ID — INT — Primary key — NOT NULL
- DOC_CD — INT — Foreign key → DOCS.DOC_CD — NOT NULL
- BP_CD — VARCHAR(20) — Foreign key → DOCS.BP_CD — NOT NULL
- APPROVAL_STATUS — INT
APPROVAL_SETTINGS
APPROVAL_undefinedS
- COMMENT_ID — INT — NOT NULL
- EMP_NO — VARCHAR(20) — NOT NULL
- undefined — NVARCHAR(MAX)
APPROVE
- APPROVE_ID — INT — Primary key — NOT NULL
- EMP_NO — VARCHAR(20) — Foreign key → B_EMPLOYEE.EMP_NO — NOT NULL
- BIZ_AREA_CD — VARCHAR(10) — Foreign key → B_EMPLOYEE.BIZ_AREA_CD — NOT NULL
- APPROVAL_ID — INT — Foreign key → APPROVAL.APPRVLINE_ID — NOT NULL
- BP_CD — VARCHAR(20) — Foreign key → APPROVAL.BP_CD — NOT NULL
- APPROVAL_IDX — INT
- P_APPROVAL_ID — INT
- APPRV_CD — INT — 결재/합의/확인
- APPROVAL_CD — VARCHAR(1)
APPRVLINES
- APPRVLINE_ID — INT — Primary key — NOT NULL
- EMP_NO — VARCHAR(20) — Foreign key → B_EMPLOYEE.EMP_NO — NOT NULL
- BIZ_AREA_CD — VARCHAR(10) — Foreign key → B_EMPLOYEE.BIZ_AREA_CD — NOT NULL
- APPRVLINE_NM — NVARCHAR(50)
APPRVLINE_DETAILS
- DETAIL_ID — INT — Primary key — NOT NULL
- APPRVLINE_ID — INT — Foreign key → APPRVLINES.APPRVLINE_ID — NOT NULL
- EMP_NO — VARCHAR(20) — Foreign key → B_EMPLOYEE.EMP_NO — NOT NULL
- BIZ_AREA_CD — VARCHAR(10) — Foreign key → B_EMPLOYEE.BIZ_AREA_CD — NOT NULL
- LINES_IDX — INT
- P_DETAIL_ID — INT
- APPRV_CD — INT — 결재/합의/확인
ATTACH_LIST
- FILE_ID — INT — Primary key — NOT NULL — 1,1
- GUBUN — VARCHAR(20)
- NID — VARCHAR(20)
- SID — VARCHAR(30)
- FILE_NAME — VARCHAR(255)
- FILE_SIZE — INT — DEFAULT 0
BASECODE
BOARD_OPINION
- OID — INT — Primary key — NOT NULL — 1-1
- CID — INT — Foreign key → ZB_BOARD_CONTENTS.CID — NOT NULL
- EMP_NO — varchar(255) — Foreign key → ZB_BOARD_CONTENTS.EMP_NO — NOT NULL
- BIZ_AREA_CD — VARCHAR(10) — Foreign key → ZB_BOARD_CONTENTS.BIZ_AREA_CD — NOT NULL
- BOARD_ID — VARCHAR(20) — Foreign key → ZB_BOARD_LIST.BOARD_ID — NOT NULL
- UID — INT
- IDS — VARCHAR(255)
- OPINION — TEXT
- GOOD — INT — DEFAULT 0
- NOGOOD — INT — DEFAULT 0
B_BIZ_AREA
- BIZ_AREA_CD — VARCHAR(10) — Primary key — NOT NULL
- GROUP_CD — VARCHAR(10) — Foreign key → GROUP.GROUP_CD — NOT NULL
- BIZ_AREA_NM — NVARCHAR(20)
- USE_FLG — VARCHAR(1)
B_BIZ_PARTNER
- BP_CD — VARCHAR(20) — Primary key — NOT NULL
- BP_NM — NVARCHAR(50)
- BIZ_REG_NO — VARCHAR(10)
- USE_FLG — VARCHAR(1)
- CURRENCY_CD — VARCHAR(3)
- BIZ_TYPE — NVARC
- BIZ_ITEM — NVARCHAR(50)
- REPRESN_NM — NVARCHAR(50)
- RES_REG_NO — VARCHAR(50)
- PUR_FLG — VARCHAR(1) — DEFAULT
- SAL_FLG — VARCHAR(1) — DEFAULT
- BP_TYPE — VARCHAR(1) — DEFAULT
B_BIZ_PARTNER_PRSN
- BIZ_PRSN_ID — VARCHAR(20) — Primary key — NOT NULL
- BP_CD — VARCHAR(20) — Foreign key → B_BIZ_PARTNER.BP_CD — NOT NULL
- BP_PRSN_NM — NVARCHAR(50)
- USE_FLG — VARCHAR(1)
B_DEPT
- DEPT_CD — VARCHAR(20) — Primary key — NOT NULL
- BIZ_AREA_CD — VARCHAR(10) — Foreign key → B_BIZ_AREA.BIZ_AREA_CD — NOT NULL
- DEPT_NM — NVARCHAR(50)
- PAR_DEPT_CD — VARCHAR(20)
- MANAGER_EMP_NO — VARCHAR(20)
- USE_FLG — VARCHAR(1)
B_DEPT_HISTORY
- DEPT_CD — VARCHAR(20) — Foreign key → B_DEPT.DEPT_CD — NOT NULL
- BIZ_AREA_CD2 — VARCHAR(10) — Foreign key → B_DEPT.BIZ_AREA_CD — NOT NULL
- INTNL_DEPT_CD — VARCHAR(255)
- DEPT_NM — VARCHAR(255)
- BIZ_AREA_CD — VARCHAR(10 NULL, PAR_DEPT_CD VARCHAR(20)
- INTL_PAR_DEPT_CD — VARCHAR(20)
- USE_FLG — VARCHAR(1)
B_EMPLOYEE
- EMP_NO — VARCHAR(20) — Primary key — NOT NULL
- DEPT_CD — VARCHAR(20) — Foreign key → B_DEPT.DEPT_CD — NOT NULL
- BIZ_AREA_CD — VARCHAR(10) — Foreign key → B_DEPT.BIZ_AREA_CD — NOT NULL
- EMP_NM — NVARCHAR(50)
DELEGATORS
- DELEG_ID — INT — Primary key — NOT NULL
- DGR_NO — varchar(20) — NOT NULL
- DGE_NO — varchar(20) — NOT NULL
- START_DATE — DATE
- END_DATE — DATE
- BIZ_AREA_CD — VARCHAR(10) — NOT NULL
DOCS
- DOC_CD — VARCHAR(20) — Primary key — NOT NULL
- DOCTYPE_CD — VARCHAR(20) — Foreign key → DOCTYPE.DOCTYPE_CD — NOT NULL
- EMP_NO — VARCHAR(20) — Foreign key → B_EMPLOYEE.EMP_NO — NOT NULL
- BP_CD — VARCHAR(20) — Foreign key → B_BIZ_PARTNER.BP_CD — NOT NULL
- DOC_TITLE — NVARCHAR(50)
DOCTYPE
- DOCTYPE_CD — VARCHAR(20) — Primary key — NOT NULL
- DOCTYPE_NM — NVARCHAR(50)
DOC_ATTACHS
- DOC_ATTACH_IDX — INT — Primary key — NOT NULL
- DOC_CD — VARCHAR(20) — Foreign key → DOCS.DOC_CD — NOT NULL
- BP_CD — VARCHAR(20) — Foreign key → DOCS.BP_CD — NOT NULL
- EMP_NO — VARCHAR(20) — Foreign key → B_EMPLOYEE.EMP_NO — NOT NULL
- BIZ_AREA_CD — VARCHAR(10) — Foreign key → B_EMPLOYEE.BIZ_AREA_CD — NOT NULL
- ONUM — INT
- FILEPATH — VARCHAR(MAX)
- FILENAME — VARCHAR(MAX)
GROUP
- GROUP_CD — VARCHAR(20) — Primary key — NOT NULL
- GROUP_NM — NVARCHAR(5)
INBOX
- DEPT_CD — VARCHAR(20) — Foreign key → B_DEPT.DEPT_CD — NOT NULL
- BIZ_AREA_CD — VARCHAR(10) — Foreign key → B_DEPT.BIZ_AREA_CD — NOT NULL
- CHARGER_NO — VARCHAR(20) — Foreign key → B_EMPLOYEE.EMP_NO — NOT NULL
MAILSETTINGS
MESSAGEBOX
- MSG_ID — DOUBLE — Primary key — NOT NULL
- CONTENT — TEXT — NOT NULL
- FROM_ID — VARCHAR(20) — NOT NULL
- TO_ID — VARCHAR(20) — NOT NULL
NAMECARD
- NAMECARD_IDX — INT — Primary key — NOT NULL
- EMP_NO — VARCHAR(20) — Foreign key → B_EMPLOYEE.EMP_NO — NOT NULL
- BIZ_AREA_CD — VARCHAR(10) — Foreign key → B_EMPLOYEE.BIZ_AREA_CD — NOT NULL
NOTIFICATIONS
- DOC_CD — VARCHAR(20) — Foreign key → DOCS.DOC_CD — NOT NULL
- DEPT_CD — VARCHAR(20) — Foreign key → B_DEPT.DEPT_CD — NOT NULL
- EMP_NO — VARCHAR(20) — Foreign key → B_EMPLOYEE.EMP_NO — NOT NULL
- IS_DEPT — VARCHAR(1) — NOT NULL
- IS_READ — VARCHAR(1) — NOT NULL
OILPRICE
- OILPRICE_IDX — INT — Primary key — NOT NULL
- OIL_CD — VARCHAR(3)
- PRICE — CURRENCY
- START_DATE — DATE
- END_DATE — DATE
PERMISSIONS
RECIPIENTS
- DOC_CD — VARCHAR(20) — Foreign key → DOCS.DOC_CD — NOT NULL
- DEPT_CD — VARCHAR(20) — Foreign key → B_DEPT.DEPT_CD — NOT NULL
- EMP_NO — VARCHAR(20) — Foreign key → B_EMPLOYEE.EMP_NO — NOT NULL
- IS_DEPT — VARCHAR(1) — NOT NULL
- IS_READ — VARCHAR(1) — NOT NULL
REFERENCES
- DOC_CD — VARCHAR(20) — Primary key — NOT NULL
- DEPT_CD — VARCHAR(20) — Primary key — NOT NULL
- EMP_NO — VARCHAR(20) — Primary key — NOT NULL
- IS_DEPT — VARCHAR(1) — NOT NULL
- IS_READ — VARCHAR(1) — NOT NULL
SCHEDULE
- SCHEDULE_IDX — INT — Primary key — NOT NULL
- EMP_NO — varchar(255) — Foreign key → B_EMPLOYEE.EMP_NO — NOT NULL
- CATEGORY_CD — VARCHAR(20) — Foreign key → SCHEDULE_TARGET.CATEGORY_CD — NOT NULL — 업무일정/휴가일정/회의실1/공용차량1
- SCHEDULE_TITLE — NVARCHAR(200) — NOT NULL
- START_DATETIME — DATETIME
- END_DATETIME — DATETIME
SCHEDULE_TARGET
- CATEGORY_CD — VARCHAR(20) — Primary key — NOT NULL — 업무일정/휴가일정/회의실1/공용차량1
- CATEGORY_NM — nvarchar(255) — NOT NULL
SIGNATURE
- SIGN_IDX — INT — Primary key — NOT NULL
- EMP_NO — VARCHAR(20) — Foreign key → B_EMPLOYEE.EMP_NO — NOT NULL
- BIZ_AREA_CD — VARCHAR(10) — Foreign key → B_EMPLOYEE.BIZ_AREA_CD — NOT NULL
- FILEPATH — VARCHAR(MAX) — NOT NULL
- FILENAME — VARCHAR(MAX) — NOT NULL
- USE_FLG — VARCHAR(1) — NOT NULL
SPECIALIST
- SP_ID — INT — Primary key — NOT NULL
- SPECIALIST_NO — VARCHAR(20) — Foreign key → B_EMPLOYEE.EMP_NO — NOT NULL
- BIZ_AREA_CD — VARCHAR(10) — Foreign key → B_EMPLOYEE.BIZ_AREA_CD — NOT NULL
ZB_BOARD_ATTACH
- AID — INT — Primary key — NOT NULL
- CID — INT — Foreign key → ZB_BOARD_CONTENTS.CID — NOT NULL
- BIZ_AREA_CD — VARCHAR(10) — Foreign key → ZB_BOARD_CONTENTS.BIZ_AREA_CD — NOT NULL
- BOARD_ID — VARCHAR(20) — Foreign key → ZB_BOARD_LIST.BOARD_ID — NOT NULL
- ONUM — INT
- FILEPATH — VARCHAR(MAX)
- FILENAME — VARCHAR(MAX)
- GUBUN — VARCHAR(20)
ZB_BOARD_CONTENTS
- CID — INT — Primary key — NOT NULL
- BOARD_ID — VARCHAR(20) — Foreign key → ZB_BOARD_LIST.BOARD_ID — NOT NULL
- EMP_NO — varchar(255) — Foreign key → B_EMPLOYEE.EMP_NO — NOT NULL
- BIZ_AREA_CD — VARCHAR(10) — Foreign key → B_EMPLOYEE.BIZ_AREA_CD — NOT NULL
- GUBUN — VARCHAR(20)
- TITLE — NVARCHAR(200)
- CONTENTS — TEXT
- NOTICE — VARCHAR(2)
- VIEWS — INT
- GOOD — INT
- NOGOOD — INT
- ONUM — INT
ZB_BOARD_LIST
- BOARD_ID — VARCHAR(20) — Primary key — NOT NULL
- BOARD_NAME — NVARCHAR(50)
- BOARD_ADMIN — VARCHAR(100)
- BOARD_CATE — VARCHAR(20)
- MEM_TYPE — VARCHAR(20)
- READ_LEVEL — VARCHAR(20)
- WRITE_LEVEL — VARCHAR(20)