ERP

Tables (5)

code_department (사업부)

  • department_code (Key) — int — Primary key — NOT NULL
  • department_name (Field) — String

code_school (학위)

  • school_code (Key) — int — Primary key — NOT NULL
  • school_name (Field) — String

code_skill (기술)

  • skill_code (Key) — int — Primary key — NOT NULL
  • skill_name (Field) — String

staff (사원)

  • staff_no (Key) — int — Primary key — NOT NULL
  • school_code (Key2) — int — Foreign key → code_school.school_code — NOT NULL
  • department_code (Key3) — int — Foreign key → code_department.department_code — NOT NULL
  • staff_name (Field) — String
  • jumin_no (Field2) — int
  • graduate_day (Field5) — int

staff_skill (사원 기술)

  • staff_skill_no (Key) — int — Primary key — NOT NULL
  • staff_no (Key2) — int — Foreign key → staff.staff_no — NOT NULL
  • skill_code (Key3) — int — Foreign key → code_skill.skill_code — NOT NULL
  • Field