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)