최종

테이블 (4)

chat_invited_user

  • invite_id — int — 기본 키 — NOT NULL
  • room_id — int — NOT NULL
  • invite_user — varchar(20) — NOT NULL

chat_message

  • message_id — int — 기본 키 — NOT NULL
  • room_id — int — NOT NULL
  • sender_id — varchar(20) — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime — NOT NULL

hwet_board_reply

  • reply_id — int — 기본 키 — NOT NULL
  • board_id — int — NOT NULL
  • writer — varchar(20) — NOT NULL
  • writer_nick — varchar(40) — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • content — varchar(3000)
  • positive_count — int
  • negative_count — int

min_pol

  • pol_no — int — 기본 키 — NOT NULL
  • user_id — varchar(20) — NOT NULL
  • user_nickname — varchar(40) — NOT NULL
  • title — varchar(255) — NOT NULL
  • regdate — datetime — NOT NULL
  • moddate — datetime — NOT NULL
  • read_cnt — int