달소녀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)