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