sample

Tables (6)

agreement_type (Untitled7)

  • agreement_name VARCHAR(45) (Key) — Primary key — NOT NULL
  • description VARCHAR(45) (Field)

company (Untitled2)

  • company_id INT (Key) — Primary key — NOT NULL
  • name VARCHAR(45) (Field)
  • person_id INT (Key2) — Foreign key → person.person_id INT — NOT NULL

employment_condition (Untitled5)

  • person_id INT (Key2) — Foreign key → person.person_id INT — NOT NULL
  • company_id INT (Key3) — Foreign key → company.company_id INT — NOT NULL
  • condition_id INT (Key4) — Foreign key → company.company_id INT — NOT NULL
  • agreement_name VARCHAR(45) (Key) — Foreign key → agreement_type.agreement_name VARCHAR(45) — NOT NULL

family (Untitled3)

  • person_id INT (Key) — Foreign key → person.person_id INT — NOT NULL
  • family_type_name VARCHAR(45) (Key4) — Foreign key → family_type.family_type_name VARCHAR(45) — NOT NULL

family_type (Untitled4)

  • family_type_name VARCHAR(45) (Key) — Primary key — NOT NULL

person (Untitled)

  • person_id INT (Key) — Primary key — NOT NULL
  • name VARCHAR(45) (Field)
  • surname VACHAR(45) (Field2)
  • birthday DATE (Field3)
  • sex VARCHAR(6) (Field4)
  • Field5