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