tick3et

테이블 (5)

concert

  • concert_id — unsigned — 기본 키 — NOT NULL
  • hall_id — unsigned — 외래 키 → hall.hall_id — NOT NULL
  • cncr_title — varchar(100)
  • cncr_img — varchar(100)
  • cncr_date — datetime
  • cncr_price — int
  • cncr_cancel_date — datetime
  • fan_cd — int

customer

  • customer_id — unsigned
  • cust_name — varchar(5)
  • cust_birth — datetime
  • cust_email — varchar(100)
  • cust_pwd — varchar(100)
  • cust_pwd_temp — VARCHAR(255)
  • fan_id — int
  • fan_cd — int
  • cust_role — TinyInt(1)

hall

  • hall_id — unsigned — 기본 키 — NOT NULL
  • hall_name — varchar(10)
  • Field2 — VARCHAR(255)
  • Field — VARCHAR(255)
  • Field3 — VARCHAR(255)

ticket

  • ticket_id — unsigned — 기본 키 — NOT NULL
  • concert_id — unsigned — 외래 키 → concert.concert_id — NOT NULL
  • hall_id — unsigned — 외래 키 → concert.hall_id — NOT NULL
  • ticket_seat — varchar(10)
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • Field4 — VARCHAR(255)
  • Field5 — VARCHAR(255)

예약 정보 (reservation)