자바조

테이블 (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