Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CLIENT (ClientNo, Name, Sex, DOB, Address, Phone, Email, Occupation, MaritalStatus, Spouse, Anniversary)
- CCONDITION (ClientNo, Condition)
- RESERVATION (ResNo, ResDate, NoOfGuests, StartDate, EndDate, ClientNo, Status)
- ACTIVITY (ActivityID, ActName, ActDescription, ActRate, RiskLevel)
- OUTDOOR_ACTIVITY (ActivityID)
- INDOOR_ACTIVITY (ActivityID, Location, OpeningHours)
- ACCOMMODATION (RoomNo, LevelNo, AccStatus, ConnectedRoomNo, AccTypeID)
- ACCOMMODATION_TYPE (AccTypeID, AccTypeName, AccTypeRate, NoOfBeds)
- EQUIPMENT (EquipmentID, EquipName, Stock, NextInspection)
- SUPPLIER (BillerCode, BusinessName, ContactPerson, Phone)
- SUPPLIES (EquipmentID, BillerCode)
- USES_EQUIPMENT (ActivityID, EquipmentID)
- CLIENT_PREFERENCE (ClientNo, ActivityID)
- RESERVATION_ACCOMMODATION (ResNo, RoomNo)
- ACTIVITY_SUPERVISOR (SupervisorID)
- OUTDOOR_INSTRUCTOR (InstructorID, InstrName, InstrPhone, SupervisorID)
- IFIELD (InstructorID, Field)
- MASSEUSE (MasseuseID, MassName, MassPhone, Area, SupervisorID)
- SWIMMING_INSTRUCTOR (SwimmerID, SwimName, SwimPhone, SupervisorID)
- SUPERVISION (ResNo, ActivityID, SupervisorID, Day, Time)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement