aigaret

Tables (4)

account_user (Untitled)

  • user_no (Key) — int — Primary key — NOT NULL
  • username (Field)
  • password (Field2)
  • name (Field3)
  • age (Field4)
  • image (Field5)
  • goal_time_per_week (Field6)

games_game (Untitled2)

  • game_no (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)
  • video_url (Field3)

games_record (Untitled4)

  • record_no (Key) — Primary key — NOT NULL
  • game_no (Key2) — Foreign key → games_game.game_no — NOT NULL
  • user_no (Key3) — int — Foreign key → account_user.user_no — NOT NULL
  • Field

games_report (Untitled3)

  • report_no (Key) — Primary key — NOT NULL
  • user_no (Key3) — int — Foreign key → account_user.user_no — NOT NULL
  • game_no (Key2) — Foreign key → games_game.game_no — NOT NULL
  • playtime_per_week (Field)
  • year (Field2)
  • month (Field3)
  • week (Field4)