CHAT

Tables (3)

CHAT_MESSAGE

  • Key (MESSAGE_ID) — INTEGER — Primary key — NOT NULL
  • CHAT_ROOM_ID — INTEGER — Foreign key → CHAT_ROOM.CHAT_ROOM_ID — NOT NULL
  • MESSAGE — STRING
  • MESSAGE_TIME — DATETIME
  • USER_ID — INTEGER

CHAT_ROOM

  • CHAT_ROOM_ID — INTEGER — Primary key — NOT NULL
  • HOST_ID — INTEGER
  • MBTI — STRING
  • MBTI_CHECK — BOOLEAN
  • MAX_NUM — INTEGER
  • CREATION_TIME — DATETIME
  • NUM — INTEGER

Untitled (CHAT_ACCESS)

  • Key (ACCESS_ID) — INTEGER — Primary key — NOT NULL
  • CHAT_ROOM_ID — INTEGER — Foreign key → CHAT_ROOM.CHAT_ROOM_ID — NOT NULL
  • Field (USER_ID) — INTEGER
  • Field (ACCESS_TIME) — DATETIME