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)