test
Tables (17)
address
- id — INT
- name — VARCHAR(255) — NOT NULL
birth
- human_id — INT
- birth_place_type_id — INT
- request_human_id — INT
- birth_request_human_type_id — INT
- request_human_email — VARCHAR(255)
- request_human_phone_number — VARCHAR(20)
- request_date — DATE
- birth_datetime — DATETIME
birth_place_type
- id — INT
- name — VARCHAR(100)
birth_request_human_type
- id — INT
- name — VARCHAR(100)
certificate_request
- id — INT
- human_id — INT
- certificate_request_type_id — INT
- verification_number — VARCHAR(50) — NOT NULL
- certificate_request_date — DATE
certificate_request_type
- id — INT
- name — VARCHAR(100) — NOT NULL
death
- human_id — INT
- address_id — INT
- request_human_id — INT
- death_place_type_id — INT
- death_request_human_type_id — INT
- request_human_email — VARCHAR(255)
- request_human_phone_number — VARCHAR(20)
- request_date — DATE
- death_datetime — DATETIME
death_place_type
- id — INT
- name — VARCHAR(100)
death_request_human_type
- id — INT
- name — VARCHAR(100)
gender
- id — INT
- gender_type — VARCHAR(20) — NOT NULL
household
- id — INT
- householder_id — INT
- household_init_type_id — INT
- init_date — DATE
household_address
- id — INT
- household_id — INT
- address_id — INT
- init_date — DATE
household_init_type
- id — INT
- name — VARCHAR(100) — NOT NULL
household_participant
- human_id — INT
- household_id — INT
- household_participant_type_id — INT
household_participant_type
- id — INT
- name — VARCHAR(100) — NOT NULL
human
- id — INT — Primary key
- gender_id — INT
- address_id — INT
- name — VARCHAR(100) — NOT NULL
- social_security_number — VARCHAR(20) — NOT NULL
relationship
- id — INT — Primary key
- human_id — INT
- related_human_id — INT
- relationship_name — VARCHAR(100)
- id (id2) — INT — Foreign key → human.id