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