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