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