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