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)