MSG ERD
Tables (22)
article_images
- id — int(11) — Primary key — NOT NULL
- article_id — int(11) — Foreign key → articles.id — NOT NULL
- url — varchar(300) — NOT NULL
- uuid — varchar(100) — NOT NULL
- flag_mission — int(11)
article_likes
- id — int(11) — Primary key — NOT NULL
- article_id — int(11) — Foreign key → articles.id — NOT NULL
- user_id — int(11) — Foreign key → users.id — NOT NULL
- create_time — datetime — NOT NULL
article_reports
- id — int(11) — Primary key — NOT NULL
- article_id — int(11) — Foreign key → articles.id — NOT NULL
- from_user_id — int(11) — Foreign key → users.id — NOT NULL
- content — varchar(100)
- create_time — datetime — NOT NULL
articles
- id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → users.id — NOT NULL
- content — varchar(50)
- create_time — datetime — NOT NULL
- flag_private — int(11)
- modify_time — datetime — NOT NULL
- room_id — varchar(100) — Foreign key → rooms.id
- room_nickname — varchar(100)
comment_likes
- id — int(11) — Primary key — NOT NULL
- comment_id — int(11) — Foreign key → comments.id — NOT NULL
- user_id — int(11) — Foreign key → users.id — NOT NULL
- create_time — datetime — NOT NULL
comments
- id — int(11) — Primary key — NOT NULL
- article_id — int(11) — Foreign key → articles.id — NOT NULL
- user_id — int(11) — Foreign key → users.id — NOT NULL
- parent_comment_id — int(11) — Foreign key → comments.id
- content — varchar(500) — NOT NULL
- create_time — datetime — NOT NULL
- modify_time — datetime — NOT NULL
daily_missions
- id — int(11) — Primary key — NOT NULL
- participant_id — int(11) — Foreign key → participants.id — NOT NULL
- mission_id — int(11) — Foreign key → missions.id — NOT NULL
- day — int(11)
- try — int(11)
- flag_success — int(11)
- normal_vote — int(11) — Foreign key → participants.id
- mafia_vote — int(11) — Foreign key → participants.id
- doctor_vote — int(11) — Foreign key → participants.id
- reporter_vote — int(11) — Foreign key → participants.id
- article_id — int(11) — Foreign key → articles.id
first_nicknames
- id — varchar(50) — Primary key — NOT NULL
first_room_names
- id — varchar(100) — Primary key — NOT NULL
follows
- id — int(11) — Primary key — NOT NULL
- from_user_id — int(11) — Foreign key → users.id — NOT NULL
- to_user_id — int(11) — Foreign key → users.id — NOT NULL
- create_time — datetime — NOT NULL
jobs
- id — varchar(50) — Primary key — NOT NULL
- info — varchar(500) — NOT NULL
- image_url — varchar(300)
- image_uuid — varchar(100)
last_nicknames
- id — varchar(50) — Primary key — NOT NULL
last_room_names
- id — varchar(100) — Primary key — NOT NULL
missions
- id — int(11) — Primary key — NOT NULL
- normal — varchar(300)
- mafia — varchar(300)
nickname_images
- url — varchar(300) — Primary key — NOT NULL
- uuid — varchar(100) — NOT NULL
notifications
- id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → users.id — NOT NULL
- content — varchar(300) — NOT NULL
- create_time — datetime
participants
- id — int(11) — Primary key — NOT NULL
- room_id — varchar(100) — Foreign key → rooms.id — NOT NULL
- user_id — int(11) — Foreign key → users.id — NOT NULL
- last_message_id — varchar(100)
- flag_die — int(11) — NOT NULL
- flag_win — int(11) — NOT NULL
- job_id — varchar(50) — Foreign key → jobs.id
- image_url — varchar(300)
- nickname — varchar(100) — NOT NULL
- ability — int(11) — NOT NULL
room_images
- url — varchar(300) — Primary key — NOT NULL
- uuid — varchar(100) — NOT NULL
rooms
- id — varchar(100) — Primary key — NOT NULL
- last_message_id — varchar(100)
- data_type — varchar(100) — NOT NULL
- create_time — datetime — NOT NULL
- end_time — datetime
- start_time — datetime
- title — varchar(100) — NOT NULL
- image_url — varchar(300)
- flag_available — int(11) — NOT NULL
- flag_night — int(11) — NOT NULL
static_flag
- id — varchar(100) — Primary key — NOT NULL
- value — int(11) — NOT NULL
user_reports
- id — int(11) — Primary key — NOT NULL
- participant_id — int(11) — Foreign key → participants.id — NOT NULL
- to_user_id — int(11) — Foreign key → users.id — NOT NULL
- create_time — datetime — NOT NULL
users
- id — int(11) — Primary key — NOT NULL
- email_id — varchar(100) — NOT NULL
- email_password — varchar(100)
- nickname — varchar(50) — NOT NULL
- bio — varchar(100)
- provider — varchar(10)
- identifier — varchar(50)
- flag_identifier — int(11)
- flag_admin — int(11) — NOT NULL
- firebase_token — varchar(300)
- image_url — varchar(300)
- image_uuid — varchar(100)
- flag_private — int(11) — NOT NULL
- sign_up_time — datetime — NOT NULL
- sign_in_time — datetime