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