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)