티켓팀플 - 2023-08-27 21:43:58

테이블 (5)

member

  • pk (id) — bigint — 기본 키 — NOT NULL
  • Field (login_id) — varchar(20) — NOT NULL
  • Field2 (password) — varchar(40) — NOT NULL
  • Field3 (name) — varchar(20) — NOT NULL
  • Field4 (address) — varchar(300) — NOT NULL
  • Field5 (age) — int — NOT NULL
  • Field6 (gender) — tinyint — NOT NULL
  • Field7 (phone_number) — varchar(20) — NOT NULL

reservation

  • pk (id) — bigint — 기본 키 — NOT NULL
  • fk (member_id) — bigint — 외래 키 → member.pk — NOT NULL — unique
  • Field (total_price) — bigint — NOT NULL

reservation_seat

  • pk_fk (seat_id) — bigint — 외래 키 → seat.pk — NOT NULL
  • pk_fk (concert_date) — date — 외래 키 → seat.pk_fk — NOT NULL
  • pk_fk (reservation_id) — bigint — 외래 키 → reservation.pk — NOT NULL

seat

  • pk (id) — bigint — 기본 키 — NOT NULL
  • pk_fk (concert_date) — date — 기본 키 — NOT NULL
  • fk (ticket_id) — bigint — 외래 키 → ticket.pk — unique
  • Field (seat_num) — varchar(20) — NOT NULL
  • Field2 (seat_type) — varchar(20) — NOT NULL

ticket

  • pk (id) — bigint — 기본 키 — NOT NULL
  • fk (member_id) — bigint — 외래 키 → member.pk — NOT NULL
  • pk (reservation_id) — bigint — 외래 키 → reservation.pk — NOT NULL
  • Field (uuid) — varchar(20) — NOT NULL
  • Field2 (concert_date) — date — NOT NULL
  • Field3 (sicket_status) — tinyint — NOT NULL