toudeuk

Tables (4)

ClickLog (클릭로그)

  • clicklog_id (Key) — Primary key — NOT NULL
  • order (Field) — int
  • id (Key2) — Foreign key → User.user_id — NOT NULL
  • game_id (Key3) — Foreign key → Game.game_id — NOT NULL

Game (게임)

  • game_id (Key) — Primary key — NOT NULL
  • round (Field) — int
  • count (Field2) — int
  • reward_log_id (Key2) — Foreign key → rewardLog.reward_log_id — NOT NULL

User (유저)

  • user_id (Key) — Primary key — NOT NULL
  • cash (잔여캐시) — int
  • reward_log_id (Key2) — Foreign key → rewardLog.reward_log_id — NOT NULL

rewardLog (보상로그)

  • reward_log_id (Key) — Primary key — NOT NULL
  • reward (Field) — int
  • rewardType (Field2) — Enum
  • clickCount (Field3) — int