DEEPDIVE
Tables (7)
Coupon (쿠폰)
- coupon_id (쿠폰ID) — BIGINT — Primary key
- count (수량) — INT
- discount (할인금액) — INT
- expired_date (만료일자) — LOCALDATETIME
CouponOrders (쿠폰 주문)
- couponorders_id (쿠폰주문ID) — BIGINT — Primary key
- user_id (사용자ID) — BIGINT — Foreign key → User.user_id
- coupon_id (쿠폰ID) — BIGINT — Foreign key → Coupon.coupon_id
Event (공연)
- event_id (공연ID) — BIGINT — Primary key
- place_id (장소ID) — BIGINT — Foreign key → Place.place_id
- name (공연이름) — VARCHAR
- event_time (공연날짜) — LOCALDATETIME
Place (장소)
- place_id (장소ID) — BIGINT — Primary key
- name (장소이름) — VARCHAR
- seat_number (좌석개수) — INT
Seat (좌석)
- seat_id (좌석ID) — BIGINT — Primary key
- ticket_id (티켓ID) — BIGINT — Foreign key → Ticket.ticket_id
- event_id (공연ID) — BIGINT — Foreign key → Event.event_id
- seat_number (좌석번호) — INT
Ticket (티켓)
- ticket_id (티켓ID) — BIGINT — Primary key
- user_id (사용자ID) — BIGINT — Foreign key → User.user_id
- ticket_order_time (티켓주문시간) — LOCALDATETIME
User (사용자)
- user_id (사용자ID) — BIGINT — Primary key
- username (이름) — VARCHAR
- email (이메일) — VARCHAR
- password (비밀번호) — VARCHAR