전단자동화

테이블 (14)

TBL_AUTH_SMS

  • PHONE_SEQ — int(11) — 기본 키 — NOT NULL
  • PHONE_NUM — int(11)
  • VERIFY_CODE (VERITY_CODE) — int(6)
  • CODE_EXPIRES — varchar(255)
  • C_ID — varchar(30)
  • C_TIME — datetime
  • M_ID — varchar(30)
  • M_TIME — datetime

TBL_CODE_TABLE (tbl_code_table)

  • SEQ — int(11) — 기본 키 — NOT NULL
  • CODE_NAME — varchar(30)
  • CODE_FORMAT — varchar(20)
  • CODE_VALUE — char(1)
  • CODE_DESCRIPTION — varchar(50)
  • CODE_INDEX — int(11)

TBL_COMMUNICATION_SNAPSET

  • COMMUNICATION_SNAPSET_SEQ — int(11) — 기본 키 — NOT NULL
  • COMMUNICATION_SNAPSET_CODE — char(11) — 기본 키 — NOT NULL
  • COMMUNICATION_SNAPSET_NAME — varchar(30)
  • ACTIVE — char(1)
  • C_ID — varchar(30)
  • C_TIME — datetime
  • M_ID — varchar(30)
  • M_TIME — datetime

TBL_COMPANY_MAIN

  • COMPANY_CODE — char(11) — 기본 키 — NOT NULL
  • COMPANY_NAME — varchar(30)
  • REG_NUM — varchar(15)
  • ZIP_NUM — int(5)
  • COMPANY_ADDR_1 — varchar(100)
  • COMPANY_ADDR_2 — varchar(30)
  • COMPANY_TYPE — char(11)
  • ACTIVE — char(1)
  • C_ID — varchar(30)
  • C_TIME — datetime
  • M_ID — varchar(30)
  • M_TIME — datetime

TBL_COMUNICATION_MAIN

  • COMMUNICATION_SEQ — int(11) — 기본 키 — NOT NULL
  • COMMUNICATION_CODE — char(11) — 기본 키 — NOT NULL
  • PROJECT_CODE — char(11) — 외래 키 → TBL_PROJECT_MAIN.PROJECT_CODE — NOT NULL
  • USER_CODE — char(11) — 외래 키 → TBL_PROJECT_MAIN.USER_CODE — NOT NULL
  • COMPANY_CODE — char(11) — 외래 키 → TBL_PROJECT_MAIN.COMPANY_CODE — NOT NULL
  • COMMENT — text
  • COMMENT_IMG — varchar(255)
  • X_POINT — float(5,5)
  • Y_POINT — float(5,5)
  • ACTIVE — char(1)
  • C_ID — varchar(30)
  • C_TIME — datetime
  • M_ID — varchar(30)
  • M_TIME — datetime

TBL_PROJECT_MAIN

  • PROJECT_SEQ — int(11) — 기본 키 — NOT NULL
  • PROJECT_CODE — char(11) — 기본 키 — NOT NULL
  • USER_CODE — char(11) — 외래 키 → TBL_USER_MAIN.USER_CODE — NOT NULL
  • COMPANY_CODE — char(11) — 외래 키 → TBL_COMPANY_MAIN.COMPANY_CODE — NOT NULL
  • PROJECT_NAME — varchar(30)
  • POST_TITLE — varchar(50)
  • POST_CREATED — datetime
  • STEP_CODE — char(1)
  • RESULT_PDF_URL — varchar(100)
  • ACTIVE — char(1)
  • C_ID — varchar(30)
  • C_TIME — datetime
  • M_ID — varchar(30)
  • M_TIME — datetime
  • Field

TBL_PROJECT_SNAPSHOT

  • PROJECT_SNAPSHOT_SEQ — int(11) — 기본 키 — NOT NULL
  • PROJECT_SNAPSHOT_CODE — char(11) — 기본 키 — NOT NULL
  • PROJECT_CODE — char(11) — 외래 키 → TBL_PROJECT_MAIN.PROJECT_CODE — NOT NULL
  • USER_CODE — char(11) — 외래 키 → TBL_PROJECT_MAIN.USER_CODE — NOT NULL
  • COMPANY_CODE — char(11) — 외래 키 → TBL_PROJECT_MAIN.COMPANY_CODE — NOT NULL
  • COMMUNICATION_SNAPSET_CODE — char(11) — 외래 키 → TBL_COMMUNICATION_SNAPSET.COMMUNICATION_SNAPSET_CODE — NOT NULL
  • SNAPSHOT_NAME — varchar(30)
  • ACTIVE — char(1)
  • C_ID — varchar(30)
  • C_TIME — datetime
  • M_ID — varchar(30)
  • M_TIME — datetime

TBL_TEMPLATE_BLOCK

  • BLOCK_SEQ — int(11) — 기본 키 — NOT NULL
  • BLOCK_CODE — char(11) — 기본 키 — NOT NULL
  • BLOCK_NAME — varchar(30)
  • ACTIVE — char(1)
  • C_ID — varchar(30)
  • C_TIME — datetime
  • M_ID — varchar(30)
  • M_TIME — datetime

TBL_TEMPLATE_MAIN

  • TEMPLATE_SEQ — int(11) — 기본 키 — NOT NULL
  • TEMPLATE_CODE — char(11) — 기본 키 — NOT NULL
  • TEMPLATE_NAME — varchar(50)
  • ACTIVE — char(1)
  • C_ID — varchar(30)
  • C_TIME — datetime
  • M_ID — varchar(30)
  • M_TIME — datetime

TBL_TEXT_MAIN

  • TEXT_CODE — char(11) — 기본 키 — NOT NULL
  • TEXT_TITLE — varchar(20)
  • TEXT_DESCRIPTION — text
  • TEXT_USE — char(1)
  • C_ID — varchar(30)
  • C_TIME — datetime
  • M_ID — varchar(30)
  • M_TIME — datetime

TBL_USER_COMPANY_LEVEL

  • USER_COMPANY_LEVEL_SEQ — int(11) — 기본 키 — NOT NULL
  • USER_CODE — char(11) — 외래 키 → TBL_USER_MAIN.USER_CODE — NOT NULL
  • COMPANY_CODE — char(11) — 외래 키 → TBL_COMPANY_MAIN.COMPANY_CODE — NOT NULL
  • USER_LEVEL_CODE — char(11) — 외래 키 → TBL_USER_LEVEL.USER_LEVEL_CODE — NOT NULL

TBL_USER_INVITE

  • INVITE_SEQ — int(11) — 기본 키 — NOT NULL
  • USER_CODE — char(11) — 외래 키 → TBL_USER_MAIN.USER_CODE — NOT NULL
  • COMPANY_CODE — char(11) — 외래 키 → TBL_COMPANY_MAIN.COMPANY_CODE — NOT NULL
  • USER_INVITE_EMAIL — varchar(50)
  • C_ID — varchar(30)
  • C_TIME — datetime
  • M_ID — varchar(30)
  • M_TIME — datetime

TBL_USER_LEVEL

  • USER_LEVEL_CODE — char(11) — 기본 키 — NOT NULL
  • USER_LEVEL_TITLE — varchar(20)
  • USER_LEVEL_DESCRIPTION — varchar(50)
  • C_ID — varchar(30)
  • C_TIME — datetime
  • M_ID — varchar(30)
  • M_TIME — datetime

TBL_USER_MAIN

  • USER_CODE — char(11) — 기본 키 — NOT NULL
  • USER_EMAIL — varchar(50)
  • REFRESH_TOKEN — varchar(255)
  • USER_NICKNAME — varchar(10)
  • PHONE_NUM — varchar(15)
  • JOB_POSITION — varchar(20)
  • ACTIVE — char(1)
  • SNS_TYPE — varchar(10)
  • USER_TYPE — char(1)
  • C_ID — varchar(30)
  • C_TIME — datetime
  • M_ID — varchar(30)
  • M_TIME — datetime