ㅁㄴㅇㄹ

Tables (6)

Copy Of chat_invited_user (CopyOfchat_invited_user)

  • message_id (invite_id) — int — Primary key — NOT NULL
  • room_id (room_id2) — int — Foreign key → chat_room.room_id — NOT NULL

chat_invited_user

  • invite_id — int — Primary key — NOT NULL
  • room_id — int — NOT NULL
  • invite_user — varchar(20) — NOT NULL

chat_room

  • room_id — int — Primary key — NOT NULL
  • room_name — varchar(100) — NOT NULL

hwet_board

  • board_id — int — Primary key — NOT NULL
  • writer — varchar(20) — Foreign key → user_info.user_id — NOT NULL
  • title — varchar(50) — NOT NULL
  • category — varchar(50) — NOT NULL
  • link — varchar(400) — NOT NULL
  • content — varchar(1000) — NOT NULL
  • created_at — datetime — NOT NULL
  • hit — int — NOT NULL
  • updated_at — datetime

hwet_board_reply

  • reply_id — int — Primary key — NOT NULL
  • board_id — int — Foreign key → hwet_board.board_id — 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

user_info

  • user_id — varchar(20) — Primary key — NOT NULL
  • user_pw — varchar(16) — NOT NULL
  • user_name — varchar(20)
  • user_birth — date
  • user_nickname — varchar(40)
  • user_gender — enum('남성','여성')
  • user_tlno — varchar(20)
  • user_joindate — date