sad

Tables (3)

booking (예매)

  • booking_id (예매_ID) — bigint — Primary key — NOT NULL
  • member_id (회원_ID) — bigint — Foreign key → member.member_id — NOT NULL
  • show_id (공연_ID) — bigint — Foreign key → show.show_id — NOT NULL
  • status (예매 상태) — varchar
  • revered_at (예매시간) — date

member (회원)

  • member_id (회원_ID) — bigint — Primary key — NOT NULL
  • email (이메일) — varchar
  • username (사용자이름) — varchar

show (공연)

  • show_id (공연_ID) — bigint — Primary key — NOT NULL
  • title (공연제목) — varchar
  • description (설명) — varchar