객패

테이블 (6)

chat_room

  • chat_room_id — INTEGER
  • chat_room_name — VARCHAR(100) — NOT NULL
  • is_group_chat — BOOLEAN
  • created_at — TIMESTAMP
  • last_message_time — TIMESTAMP
  • last_message_preview — VARCHAR(255)

chat_room_member

  • chat_room_id — INTEGER — 기본 키 — NOT NULL
  • member_id — INTEGER — 기본 키 — NOT NULL
  • joined_at — TIMESTAMP

friend

  • member_id — INTEGER — 기본 키 — NOT NULL
  • friend_id — INTEGER — 기본 키 — NOT NULL
  • created_at — TIMESTAMP

friend_request

  • request_id — INTEGER
  • sender_id — INTEGER — NOT NULL
  • receiver_id — INTEGER — NOT NULL
  • message — VARCHAR(255)
  • status — VARCHAR(20)
  • created_at — TIMESTAMP

member

  • member_id — INTEGER
  • user_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20)
  • role — VARCHAR(20)

message

  • message_id — INTEGER
  • chat_room_id — INTEGER — NOT NULL
  • sender_id — INTEGER — NOT NULL
  • message_content — TEXT — NOT NULL
  • created_at — TIMESTAMP