물리데이터
테이블 (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