temp

Tables (11)

Appointment

  • appointment_id — INT
  • person1_id — INT
  • person2_id — INT
  • hobby_id — INT
  • time — DATETIME

Car

  • car_id — INT
  • model — VARCHAR(100)
  • year — INT
  • owner_id — INT

Event

  • event_id — INT
  • title — VARCHAR(100)
  • date — DATE
  • location_id — INT

EventParticipation

  • event_id — INT
  • person_id — INT

FamilyMember

  • person_id — INT
  • relation — VARCHAR(50)

Hobby

  • hobby_id — INT
  • name — VARCHAR(100)
  • category — VARCHAR(50)

HobbyTool

  • tool_id — INT
  • name — VARCHAR(100)
  • type — VARCHAR(50)
  • used_with — INT
  • owner_id — INT
  • room_id — INT

Neighbor

  • person_id — INT
  • distance — INT

Person

  • person_id — INT
  • name — VARCHAR(100)
  • age — INT
  • type — VARCHAR(50)

Pet

  • pet_id — INT
  • name — VARCHAR(100)
  • species — VARCHAR(50)
  • owner_id — INT

Room

  • room_id — INT
  • name — VARCHAR(100)
  • floor — INT