전단자동화
테이블 (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