기말과제
테이블 (4)
Untitled (PERSON)
- Key (PersonID) — int(30) — 기본 키 — NOT NULL
- Field (nationality) — char(10)
- Field (person_name) — char(30)
Untitled (RENTCAR_COMPANY)
- Key (CompanyID) — int(30) — 기본 키 — NOT NULL
- Key (CarID) — int(30) — 외래 키 → Untitled2.Key — NOT NULL
- Field (CompanyName) — int(10)
- Key (rent_rate) — int(30) — NOT NULL
Untitled2 (RENTCAR)
- Key (CarID) — int(30) — 기본 키 — NOT NULL
- Field (ProductName) — char(30)
- Field (Date code) — int(10)
- Field (LimitSeat) — int(10)
- Field (CarCompany) — text
- Field (CarDescripition) — text
Untitled2 (BOOKING)
- Key (BookingDate) — int(30) — 기본 키 — NOT NULL
- Key (PersonID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (CarID) — int(30) — 외래 키 → Untitled2.Key — NOT NULL