1219최한수

테이블 (4)

Clerk (Untitled2)

  • Clerk_idx (Key) — int — 기본 키 — NOT NULL
  • Department_idx (Key2) — int — 외래 키 → Department.Department_idx — NOT NULL
  • Clerk_Name (Field) — varchar(100)
  • Official_Responsibilities (Field2) — varchar(100)

Department (Untitled)

  • Department_idx (Key) — int — 기본 키 — NOT NULL
  • Department_name (Field) — varchar(100)

Dependent_Family (Untitled3)

  • Clerk_idx (Key) — int — 외래 키 → Clerk.Clerk_idx — NOT NULL
  • Dependent_Family_Name (Field) — varchar
  • Dependent_Family_Age (Field2) — int

Service_Record (Untitled4)

  • Clerk_idx (Key) — int — 외래 키 → Clerk.Clerk_idx — NOT NULL
  • Service_Record_Start (Field) — Time
  • Service_Record_Finish (Field2) — Time
  • Service_Record_Official_Responsibilities (Field3) — varchar(100)
  • Department_idx (Key2) — int — 외래 키 → Department.Department_idx — NOT NULL