TickeTeam
Tables (9)
game (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- home_team_id (Key2) — bigint — Foreign key → team.Key — NOT NULL
- away_team_id (Key3) — bigint — Foreign key → team.Key — NOT NULL
- stadium_id (Key4) — bigint — Foreign key → stadium.id — NOT NULL
- match_day (Field3) — datetime — NOT NULL
reservation (Untitled8)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (id) — bigint — Foreign key → user.id — NOT NULL
- game_id (Key2) — bigint — Foreign key → game.id — NOT NULL
- reserved_at (Field) — datetime — NOT NULL
- reservation_code (Field2) — varchar(50) — NOT NULL
seat (Untitled5)
- id (Key) — bigint — Primary key — NOT NULL
- game_id (Key2) — bigint — Foreign key → game.id — NOT NULL
- seat_template_id (Key3) — bigint — Foreign key → seat_template.id — NOT NULL
- status (Field3) — varchar(20) — NOT NULL
seat_template (Untitled7)
- id (Key) — bigint — Primary key — NOT NULL
- stadium_id (Key2) — bigint — Foreign key → stadium.id — NOT NULL
- seat_type (Field6) — varchar(50) — NOT NULL
- seat_section (Field2) — varchar(50) — NOT NULL
- seat_block (Field3) — varchar(50) — NOT NULL
- seat_row (Field) — varchar — NOT NULL
- seat_num (Field4) — int
section_pricing (Untitled6)
- id (Key) — bigint — Primary key — NOT NULL
- stadium_id (Key2) — bigint — Foreign key → stadium.id — NOT NULL
- seat_section (Field2) — varchar(50) — NOT NULL
- price (Field3) — int — NOT NULL
stadium (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(30) — NOT NULL
team (Untitled3)
- Key — Primary key — NOT NULL
- name (Field) — varchar(50) — NOT NULL
ticket (Untitled4)
- id (Key) — bigint — Primary key — NOT NULL
- reservation_id (Key2) — bigint — Foreign key → reservation.id — NOT NULL
- seat_id (Field3) — bigint — NOT NULL
- price (Field5) — int — NOT NULL
- issued_at (Field4) — datetime — NOT NULL
user (예매자)
- id — bigint — Primary key — NOT NULL
- favorite_team (Key) — bigint — Foreign key → team.Key — NOT NULL
- user_name (Field) — varchar(20) — NOT NULL
- email (Field3) — varchar(100) — NOT NULL
- password (Field4) — varchar(100) — NOT NULL
- is_deleted (Field8) — boolean — NOT NULL
- created_at (Field6) — datetime — NOT NULL
- updated_at (Field7) — datetime — NOT NULL