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