3imple

Tables (5)

accounts

  • Key — Foreign key → ingame.Key — NOT NULL
  • 방번호 (room_id) — Foreign key → room.방번호 — NOT NULL
  • username
  • password
  • name
  • email
  • follow
  • message

chatting

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → accounts.Key — NOT NULL
  • 방번호 (room_id) — Foreign key → accounts.방번호 — NOT NULL
  • contents

ingame

  • Key — Primary key — NOT NULL
  • is_daytime — Boolean
  • vote — Boolean
  • mafia
  • citizen
  • doctor
  • now_seconds — Integer

message

  • id — Primary key — NOT NULL
  • user_id
  • contents
  • room

room

  • 방번호 (room_id) — Primary key — NOT NULL
  • message_id
  • is_start
  • Field