인력관리
테이블 (5)
Customer
- Customer_ID (Key) — Char(30) — 기본 키 — NOT NULL
- Customer_Name (Field) — VARCHAR(50)
- Field2
- Field3
Customer_Project
- Customer_ID (Key) — Char(30) — 외래 키 → Customer.Customer_ID — NOT NULL
- Project_Code (Key2) — Char(10) — 외래 키 → Project.Project_Code — NOT NULL
- Project_Contract_Amt (Field) — Number
- Field2
- Field3
Person
- Person_ID (Key1) — Char(30) — 기본 키 — NOT NULL
- Person_Name (Field1) — NOT NULL
- Person_Address (Field)
- Person_Tel_No (Field2)
- Field3
- Field4
- Field5
- Field6
- Field7
- Field8
- Field9
Project
- Project_Code (Key) — Char(10) — 기본 키 — NOT NULL
- Project_Name (Field)
- Project_Start_Date (Field2) — DateTime
- Project_End_Date (Field3) — DateTime
- Field4
- Field5
- Field6
Project_Member
- Person_ID (Key1) — Char(30) — 외래 키 → Person.Person_ID — NOT NULL
- Project_Code (Key3) — Char(10) — 외래 키 → Project.Project_Code — NOT NULL
- MM_Cost (Field) — Number
- Field2
- Field3