자바조
테이블 (6)
agreement_type (Untitled3)
- agreement_name (Key) — VARCHAR(45) — 기본 키 — NOT NULL
- description (Field) — VARCHAR(45)
company (Untitled)
- company_id (Key) — INT — 기본 키 — NOT NULL
- name (Field)
- person_id (Key2) — INT — 외래 키 → person.person_id — NOT NULL
employment_condition (Untitled4)
- condition_id (Field3) — INT
- person_id (Key2) — INT — 외래 키 → person.person_id — NOT NULL
- company_id (Key3) — INT — 외래 키 → company.company_id — NOT NULL
- agreement_name (Key4) — VARCHAR(45) — 외래 키 → agreement_type.agreement_name — NOT NULL
family (Untitled5)
- person_id (Key) — INT — 외래 키 → person.person_id — NOT NULL
- family_type_name (Key2) — VARCHAR(45) — 외래 키 → family_type.family_type_name — NOT NULL
family_type (Untitled6)
- family_type_name (Key) — VARCHAR(45) — 기본 키 — NOT NULL
person (Untitled2)
- person_id (Key) — INT — 기본 키 — NOT NULL
- name (Field) — VARCHAR(45)
- surname (Field2) — VARCHAR(45)
- birthday (Field3) — DATE
- sex (Field4) — VARCHAR(6)
- salary (Field5) — DECIMAL