ㅇㅇ

Tables (7)

order

  • ticket_count — int — NOT NULL — 티켓수
  • order_price — int — NOT NULL — 총가격
  • order_status — varchar(20) — NOT NULL — 상태
  • ticket_id — bigint — NOT NULL
  • user_id — bigint — Foreign key → user.user_id — NOT NULL
  • ticket_id (ticket_id2) — bigint — Foreign key → ticket.ticket_id — NOT NULL

seat

  • Field (id) — bigint
  • Field (seat_type) — varchar(100)
  • Field (seat_number) — varchar(100)
  • Field (price) — bigint

seat2

  • id — bigint — Primary key — NOT NULL
  • seat_number — varchar(20) — NOT NULL
  • seat_type — varchar(20) — NOT NULL
  • price — int — NOT NULL

ticket

  • ticket_id — bigint — Primary key — NOT NULL
  • ticket_name — varchar(100) — NOT NULL — 티켓명
  • concert_date — datetime — NOT NULL — 콘서트 날짜
  • price — int — NOT NULL — 가격
  • created_at — datetime — NOT NULL — 티켓발급날짜
  • Field

ticket2

  • ticket_id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • seat_id — bigint — NOT NULL
  • uuid — varchar(15) — NOT NULL
  • ticket_name — varchar(100) — NOT NULL
  • concert_date — datetime — NOT NULL
  • created_at — datetime — NOT NULL
  • ticket_status — varchar(20) — NOT NULL
  • id (user2_id) — bigint — Foreign key → user2.id — NOT NULL
  • id (seat2_id) — bigint — Foreign key → seat2.id — NOT NULL

user

  • user_id — bigint — Primary key — NOT NULL
  • login_id — varchar(20) — NOT NULL
  • name — varchar(20) — NOT NULL — 유저명
  • password — varchar(20) — NOT NULL — 유저 비밀번호
  • address — varchar(300) — NOT NULL — 주소
  • age — int — NOT NULL — 나이
  • gender — tinyint — NOT NULL — 성별
  • phone_number — varchar(20) — NOT NULL — 연락처

user2

  • id — bigint — Primary key — NOT NULL
  • login_id — varchar(20) — NOT NULL
  • name — varchar(20) — NOT NULL
  • password — varchar(20) — NOT NULL
  • address — varchar(300) — NOT NULL
  • age — int — NOT NULL
  • gender — tinyint — NOT NULL
  • phone_number — varchar(20) — NOT NULL