Team JAVA 5.26

Tables (7)

agreement_type (Untitled2)

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

company (Untitled)

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

condition_id (Untitled7)

  • condition (Key) — INT — Primary key — NOT NULL

employment_condition (Untitled3)

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

family (Untitled4)

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

family_type (Untitled5)

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

person (Untitled6)

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