RdsDiagram
Marina
MarinaNum: VARCHAR(2)
MarinaName: VARCHAR(20)
Address: VARCHAR(20)
City: VARCHAR(15)
State: CHARACTER(2)
Zip: VARCHAR(5)
Owner
OwnerNum: VARCHAR(5)
LastName: VARCHAR(20)
FirstName: VARCHAR(20)
Address: VARCHAR(20)
City: VARCHAR(15)
State: CHARACTER(2)
Zip: VARCHAR(5)
MarinaSlip
SlipID: VARCHAR(3)
MarinaNum: VARCHAR(2)
SlipNum: VARCHAR(3)
Length: VARCHAR(2)
RentalFee: DECIMAL(6,2)
BoatName: VARCHAR(15)
BoatType: VARCHAR(15)
OwnerNum: VARCHAR(5)
ServiceRequest
ServiceID: CHARACTER(3)
SlipID: VARCHAR(3)
CategoryNum: CHARACTER(3)
Description: VARCHAR(100)
Status: VARCHAR(50)
EstHours: VARCHAR(3)
SpentHours: VARCHAR(3)
NextServiceDate: DATE
ServiceCategory
CategoryNum: CHARACTER(3)
CategoryDescription: VARCHAR(50)