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)