자, 이게 표준어야
자, 이게 표준어야 서비스의 ERD 입니다.
테이블 (18)
achievement
- achievement_id — int(11) — 기본 키 — NOT NULL
- code — varchar(10) — NOT NULL
- name — varchar(100) — NOT NULL
- type — enum('ETC','MISSION','REWARD') — NOT NULL
- category — enum('HIDDEN','MULTI','PLAY','SCORE','SERVICE') — NOT NULL
- description — varchar(255) — NOT NULL
- url — varchar(500)
board
- board_id — int(11) — 기본 키 — NOT NULL
- member_id — int(11) — 외래 키 → member.member_id — NOT NULL
- title — varchar(200) — NOT NULL
- content — tinytext
- view_count — int(11) — NOT NULL
- like_count — int(11) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
board_like
- board_like_id — int(11) — 기본 키 — NOT NULL
- board_id — int(11) — 외래 키 → board.board_id — NOT NULL
- member_id — int(11) — 외래 키 → member.member_id — NOT NULL
- liked_at — datetime — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
comment
- comment_id — int(11) — 기본 키 — NOT NULL
- content — tinytext — NOT NULL
- is_deleted — bit(1) — NOT NULL
- board_id — int(11) — 외래 키 → board.board_id — NOT NULL
- member_id — int(11) — 외래 키 → member.member_id — NOT NULL
- parent_comment_id — int(11) — 외래 키 → comment.comment_id
comment_like
- comment_like_id — int(11) — 기본 키 — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- comment_id — int(11) — 외래 키 → comment.comment_id — NOT NULL
- member_id — int(11) — 외래 키 → member.member_id — NOT NULL
fcm_token
- fcm_token_id — int — 기본 키 — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- last_seen_at — datetime(6) — NOT NULL
- token — varchar(512) — NOT NULL
- member_id — int — NOT NULL
file
- file_id — int(11) — 기본 키 — NOT NULL
- board_id — int(11) — 외래 키 → board.board_id — NOT NULL
- name — varchar(255) — NOT NULL
- extension — varchar(20) — NOT NULL
- url — varchar(1000) — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
game_list
- game_id — int(11) — 기본 키 — NOT NULL
- room_id — int(11) — 외래 키 → multi_room.room_id — NOT NULL
- host_member_id — int(11) — 외래 키 → member.member_id — NOT NULL
- winner_member_id — int(11) — 외래 키 → member.member_id
- played_at — datetime — NOT NULL
game_participant
- game_participant_id — int(11) — 기본 키 — NOT NULL
- game_id — int(11) — 외래 키 → game_list.game_id — NOT NULL
- member_id — int(11) — 외래 키 → member.member_id — NOT NULL
- role — enum('HOST','GUEST') — NOT NULL
- joined_at — datetime — NOT NULL
member
- member_id — int(11) — 기본 키 — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- nickname — varchar(20) — NOT NULL
- region — varchar(20) — NOT NULL
- age — int(11) — NOT NULL
- win_rate — double
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- profile_image_url — varchar(255)
member_achievement
- member_achievement_id — int(11) — 기본 키 — NOT NULL
- member_id — int(11) — 외래 키 → member.member_id — NOT NULL
- achievement_id — int(11) — 외래 키 → achievement.achievement_id — NOT NULL
- achieved_at — datetime — NOT NULL
multi_history
- multi_history_id — int(11) — 기본 키 — NOT NULL
- game_id — int(11) — 외래 키 → game_list.game_id — NOT NULL
- member_id — int(11) — 외래 키 → member.member_id — NOT NULL
- sentence_ids — longtext — NOT NULL
- avg_score — double — NOT NULL
- created_at — datetime — NOT NULL
multi_room
- room_id — int(11) — 기본 키 — NOT NULL
- host_member_id — int(11) — 외래 키 → member.member_id — NOT NULL
- guest_member_id — int(11) — 외래 키 → member.member_id
- title — varchar(255) — NOT NULL
- status — enum('CLOSED','PLAYING','WAITING') — NOT NULL
- created_at — datetime — NOT NULL
- is_public — tinyint(1) — NOT NULL
notice
- notice_id — int — 기본 키 — NOT NULL
- title — varchar(200) — NOT NULL
- content — longtext — NOT NULL
- is_pinned — tinyint(1) — NOT NULL
- is_deleted — tinyint(1) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
notification
- notification_id — int — 기본 키 — NOT NULL
- created_at — datetime(6) — NOT NULL
- is_read — bit — NOT NULL
- message — varchar(255) — NOT NULL
- target_id — bigint — NOT NULL
- target_type — enum — NOT NULL
- type — enum — NOT NULL
- receiver_member_id — int — NOT NULL
- sender_member_id — int
- updated_at — datetime(6)
ranking
- rank_id — int(11) — 기본 키 — NOT NULL
- member_id — int(11) — 외래 키 → member.member_id — NOT NULL
- best_accuracy — double
- best_intonation — double
sentence
- sentence_id — int(11) — 기본 키 — NOT NULL
- sentence — varchar(255)
- difficulty — enum('EASY','NORMAL','HARD') — NOT NULL
setting
- setting_id — bigint(20) — 기본 키 — NOT NULL
- member_id — int(11) — 외래 키 → member.member_id — NOT NULL
- mic_input_volume — int(11) — NOT NULL
- mic_device_id — varchar(255)
- cam_device_id — varchar(255)
- background_blur — tinyint(1) — NOT NULL
- mirror_mode — tinyint(1) — NOT NULL
- account_deactivated — tinyint(1) — NOT NULL
- deleted_account_status — tinyint(1) — NOT NULL
- profile_visibility — enum('PUBLIC','FRIENDS','PRIVATE') — NOT NULL
- friend_request_permission — enum('ALL','FRIENDS_OF_FRIENDS','NONE') — NOT NULL
- mute_shortcut — varchar(255)
- push_to_talk — varchar(255)
- noti_sound_enabled — tinyint(1) — NOT NULL
- noti_community_reply — tinyint(1) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- mute_shortcut_enabled — bit(1)
- push_to_talk_enabled — bit(1)