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

NaverArticle

    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

    Untitled

      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

      YahooArticle

        fcm

        • fcm_id (pk) — BIGINT — Primary key
        • user_id (fk) — BIGINT — Foreign key → User.user_id
        • token — VARCHAR(255)
        • device_id — VARCHAR(255)