shinhan7
Tables (5)
BOOKING
- BOOKING_ID — NUMBER — Primary key — NOT NULL
- USER_ID — VARCHAR2(30) — Foreign key → USERS.USER_ID — NOT NULL
- SCHEDULE_ID — NUMBER — Foreign key → CONCERT_SCHEDULE.SCHEDULE_ID — NOT NULL
- SEAT_ID — NUMBER — Foreign key → SEAT.SEAT_ID — NOT NULL
- BOOKING_DATE — DATE — NOT NULL
CONCERT
- CONCERT_ID — NUMBER — Primary key — NOT NULL
- TITLE — VARCHAR2(100) — NOT NULL
- PLACE — VARCHAR2(100) — NOT NULL
- PRICE — NUMBER — NOT NULL
CONCERT_SCHEDULE
- SCHEDULE_ID — NUMBER — Primary key — NOT NULL
- CONCERT_ID — NUMBER — Foreign key → CONCERT.CONCERT_ID — NOT NULL
- CONCERT_DATE — DATE — NOT NULL
SEAT
- SEAT_ID — NUMBER — Primary key — NOT NULL
- SCHEDULE_ID — NUMBER — Foreign key → CONCERT_SCHEDULE.SCHEDULE_ID — NOT NULL
- SEAT_NUMBER — VARCHAR2(10) — NOT NULL
- IS_BOOKED — CHAR(1) — NOT NULL
USERS
- USER_ID — VARCHAR2(30) — Primary key — NOT NULL
- PASSWORD — VARCHAR2(100) — NOT NULL
- NAME — VARCHAR2(30) — NOT NULL
- PHONE — VARCHAR2(20)