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