haeum

Tables (3)

Location

  • location_id — INT — Primary key
  • zone_name — VARCHAR(50)

Person

  • person_id — INT — Primary key
  • gender — VARCHAR(10)
  • age_group — VARCHAR(20)

Visit

  • visit_id — INT — Primary key
  • person_id (person_id2) — INT — Foreign key → Person.person_id
  • location_id (location_id2) — INT — Foreign key → Location.location_id
  • timestamp — TIMESTAMP