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)