ITWILL_2nd

Tables (5)

CONCERTS

  • CONCERTID — NUMBER
  • TITLE — VARCHAR2(200)
  • CATEGORY — VARCHAR2(100)
  • LOCATION — VARCHAR2(200)
  • CONCERTDATE — DATE
  • STARTTIME — VARCHAR2(20)
  • CREATEDAT — DATE
  • IMAGE — VARCHAR2(300)

RESERVATIONS

  • RESERVATIONID — NUMBER
  • USERID — NUMBER
  • CONCERTID — NUMBER
  • SEATID — NUMBER
  • RESERVEDATE — DATE
  • STATUS — VARCHAR2(20)

REVIEW

  • REVIEWID — NUMBER
  • USERID — NUMBER
  • RESERVATIONID — NUMBER
  • SCORE — NUMBER
  • CONTENT — VARCHAR2(1000)

SEATS

  • SEATID — NUMBER
  • CONCERTID — NUMBER
  • SEATNUMBER — VARCHAR2(20)
  • SEATTYPE — VARCHAR2(50)
  • PRICE — NUMBER
  • ISAVAILABLE — VARCHAR2(10)
  • USERID — NUMBER

USERS

  • ID — NUMBER
  • NAME — VARCHAR2(100)
  • USERID — VARCHAR2(100)
  • PW — VARCHAR2(100)
  • PHONE — VARCHAR2(20)