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)