easyplus
Tables (14)
BaseTimeEntity
- created_date — DATETIME
- modified_date — DATETIME
CustomMenu
- custom_menu_id (pk) — BIGINT — Primary key
- menu_name — VARCHAR(255)
- category (depth) — VARCHAR(255)
- user_id (pk2) — BIGINT — Foreign key → User.user_id
Game
- game_id — BIGINT — Primary key
- name (kor_name) — VARCHAR(255)
GameUser
- game_user_id — BIGINT — Primary key
- nickname — VARCHAR(255)
- user_id (pk) — BIGINT — Foreign key → User.user_id
OrderGameScore (Score)
- order_game_score_id (fk) — BIGINT — Primary key
- value — INT
- talkback — TINYINT
Setting
- setting_id (pk) — BIGINT — Primary key
- user_id (fk) — BIGINT — Foreign key → User.user_id
- youtube (youtube_seq) — INT
- news (news_seq) — INT
- game (game_seq) — INT
- settings (settings_seq) — INT
StoryEnding
- story_ending_key (pk) — BIGINT — Primary key
- story_game_id (fk) — BIGINT — Foreign key → StoryGame.story_game_id
- title — VARCHAR(255)
- content — TEXT
StoryGame
- story_game_id (pk) — BIGINT — Primary key
- content — JSON
User
- user_id (pk) — BIGINT — Primary key
- name — VARCHAR(255)
- login_type — VARCHAR(255)
- email — VARCHAR(255)
- account_status — VARCHAR(255)
- role — VARCHAR(255)
UserEnding
- user_ending_id (pk) — BIGINT — Primary key
- story_ending_key (ending_fk) — BIGINT — Foreign key → StoryEnding.story_ending_key
- game_user_id (game_user_fk) — BIGINT — Foreign key → GameUser.game_user_id
fcm
- fcm_id (pk) — BIGINT — Primary key
- user_id (fk) — BIGINT — Foreign key → User.user_id
- token — VARCHAR(255)
- device_id — VARCHAR(255)