KLO Board
Tables (7)
ATTACHMENTS (Untitled6)
- FILE_ID — INT — Primary key — NOT NULL
- BRD_ID — INT — Foreign key → BOARD.BRD_ID — NOT NULL
- ARTICLE_NO — INT — Foreign key → BOARD.ARTICLE_NO — NOT NULL
- FOLDER — VARCHAR(500)
- FULL_NM — VARCHAR(500) — NOT NULL
- DISP_NM — VARCHAR(256) — NOT NULL
- FILE_NM — VARCHAR(256) — NOT NULL
- EXT_NM — VARCHAR(50)
- FILE_SIZE — INT
- WRITER_ID — VARCHAR(50) — NOT NULL
- TEMP_YN — VARCHAR(1) — NOT NULL
- CREATE_DATE — DATE
- MODIFY_DATE — DATE
BOARD (Untitled5)
- ARTICLE_NO — INT — Primary key — NOT NULL
- BRD_ID — INT — Foreign key → BOARD_INFO.BRD_ID — NOT NULL
- CATEGORY_ID — INT — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
- TITLE — VARCHAR(200) — NOT NULL
- CONTENTS — VARCHAR(5000)
- WRITER_ID — VARCHAR(50) — NOT NULL
- HITS — INT — NOT NULL
- CREATE_DATE — DATETIME
- MODIFY_DATE — DATETIME
- MAIN_YN — VARCHAR(1) — NOT NULL
- FIX_YN — VARCHAR(1) — NOT NULL
- AUTH_GROUPS — VARCHAR(100) — NOT NULL
- GRP_NO — INT
- DEPTH — INT
- SEQ — INT
BOARD_INFO (Untitled4)
- BRD_ID — INT — Primary key — NOT NULL
- BRD_NM — VARCHAR(50) — NOT NULL
- USE_YN — VARCHAR(1) — NOT NULL
- DESCRIPTION — VARCHAR(200)
- DISP_ORDER — INT
- ALLOW_WRITE_GROUP_ID — VARCHAR(50)
- DISALLOW_WRITE_GROUP_ID — VARCHAR(50)
- CREATE_DATE — DATE
- MODIFY_DATE — DATE
CATEGORY (Untitled7)
- CATEGORY_ID — INT — Primary key — NOT NULL
- CATEGORY_NAME — VARCHAR(50) — NOT NULL
- ALLOW_GROUP_ID — VARCHAR(50)
- DISALLOW_GROUP_ID — VARCHAR(50)
COMMENTS (Untitled)
- COMMENT_NO — INT — Primary key — NOT NULL
- BRD_ID — INT — Foreign key → BOARD.BRD_ID — NOT NULL
- ARTICLE_NO — INT — Foreign key → BOARD.ARTICLE_NO — NOT NULL
- WRITER_ID — VARCHAR(50) — NOT NULL
- CONTENTS — VARCHAR(500)
- CREATE_DATE — DATETIME
- MODIFY_DATE — DATETIME
- GRP_NO — INT
- DEPTH — INT
- SEQ — INT
GROUP_INFO (Untitled2)
- GROUP_ID — INT — Primary key — NOT NULL
- GROUP_NM — VARCHAR(50) — NOT NULL
- CREATE_DATE — DATE
- MODIFY_DATE — DATE
USER_INFO (Untitled3)
- EMAIL — VARCHAR(50) — Primary key — NOT NULL
- PWD — VARCHAR(50) — NOT NULL
- NAME — VARCHAR(50) — NOT NULL
- GROUP_ID — INT — NOT NULL
- CREATE_DATE — DATE
- MODIFY_DATE — DATE