issues
search
AYYYang
/
CPSC304_SuperRent
For CPSC 304 project part 3 implementation
0
stars
0
forks
source link
populate tables
#2
Closed
AYYYang
closed
5 years ago
AYYYang
commented
5 years ago
[x] Branch (location, city)
[x] VehicleType(vtname, features, wrate, drate, hrate, wirate, dirate, hirate, krate))
[x] Vehicle (vid, vlicense, make, model, year, color, odometer, status, vtname, location, city)
[x] EquipType(etname, drate, hrate)
[x] Equipment (eid, etname, status, location, city)
[x] EforV(etname, vtname)
[ ]
[ ]
[ ] Customer (cellphone, name, address, dlicense)
[ ] ClubMember (cellphone, points, fees) ** May not be necessary
[ ] Reservation (confNo, vtname, cellphone, fromDate, fromTime, toDate, toTime)
[ ] Reserve_Includes (confNo, etname) *** both foreign keys
[ ] Rent(rid, vid, cellphone, fromDate, fromTime, toDate, toTime, odometer,ExpDate, cardNo,confNo)
[ ] Card(cardName, cardNo, Expdate)
[ ] Rent_Includes (rid, eid)
[ ] Return(rid, date, time, odometer, fulltank, value)
[ ] TimePeriod(fromDate, fromTime, toDate, toTime)
[ ] Account(username,password)
[ ]