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