물리데이터

테이블 (4)

AW_USER_INFO

  • USER_UUID — CHAR(32) — 기본 키 — NOT NULL
  • USER_EMAIL — VARCHAR2(200)
  • USER_NAME — VARCHAR2(200)
  • USER_PASSWD — VARCHAR2(200)
  • USER_TYPE — CHAR(1) — NOT NULL
  • SNS_ID — VARCHAR2(200)
  • CERT_YN — CHAR(1) — NOT NULL
  • CERT_UUID — CHAR(32)
  • REGDATE — DATE — NOT NULL
  • AGREE01 — CHAR(1)
  • AGREE02 — CHAR(1)
  • USER_EMAIL2 — VARCHAR2(200)
  • AGREE03 — CHAR(1)
  • NEWS_YN — CHAR(1)

Copy Of AW_USER_INFO (AW_MAIN)

  • USER_EMAIL (FILE_SEQ_1) — NUMBER
  • USER_NAME (FILE_SEQ_2) — NUMBER
  • USER_PASSWD (FILE_SEQ_3) — NUMBER
  • USER_TYPE (FILE_SEQ_4) — NUMBER
  • SNS_ID (FILE_SEQ_5) — NUMBER
  • CERT_YN (TITLE_1) — VARCHAR2(4000)
  • CERT_UUID (TITLE_2) — VARCHAR2(4000)
  • REGDATE (TITLE_3) — VARCHAR2(4000)
  • AGREE01 (TITLE_4) — VARCHAR2(4000)
  • AGREE02 (TITLE_5) — VARCHAR2(4000)
  • USER_EMAIL2 (CONTENTS_SEQ) — NUMBER
  • AGREE03 (REG_ID) — VARCHAR2(30)
  • NEWS_YN (REG_DT) — DATE
  • Field (MOD_ID) — VARCHAR2(30)
  • Field (MOD_DT) — DATE
  • Field (LINK_1) — VARCHAR2(500)
  • Field (LINK_2) — VARCHAR2(500)
  • Field (LINK_3) — VARCHAR2(500)
  • Field (LINK_4) — VARCHAR2(500)
  • Field (LINK_5) — VARCHAR2(500)
  • Field (USE_YN_1) — CHAR(1)
  • Field (USE_YN_2) — CHAR(1)
  • Field (USE_YN_3) — CHAR(1)
  • Field (USE_YN_4) — CHAR(1)
  • Field (USE_YN_5) — CHAR(1)
  • Field (LOCATION_1) — VARCHAR2(25)
  • Field (LOCATION_2) — VARCHAR2(25)
  • Field (LOCATION_3) — VARCHAR2(25)

NEWS_INFO (AW_NEWS_LT)

  • SEQ — NUMBER — 기본 키 — NOT NULL
  • TITLE — VARCHAR2(4000) — NOT NULL
  • CONTENTS (CONTENT) — CLOB
  • REG_ID — VARCHAR2(32) — NOT NULL
  • REG_DT — DATE — NOT NULL
  • MOD_ID — VARCHAR2(32)
  • MOD_DT — DATE

NOTICE (AW_NOTICE)

  • SEQ — CHAR(32) — 기본 키 — NOT NULL
  • TITLE — VARCHAR2(4000) — NOT NULL
  • CONTENTS — CLOB
  • REG_ID — VARCHAR2(32) — NOT NULL
  • REG_DT — DATE — NOT NULL
  • MOD_ID — VARCHAR2(32)
  • MOD_DT — DATE