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)