자, 이게 표준어야

자, 이게 표준어야 서비스의 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)