인력관리

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