CHAT_AND_BOARD
Tables (7)
BOARD
- Key (NO) — CHAR(6) — Primary key — NOT NULL
- Key (CATEGORY_NO) — CHAR(6) — Foreign key → CATEGORY.Key — NOT NULL
- Key (WRITER_NO) — CHAR(6) — Foreign key → MEMBER.Key — NOT NULL
- Field (TITLE) — VARCHAR(100)
- Field2 (CONTENT) — VARCHAR(4000)
- Field3 (HIT_COUNT) — INT(11)
- Field4 (CREATE_DATE) — DATETIME
- Field5 (UPDATE_DATE) — DATETIME
- Field (USE_YN) — CHAR(1)
CAHT_ROOM (CHAT_ROOM)
- Key (NO) — CHAR(6) — Primary key — NOT NULL
- Field (TITLE) — VARCHAR(100)
- Field (CREATE_DATE) — DATETIME
- Field (MAX_COUNT) — INT(11)
- Field (PRIVATE_YN) — CHAR(1)
- Field (PASSWORD) — VARCHAR(100)
- Field (USE_YN) — CHAR(1)
CATEGORY
- Key (NO) — CHAR(6) — Primary key — NOT NULL
- Field (NAME) — VARCHAR(30)
- Field2 (USE_YN) — CHAR(1)
CHAT
- Key (NO) — CHAR(6) — Primary key — NOT NULL
- Key (ROOM_NO) — CHAR(6) — Foreign key → CAHT_ROOM.Key — NOT NULL
- Key (MEMBER_NO) — CHAR(6) — Foreign key → MEMBER.Key — NOT NULL
- Field (CHAT_MESSAGE) — VARCHAR(1000)
- Field (USE_YN) — CHAR(1)
COMMENT
- Key (NO) — CHAR(6) — Primary key — NOT NULL
- Key (BOARD_NO) — CHAR(6) — Foreign key → BOARD.Key — NOT NULL
- Key (WRITER_NO) — CHAR(6) — Foreign key → MEMBER.Key — NOT NULL
- Key (PARENT_NO) — CHAR(6) — Foreign key → COMMENT.Key — NOT NULL
- Field (MESSAGE) — VARCHAR(1000)
- Field (CREATE_DATE) — DATETIME
- Field (USE_YN) — CHAR(1)
MEMBER
- Key (NO) — CHAR(6) — Primary key — NOT NULL
- Field (ID) — VARCHAR(30)
- Field2 (PASSWORD) — VARCHAR(100)
- Field3 (NAME) — VARCHAR(30)
- Field4 (GENDER) — CHAR(1)
- Field (PHONE) — CHAR(11)
- Field (EMAIL) — VARCHAR(40)
- Field (BIRTH_DATE) — DATETIME
- Field (USE_YN) — CHAR(1)
Untitled (CHAT_MEMBER)
- Key (MEMBER_NO) — CHAR(6) — Foreign key → MEMBER.Key — NOT NULL
- Key (CHAT_ROOM_NO) — CHAR(6) — Foreign key → CAHT_ROOM.Key — NOT NULL
- Field (JOIN_DATE) — DATETIME
- Field2 (GRADE) — CHAR(6)