erd home
Tables (10)
Appliance
- ApplianceID — VARCHAR(10)
- Name — VARCHAR(50)
- Brand — VARCHAR(30)
- LocationRoomID — VARCHAR(10)
Car
- CarID — VARCHAR(10)
- Model — VARCHAR(50)
- Color — VARCHAR(20)
- OwnerID — VARCHAR(10)
CleaningActivity
- ActivityID — VARCHAR(10)
- RoomID — VARCHAR(10)
- DoneByID — VARCHAR(10)
- Date — DATE
Expense
- ExpenseID — VARCHAR(10)
- Amount — DECIMAL(10,2)
- Category — VARCHAR(30)
- PaidByID — VARCHAR(10)
FamilyMember
- MemberID — VARCHAR(10)
- Name — VARCHAR(50)
- Age — INT
- Role — VARCHAR(20)
HobbyActivity
- HobbyID — VARCHAR(10)
- Name — VARCHAR(50)
- Location — VARCHAR(50)
- MemberID — VARCHAR(10)
Meal
- MealID — VARCHAR(10)
- Type — VARCHAR(20)
- CookedByID — VARCHAR(10)
- Time — DATETIME
Pet
- PetID — VARCHAR(10)
- Name — VARCHAR(30)
- Type — VARCHAR(20)
- OwnerID — VARCHAR(10)
Room
- RoomID — VARCHAR(10)
- Type — VARCHAR(20)
- Size — INT
- OwnerID — VARCHAR(10)
Schedule
- ScheduleID — VARCHAR(10)
- Title — VARCHAR(100)
- DateTime — DATETIME
- MemberID — VARCHAR(10)