TIMO

Tables (16)

baseball_club

  • baseball_club_id — bigint — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • home — enum — NOT NULL
  • logo_image_url — varchar(500)
  • venue_id — bigint — NOT NULL

baseball_game

  • baseball_game_id — bigint — Primary key — NOT NULL
  • game_date — datetime — NOT NULL
  • open_at — datetime — NOT NULL
  • status — enum — NOT NULL
  • home_club_id — bigint — NOT NULL
  • away_club_id — bigint — NOT NULL
  • venue_id — bigint — NOT NULL

concert

  • concert_id — bigint — Primary key — NOT NULL
  • title — varchar(200) — NOT NULL
  • genre — enum — NOT NULL
  • poster_url — varchar(500)
  • video_url — varchar(500)
  • description — text
  • sale_type — enum
  • age_rating — enum — NOT NULL
  • status — enum — NOT NULL
  • view_count — int — NOT NULL

concert_schedule

  • concert_schedule_id — bigint — Primary key — NOT NULL
  • start_date — datetime — NOT NULL
  • end_date — datetime — NOT NULL
  • open_at — datetime — NOT NULL
  • status — enum — NOT NULL
  • venue_id — bigint — NOT NULL
  • concert_id — bigint — NOT NULL

exhibition

  • exhibition_id — bigint — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • start_date — date — NOT NULL
  • end_date — date — NOT NULL
  • open_at — datetime — NOT NULL
  • poster_url — varchar(500)
  • view_count — int — NOT NULL
  • total_quantity — Int — NOT NULL
  • remaining_quantity — Int — NOT NULL
  • genre — enum — NOT NULL
  • description — text
  • sale_type — enum
  • age_rating — enum — NOT NULL
  • status — enum — NOT NULL
  • venue_id — bigint — NOT NULL

football_club

  • football_club_id — bigint — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • home — enum — NOT NULL
  • image_url — varchar(500)
  • venue_id — bigint — NOT NULL

football_game

  • football_game_id — bigint — Primary key — NOT NULL
  • game_date — datetime — NOT NULL
  • open_at — datetime — NOT NULL
  • status — enum — NOT NULL
  • home_club_id — bigint — NOT NULL
  • away_club_id — bigint — NOT NULL
  • venue_id — bigint — NOT NULL

member

  • member_id — bigint — Primary key — NOT NULL — NOT_NULL
  • member_key — varchar(36) — NOT NULL
  • role — enum — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255)
  • status — enum — NOT NULL
  • provider — enum — NOT NULL
  • provider_id — varchar(255)

payment

  • payment_id — bigint — Primary key — NOT NULL
  • pg_transaction_id — varchar(100)
  • amount — int — NOT NULL
  • status — enum — NOT NULL
  • method — enum — NOT NULL
  • reservation_id — bigint — NOT NULL

queue_entry

  • queue_entry_id — bigint — Primary key — NOT NULL
  • schedule_type — enum — NOT NULL
  • schedule_id — bigint — NOT NULL
  • rank — int — NOT NULL
  • status — enum — NOT NULL
  • member_id — bigint — NOT NULL — NOT_NULL

reservation

  • reservation_id — bigint — Primary key — NOT NULL
  • event_type — enum — NOT NULL
  • event_ref_id — bigint — NOT NULL
  • ticket_quantity — int — NOT NULL
  • status — enum — NOT NULL
  • total_price — int — NOT NULL
  • member_id — bigint — NOT NULL — NOT_NULL

reservation_seat

  • reservation_seat_id — bigint — Primary key — NOT NULL
  • event_type — eunm — NOT NULL
  • event_ref_id — bigint — NOT NULL
  • reservation_id — bigint — NOT NULL
  • seat_id — bigint — NOT NULL

seat

  • seat_id — bigint — Primary key — NOT NULL
  • seat_row — int — NOT NULL
  • seat_col — int — NOT NULL
  • seat_type — enum — NOT NULL
  • section_id — bigint — NOT NULL

seat_hold

  • seat_hold_id — bigint — Primary key — NOT NULL
  • schedule_type — enum — NOT NULL
  • schedule_id — bigint — NOT NULL
  • status — enum — NOT NULL
  • expires_at — datetime — NOT NULL
  • seat_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL — NOT_NULL
  • reservation_id — bigint — NOT NULL

section

  • section_id — bigint — Primary key — NOT NULL
  • name — varchar(50) — NOT NULL
  • grade — enum — NOT NULL
  • price — int — NOT NULL
  • seat_count — int — NOT NULL
  • venue_id — bigint — NOT NULL

venue

  • venue_id — bigint — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • city — enum — NOT NULL
  • address — varchar(255) — NOT NULL
  • type — enum — NOT NULL
  • total_seat_count — int — NOT NULL
  • image_url — varchar(500)