test
Tables (8)
CMS_BOARD
- SITE_NO — NUMBER(*,0) — Primary key — NOT NULL
- BOARD_SEQ — NUMBER(*,0) — Primary key — NOT NULL
- BBS_SEQ — NUMBER — Primary key — NOT NULL
- P_BBS_SEQ — NUMBER
- SUBJECT — VARCHAR2(255) — NOT NULL
- SUBJECT_COLOR — VARCHAR2(30)
- CONTENTS — CLOB
- LINK_URL_YN — VARCHAR2(1)
- LINK_URL — VARCHAR2(255)
- VIDEO_URL — VARCHAR2(255)
- PASSWD — VARCHAR2(255)
- EMAIL — VARCHAR2(100)
- PHONE — VARCHAR2(20)
- CONTS_GBN — VARCHAR2(30)
- VIDEO_GBN — VARCHAR2(255)
- VALUE1 — VARCHAR2(255)
- VALUE2 — VARCHAR2(255)
- VALUE3 — CLOB
- REF_BBS_URL — VARCHAR2(255)
- REF_BBS_NM — VARCHAR2(255)
- CATE_SEQ — NUMBER(*,0)
- NOTICE_YN — VARCHAR2(1) — NOT NULL
- SECRET_YN — VARCHAR2(1) — NOT NULL
- EDITOR_YN — VARCHAR2(1)
- OPEN_YN — VARCHAR2(1) — NOT NULL
- START_DT — DATE
- END_DT — DATE
- TOP_START_DT — DATE
- TOP_END_DT — DATE
- STATUS — VARCHAR2(30)
- ORD_NO — NUMBER — NOT NULL
- HITS — NUMBER(*,0) — NOT NULL
- RECOMMS — NUMBER(*,0) — NOT NULL
- WRITER_NM — VARCHAR2(50)
- WRITE_DT — DATE — NOT NULL
- USE_YN — VARCHAR2(1)
- REG_DATE — DATE
- REG_USER_ID — VARCHAR2(30) — NOT NULL
- REG_IP — VARCHAR2(20) — NOT NULL
- UPT_DATE — DATE
- UPT_USER_ID — VARCHAR2(30)
- UPT_IP — VARCHAR2(20)
- DEF_DATE1 — DATE
- DEF_DATE2 — DATE
- DEF_DATE3 — DATE
- Field
- Field2
CMS_BOARD_AUTH
- SITE_NO — NUMBER(*,0) — Primary key — NOT NULL
- BOARD_SEQ — NUMBER(*,0) — Primary key — NOT NULL
- AUTH_CODE — VARCHAR2(30) — Primary key — NOT NULL
- READ_YN — VARCHAR2(1)
- WRITE_YN — VARCHAR2(1)
- REPLY_YN — VARCHAR2(1)
- COMMENT_YN — VARCHAR2(1)
- READ_DEPT — VARCHAR2(1000)
- WRITE_DEPT — VARCHAR2(1000)
- REPLY_DEPT — VARCHAR2(1000)
- COMMENT_DEPT — VARCHAR2(1000)
- USE_YN — VARCHAR2(1)
- REG_DATE — DATE
- REG_USER_ID — VARCHAR2(30) — NOT NULL
- REG_IP — VARCHAR2(20) — NOT NULL
- UPT_DATE — DATE
- UPT_USER_ID — VARCHAR2(30)
- UPT_IP — VARCHAR2(20)
CMS_BOARD_CATEGORY
- SITE_NO — NUMBER(*,0) — Primary key — NOT NULL
- BOARD_SEQ — NUMBER(*,0) — Primary key — NOT NULL
- CATE_SEQ — NUMBER(*,0) — Primary key — NOT NULL
- CATEGORY_NM — VARCHAR2(255) — NOT NULL
- ORD_NO — NUMBER(*,0) — NOT NULL
- DEL_YN — VARCHAR2(1) — NOT NULL
- REG_DATE — DATE
- REG_USER_ID — VARCHAR2(30) — NOT NULL
- REG_IP — VARCHAR2(20) — NOT NULL
- UPT_DATE — DATE
- UPT_USER_ID — VARCHAR2(30)
- UPT_IP — VARCHAR2(20)
CMS_BOARD_COMMENT
- SITE_NO — NUMBER(*,0) — Primary key — NOT NULL
- BOARD_SEQ — NUMBER(*,0) — Primary key — NOT NULL
- BBS_SEQ — NUMBER — Primary key — NOT NULL
- COMMENT_SEQ — NUMBER — Primary key — NOT NULL
- CONTENTS — CLOB — NOT NULL
- WRITER_NM — VARCHAR2(50)
- PASSWD — VARCHAR2(255)
- RECOMMS — NUMBER(*,0) — NOT NULL
- DEL_YN — VARCHAR2(1) — NOT NULL
- REG_DATE — DATE
- REG_USER_ID — VARCHAR2(30) — NOT NULL
- REG_IP — VARCHAR2(20) — NOT NULL
- UPT_DATE — DATE
- UPT_USER_ID — VARCHAR2(30)
- UPT_IP — VARCHAR2(20)
CMS_BOARD_CONF
- SITE_NO — NUMBER(*,0) — Primary key — NOT NULL
- BOARD_SEQ — NUMBER(*,0) — Primary key — NOT NULL
- BOARD_NM — VARCHAR2(225) — NOT NULL
- BOARD_TYPE — VARCHAR2(30) — NOT NULL
- USE_CATEGORY_YN — VARCHAR2(1) — NOT NULL
- USE_NOTICE_YN — VARCHAR2(1) — NOT NULL
- USE_USERINFO_YN — VARCHAR2(1) — NOT NULL
- USE_HITS_YN — VARCHAR2(1) — NOT NULL
- USE_SNS_YN — VARCHAR2(1) — NOT NULL
- USE_LIKE_YN — VARCHAR2(1) — NOT NULL
- USE_PREVNEXT_YN — VARCHAR2(1) — NOT NULL
- USE_REPLY_YN — VARCHAR2(1) — NOT NULL
- USE_COMMENT_YN — VARCHAR2(1) — NOT NULL
- USE_EDITOR_YN — VARCHAR2(1) — NOT NULL
- USE_PERIOD_YN — VARCHAR2(1) — NOT NULL
- USE_SECRET_YN — VARCHAR2(1) — NOT NULL
- USE_ATTACH_YN — VARCHAR2(1) — NOT NULL
- NOTICE_LIMIT — NUMBER(*,0)
- NOTICE_PERIOD_YN — VARCHAR2(1)
- PAGE_LEN — NUMBER(*,0)
- FILE_LIMIT — NUMBER(*,0)
- FILE_SIZE_LIMIT — NUMBER
- FORCE_SECRET_YN — VARCHAR2(1)
- SHOWTYPE — VARCHAR2(30)
- USE_YN — VARCHAR2(1)
- REG_DATE — DATE
- REG_USER_ID — VARCHAR2(30) — NOT NULL
- REG_IP — VARCHAR2(20) — NOT NULL
- UPT_DATE — DATE
- UPT_USER_ID — VARCHAR2(30)
- UPT_IP — VARCHAR2(20)
- USE_REG_DT_YN — VARCHAR2(1)
CMS_BOARD_FILE
- SITE_NO — NUMBER(*,0) — Primary key — NOT NULL
- BOARD_SEQ — NUMBER(*,0) — Primary key — NOT NULL
- BBS_SEQ — NUMBER — Primary key — NOT NULL
- FILE_SEQ — NUMBER(*,0) — Primary key — NOT NULL
- TYPE_CODE — VARCHAR2(30)
- FILE_ORG_NM — VARCHAR2(255)
- FILE_NM — VARCHAR2(255)
- FILE_SIZE — NUMBER
- USE_YN — VARCHAR2(1)
- REG_DATE — DATE
- REG_USER_ID — VARCHAR2(30) — NOT NULL
- REG_IP — VARCHAR2(20) — NOT NULL
- UPT_DATE — DATE
- UPT_USER_ID — VARCHAR2(30)
- UPT_IP — VARCHAR2(20)
CMS_BOARD_FUNC
- BOARD_TYPE — VARCHAR2(30) — Primary key — NOT NULL
- NOTICE_YN — VARCHAR2(1) — NOT NULL
- USERINFO_YN — VARCHAR2(1) — NOT NULL
- HITS_YN — VARCHAR2(1) — NOT NULL
- SNS_YN — VARCHAR2(1) — NOT NULL
- LIKE_YN — VARCHAR2(1) — NOT NULL
- PREVNEXT_YN — VARCHAR2(1) — NOT NULL
- REPLY_YN — VARCHAR2(1) — NOT NULL
- COMMENT_YN — VARCHAR2(1) — NOT NULL
- EDITOR_YN — VARCHAR2(1) — NOT NULL
- PERIOD_YN — VARCHAR2(1) — NOT NULL
- SECRET_YN — VARCHAR2(1) — NOT NULL
- ATTACH_YN — VARCHAR2(1) — NOT NULL
- USE_YN — VARCHAR2(1)
- REG_DATE — DATE
- REG_USER_ID — VARCHAR2(30) — NOT NULL
- REG_IP — VARCHAR2(20) — NOT NULL
- UPT_DATE — DATE
- UPT_USER_ID — VARCHAR2(30)
- UPT_IP — VARCHAR2(20)
- REG_DT_YN — VARCHAR2(1)
CMS_BOARD_LIKE
- SITE_NO — NUMBER(*,0) — Primary key — NOT NULL
- BOARD_SEQ — NUMBER(*,0) — Primary key — NOT NULL
- BBS_SEQ — NUMBER — Primary key — NOT NULL
- USER_ID — VARCHAR2(30) — Primary key — NOT NULL
- CHK_YN — VARCHAR2(1)
- REG_DATE — DATE
- REG_USER_ID — VARCHAR2(30) — NOT NULL
- REG_IP — VARCHAR2(20) — NOT NULL
- UPT_DATE — DATE
- UPT_USER_ID — VARCHAR2(30)
- UPT_IP — VARCHAR2(20)