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)