erd test

Tables (23)

alarm_members

  • id — int — Primary key — NOT NULL
  • Alarm_id — int — Foreign key → alarms.Host_id — NOT NULL
  • User_id — int — Foreign key → users.id — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

alarm_play_records

  • User_id — int — Foreign key → users.id — NOT NULL
  • Alarm_result_id — int — Foreign key → game_results.id — NOT NULL
  • created_at — datetime(6) — NOT NULL

alarms

  • id — int — Primary key — NOT NULL
  • Host_id — int — Primary key — NOT NULL
  • Game_id — int — Primary key — NOT NULL
  • time — varchar(255) — NOT NULL
  • is_repeated — varchar(255) — NOT NULL
  • is_private — tinyint — NOT NULL
  • music_volume — int — NOT NULL
  • member_count — int — NOT NULL
  • max_member — int — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)
  • Game_channel_id — int

assets

  • id — int — Primary key — NOT NULL
  • coin — int — NOT NULL
  • is_premium — tinyint — NOT NULL
  • User_id — int

coin_use_records

  • id — int — Primary key — NOT NULL
  • purchase_time — datetime — NOT NULL
  • used_coin — int — NOT NULL
  • remain_coin — int — NOT NULL
  • User_id — int

game_channel

  • id — int — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • player_count — int — NOT NULL
  • Alarm_id — int — NOT NULL
  • created_at — datetime(6) — NOT NULL

game_play

  • id — int — Primary key — NOT NULL
  • Alarm_id — int

game_play_images

  • id — int — Primary key — NOT NULL
  • Keyword_id — int
  • url — varchar(255) — NOT NULL

game_play_keywords

  • id — int — Primary key — NOT NULL
  • keyword — varchar(255) — NOT NULL
  • image_count — int — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • Game_id — int

game_play_single

  • id — int — Primary key — NOT NULL

game_purchase_records

  • User_id — int — Primary key — NOT NULL
  • Game_id — int — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

game_results

  • id — int — Primary key — NOT NULL
  • Alarm_id — int — Foreign key → alarms.id — NOT NULL
  • Host_id — int — Foreign key → alarms.Host_id — NOT NULL
  • Game_id — int — Foreign key → games.id — NOT NULL
  • start_time — date — NOT NULL
  • end_time — date — NOT NULL
  • play_time — int — NOT NULL
  • is_bot_used — tinyint — NOT NULL
  • trial — int — NOT NULL
  • is_cleared — tinyint — NOT NULL
  • Game_channel_id — int

game_used_images

  • Game_play_id — int — Primary key — NOT NULL
  • Game_play_image_id — int — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL

games

  • id — int — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • category — varchar(255) — NOT NULL
  • price — int — NOT NULL
  • description — varchar(500) — NOT NULL
  • thumbnail_url — varchar(255)
  • rating — int — NOT NULL
  • min_player — int
  • max_player — int
  • keyword_count — int — NOT NULL

games_ratings

  • id — int — Primary key — NOT NULL
  • score — int — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • User_id — int
  • Game_id — int

games_screenshots

  • id — int — Primary key — NOT NULL
  • screenshot_url — varchar(2048) — NOT NULL
  • Game_id — int

mate_request_records

  • Sender_id — int — Primary key — NOT NULL
  • type — varchar(255) — NOT NULL
  • sended_at — datetime(6) — NOT NULL
  • Receiver_id — int

mates

  • id — int — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)
  • Sender_id — int
  • Receiver_id — int

notifications

  • id — int — Primary key — NOT NULL
  • User_id — int
  • title — varchar(255) — NOT NULL
  • body — varchar(500) — NOT NULL
  • created_at — datetime(6) — NOT NULL

premium_orders

  • id — int — Primary key — NOT NULL
  • price — int — NOT NULL
  • pay_type — varchar(255) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • successed_at — datetime — NOT NULL
  • expired_at — datetime — NOT NULL
  • next_order_at — datetime — NOT NULL
  • User_id — int
  • Premium_id — int

premium_refund

  • id — int — Primary key — NOT NULL
  • price — int — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • successed_at — datetime — NOT NULL
  • User_id — int
  • Premium_order_id — int

premiums

  • id — int — Primary key — NOT NULL
  • name — varchar(30) — NOT NULL
  • price — int — NOT NULL
  • description — varchar(500) — NOT NULL
  • thumbnail_img_url — varchar(2048) — NOT NULL

users

  • id — int — Primary key — NOT NULL
  • kakao_id — bigint — NOT NULL
  • email — varchar(320) — NOT NULL
  • name — varchar(30) — NOT NULL
  • nickname — varchar(30) — NOT NULL
  • bio — varchar(500) — NOT NULL
  • profile_image_url — varchar(2048) — NOT NULL
  • thumbnail_image_url — varchar(2048) — NOT NULL
  • is_default_image — tinyint — NOT NULL
  • age_range — varchar(255)
  • gender — varchar(255)
  • is_admin — tinyint — NOT NULL
  • device_token — varchar(255)
  • refresh_token — varchar(255)
  • kakao_access_token — varchar(255) — NOT NULL
  • kakao_refresh_token — varchar(255) — NOT NULL
  • enroll_date — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)
  • Asset_id — int