2-project
Tables (6)
game_genres
- id — BIGINT — Primary key — NOT NULL
- game_id — BIGINT — Foreign key → games.id — NOT NULL
- genre_id — BIGINT — Foreign key → genres.id — NOT NULL
game_libraries
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- game_id — BIGINT — Foreign key → games.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- platform — VARCHAR(30)
- started_at — DATE
- completed_at — DATE
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
games
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- release_date — DATE
- image_url — VARCHAR(1000)
- developer — VARCHAR(255)
- created_at — DATETIME — NOT NULL
genres
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
members
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
reviews
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- game_id — BIGINT — Foreign key → games.id — NOT NULL
- rating — TINYINT — NOT NULL
- content — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL