mission

Tables (7)

agreement_type

  • agreement name (agreement_name) — varchar(45) — Primary key — NOT NULL
  • description — varchar(45)

company

  • company id (company_id) — number — Primary key — NOT NULL
  • name — varchar(45)
  • person id (person_id) — number — Foreign key → person.person id — NOT NULL

condition

  • condition id (condition_id) — number — Primary key — NOT NULL

employment_condition (employment)

  • person id (person_id2) — number — Foreign key → person.person id — NOT NULL
  • company id (company_id2) — number — Foreign key → company.company id — NOT NULL
  • condition id (condition_id2) — number — Foreign key → condition.condition id — NOT NULL
  • agreement name (agreement_name) — varchar(45) — Foreign key → agreement_type.agreement name — NOT NULL

family

  • person id (person_id) — number — Foreign key → person.person id — NOT NULL
  • family type name (family_type_name) — varchar(45) — Foreign key → family_type.family type name — NOT NULL

family_type

  • family type name (family_type_name) — varchar(45) — Primary key — NOT NULL

person

  • person id (person_id) — number — Primary key — NOT NULL
  • name — varchar(45)
  • surname — varchar(45)
  • birthday — date
  • sex — varchar(6)
  • salary — number