티켓팀플 - 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