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