demo

Tables (14)

admin_action_log

  • id — BIGSERIAL
  • admin_id — BIGINT — NOT NULL
  • action_type — VARCHAR(255)
  • description — VARCHAR(255)
  • target_type — VARCHAR(255)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

bid

  • id — BIGSERIAL
  • bidder_id — BIGINT — Foreign key → member.id — NOT NULL
  • transfer_id — BIGINT — Foreign key → transfer.id — NOT NULL
  • bid_amount — INTEGER
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

booking

  • id — BIGSERIAL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • performance_schedule_id — BIGINT — Foreign key → performance_schedule.id — NOT NULL
  • order_id — VARCHAR(255) — NOT NULL
  • payment_key — VARCHAR(255)
  • payment_method — VARCHAR(255)
  • status — VARCHAR(255)
  • seat_count — INTEGER
  • total_amount — INTEGER
  • cancellation_fee — INTEGER
  • cancelled_date — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

booking_seat

  • id — BIGSERIAL
  • booking_id — BIGINT — Foreign key → booking.id — NOT NULL
  • seat_id — BIGINT — Foreign key → seat.id — NOT NULL
  • booking_number — VARCHAR(255) — NOT NULL
  • price — INTEGER
  • status — VARCHAR(255)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

coin

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → member.id — NOT NULL
  • transaction_type — VARCHAR(255)
  • amount — INTEGER
  • remain_coin — INTEGER
  • description — VARCHAR(255)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

member

  • id — BIGSERIAL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(255)
  • birth — VARCHAR(255)
  • sex — VARCHAR(255)
  • provider_type — VARCHAR(255)
  • provider_id — VARCHAR(255)
  • role — VARCHAR(255)
  • coin_balance — INTEGER
  • is_active — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • deleted_at — TIMESTAMPTZ

payment

  • id — BIGSERIAL
  • booking_id — BIGINT — Foreign key → booking.id — NOT NULL
  • payment_key — VARCHAR(255) — NOT NULL
  • method — VARCHAR(255)
  • status — VARCHAR(255)
  • amount — INTEGER
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

performance

  • id — BIGSERIAL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • genre — VARCHAR(255)
  • venue_name — VARCHAR(255)
  • venue_address — VARCHAR(255)
  • poster_image_url — VARCHAR(255)
  • description_url — VARCHAR(255)
  • duration_minute — INTEGER
  • age_restriction — INTEGER
  • status — VARCHAR(255)
  • performance_start_date — TIMESTAMP
  • performance_end_date — TIMESTAMP
  • booking_open_date — TIMESTAMP
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

performance_schedule

  • id — BIGSERIAL
  • performance_id — BIGINT — Foreign key → performance.id — NOT NULL
  • performance_date — DATE
  • performance_time — TIME
  • status — VARCHAR(255)
  • total_seat — INTEGER
  • available_seat — INTEGER
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

refund

  • id — BIGSERIAL
  • payment_id — BIGINT — Foreign key → payment.id — NOT NULL
  • status — VARCHAR(255)
  • refund_amount — INTEGER
  • cancellation_fee — INTEGER
  • reason — VARCHAR(255)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

review

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → member.id — NOT NULL
  • performance_id — BIGINT — Foreign key → performance.id — NOT NULL
  • booking_id — BIGINT — Foreign key → booking.id — NOT NULL
  • content — TEXT
  • rating — DOUBLE — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

review_report

  • id — BIGSERIAL
  • reporter_id — BIGINT — Foreign key → member.id — NOT NULL
  • review_id — BIGINT — Foreign key → review.id — NOT NULL
  • report_reason — VARCHAR(255)
  • report_content — VARCHAR(255)
  • status — VARCHAR(255)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

seat

  • id — BIGSERIAL
  • performance_schedule_id — BIGINT — Foreign key → performance_schedule.id — NOT NULL
  • number — INTEGER — NOT NULL
  • grade — VARCHAR(255)
  • zone — VARCHAR(255)
  • floor — INTEGER
  • row — INTEGER
  • x — VARCHAR(255)
  • y — VARCHAR(255)
  • price — INTEGER
  • status — VARCHAR(255)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

transfer

  • id — BIGSERIAL
  • seller_id — BIGINT — Foreign key → member.id — NOT NULL
  • booking_id — BIGINT — Foreign key → booking.id — NOT NULL
  • status — VARCHAR(255)
  • current_highest_bid — INTEGER
  • transfer_end_date_time — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ