a
Tables (14)
address
- id — int — Foreign key → householdhead.id — NOT NULL
- address — varchar(30)
birth
- id2 — int — Foreign key → person.id — NOT NULL
- borndate — Datetime
- reportdate — Date
- reporterid — int — Foreign key → person.id — NOT NULL
- code — int — Foreign key → birthregistration.code — NOT NULL
- code2 — int — Foreign key → birthplace.code — NOT NULL
- id3 — int — Foreign key → person.id — NOT NULL
- id4 — int — Foreign key → person.id — NOT NULL
birthplace
- code — int — Primary key — NOT NULL
- place — varchar(10)
birthregistration
- code — int — Primary key — NOT NULL
- Field — varchar(10)
cause
- causecode — int — Primary key — NOT NULL
- causename — varchar(15)
death
- id2 — int — Foreign key → person.id — NOT NULL
- deathdate — Datetime
- placeaddress — varchar(40)
- reporterid — int — Foreign key → person.id — NOT NULL
- code — int — Foreign key → deathregistration.code — NOT NULL
- code2 — int — Foreign key → death_place.code — NOT NULL
death_place
- code — int — Primary key — NOT NULL
- place — varchar(10)
deathregistration
- code — int — Primary key — NOT NULL
- qualification — varchar(10)
familyrelation
- myid — int — Foreign key → person.id — NOT NULL
- familyid — int — Foreign key → person.id — NOT NULL
- code — int — Foreign key → relationcode.code — NOT NULL
household_detail
- id — int — Foreign key → householdhead.id — NOT NULL
- id2 — int — Foreign key → person.id — NOT NULL
- causecode — int — Foreign key → cause.causecode — NOT NULL
- report_date — Date
householdhead
- id — int — Foreign key → person.id — NOT NULL
person
- id — int — Primary key — NOT NULL
- name — varchar(20)
- rrno — varchar(15)
- phonenum — varchar(15)
- email — varchar(50)
- sexcode — char(1) — Foreign key → sex.sexcode — NOT NULL
relationcode
- code — int — Primary key — NOT NULL
- relation — varchar(10)
sex
- sexcode — int — Primary key — NOT NULL
- sexname — varchar(5)