test
Tables (6)
TB_COMMON_BOARD
- BOARD_ID — NUMBER — NOT NULL
- TITLE — VARCHAR2(255) — NOT NULL
- CONTENT — CLOB — NOT NULL
- BOARD_TYPE — NUMBER
- START_DT — DATE
- END_DT — DATE
- REG_DT — TIMESTAMP(6)
- UPD_DT — TIMESTAMP(6)
- REG_ID — VARCHAR2(50) — NOT NULL
- CHG_DT — VARCHAR2(50)
TB_COMMON_CODES
- CODE_ID — NUMBER — NOT NULL
- CODE_GB — VARCHAR2(5) — NOT NULL
- CODE_VALUE — VARCHAR2(5) — NOT NULL
- CODE_NM — VARCHAR2(50)
- PARENT_CODE_ID — NUMBER
- REG_DT — TIMESTAMP(6)
- CHG_DT — TIMESTAMP(6)
TB_COMPANY
- COMPANY_ID — NUMBER — NOT NULL — 회사
- COMPANY_NAME — VARCHAR2(100) — NOT NULL — 회사명
- COMPANY_CODE — VARCHAR2(20) — 회사
- STATUS — VARCHAR2(10) — NOT NULL — 회사
- REG_DT — TIMESTAMP(6) — NOT NULL — 회사
- CHG_DT — TIMESTAMP(6) — 마지막
TB_SMS_ACCOUNT_INTEGRATION
- IDX — NUMBER — NOT NULL
- SMS_COM — VARCHAR2(20) — NOT NULL
- CALLER_NUMBER — VARCHAR2(15) — NOT NULL
- USER_ID — VARCHAR2(15) — NOT NULL
- ISSUE_NO — NUMBER — NOT NULL
- ISSUER_ID — VARCHAR2(10) — NOT NULL
- SERVICE_TYPE — VARCHAR2(10) — NOT NULL
- REG_DT — TIMESTAMP(6) — NOT NULL
- CHG_DT — TIMESTAMP(6)
TB_USERS
- USER_ID — VARCHAR2(50) — NOT NULL — 사용자
- EMAIL — VARCHAR2(100) — NOT NULL — 사용자
- PHONE_NUMBER — VARCHAR2(15) — NOT NULL — 사용자
- PASSWORD — VARCHAR2(255) — NOT NULL — 사용자
- FULL_NAME — VARCHAR2(100) — NOT NULL — 사용자
- STATUS — VARCHAR2(10) — NOT NULL — 사용자
- EMAIL_VERIFIED — CHAR — NOT NULL — 이메일
- PHONE_VERIFIED — CHAR — NOT NULL — 휴대폰
- REG_DT — TIMESTAMP(6) — NOT NULL — 사용자
- CHG_DT — TIMESTAMP(6) — 마지막
- LAST_LOGIN — DATE — 마지막
- COMPANY_ID — NUMBER — 문자사업자
TB_VALID_PHONE_NUMBERS
- IDX — NUMBER — NOT NULL
- PHONE_NUMBER — VARCHAR2(15) — NOT NULL
- CURRENT_CARRIER — VARCHAR2(20)
- CARRIER_TYPE — VARCHAR2(10)
- USER_TYPE — VARCHAR2(10)
- IS_BLOCK — NUMBER(1)
- REG_DT — TIMESTAMP(6)
- CHG_DT — TIMESTAMP(6)