MINIproject
Tables (7)
COUNTRY
- CNUM — NUMBER — Primary key
- CNAME — NVARCHAR2(20)
HOTELS
- HNUM — NUMBER — Primary key
- SNUM (SNUM2) — NUMBER — Foreign key → S_CLUB.SNUM
- HNAME — NVARCHAR2(100)
- HPRICE — NUMBER
- HLOCATION — NVARCHAR2(200)
PAYMENT
- PNUM — NUMBER — Primary key
- RNUM (RNUM2) — NUMBER — Foreign key → RESERVATION.RNUM
- TID — NVARCHAR2(30) — Foreign key → TMEMBER.TID
- RNUM — NUMBER
- hhh — NVARCHAR2(10)
RESERVATION
- RNUM — NUMBER — Primary key
- HNUM — NUMBER — Foreign key → HOTELS.HNUM
- DNUM — NUMBER — Foreign key → SCHEDULE.DNUM
- TID — NVARCHAR2(30) — Foreign key → TMEMBER.TID
- PAYMENT — NUMBER
SCHEDULE
- DNUM — NUMBER — Primary key
- SNUM — NUMBER — Foreign key → S_CLUB.SNUM
- DDATE — DATE
- AMOUNT — NUMBER
S_CLUB
- SNUM — NUMBER — Primary key
- CNUM — NUMBER — Foreign key → COUNTRY.CNUM
- CLUB_NAME — NVARCHAR2(50) — NOT NULL
- STADIUM — NVARCHAR2(100)
TMEMBER
- TID — NVARCHAR2(30) — Primary key
- TPW — NVARCHAR2(30) — NOT NULL
- TNAME — NVARCHAR2(10)
- TAGE — NUMBER
- TPHONE — NVARCHAR2(13)
- TEMAIL — NVARCHAR2(50)
- TPOINT — NUMBER