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