달소녀ver2

테이블 (7)

ActionLog

  • log_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • action_type — VARCHAR(50) — NOT NULL
  • skill_id — BIGINT
  • delta — INT
  • timestamp — TIMESTAMP

CharacterSkill

  • skill_id — BIGINT
  • character_id — BIGINT — NOT NULL
  • skill_name — VARCHAR(100) — NOT NULL
  • effect — TEXT
  • cooldown — INT — NOT NULL

GameCharacter

  • character_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(50) — NOT NULL

GameHistory

  • game_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • winner_id — BIGINT — NOT NULL
  • loser_id — BIGINT — NOT NULL
  • final_score — INT
  • played_at — TIMESTAMP

GameRoom

  • room_id — BIGINT
  • player1_id — BIGINT — NOT NULL
  • player2_id — BIGINT — NOT NULL
  • time_limit — INT
  • player1_save_point — INT
  • player2_save_point — INT
  • status — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

User

  • user_id — BIGINT
  • google_id — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • win_count — INT
  • loss_count — INT
  • created_at — TIMESTAMP

UserCharacter

  • user_character_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • character_id — BIGINT — NOT NULL
  • UNIQUE(user_id, — character_id)