task#1
Tables (8)
Attendance (참석)
- attendance_id — number — Primary key — NOT NULL
- employee_id — number — Foreign key → Employee.employee_id — 부서 ID
- date — date — 부서명
- check_in — date
- check_out — date
Department (부서)
- department_id — number — Primary key — NOT NULL — 부서 ID
- department_name — varchar(50) — NOT NULL — 부서명
Employee (직원)
- employee_id — number — Primary key — NOT NULL — 부서 ID
- first_name — varchar(50) — NOT NULL — 부서명
- last_name — varchar(50) — NOT NULL
- department_id — number — Foreign key → Department.department_id — 부서 ID
- position_id — number — Foreign key → Position.position_id
- email — varchar(100) — NOT NULL
- phone — varchar(20)
- hire_date — date
Employee_Project
- department_id (employee_project_id) — number — Primary key — NOT NULL — 부서 ID
- employee_id — number — Foreign key → Employee.employee_id — NOT NULL — 부서 ID
- project_id — number — Foreign key → Project.project_id — NOT NULL
- department_name (assined_date) — date — 부서명
- Field (role) — varchar(50)
Leave (CopyOfUntitled)
- leave_id (Key) — int — Primary key — NOT NULL
- employee_id — number — Foreign key → Employee.employee_id — NOT NULL — 부서 ID
- leave_start (Field2) — date
- leave_end (Field3) — date
- leave_type (Field) — varchar(50)
Position (직책)
- position_id — number — Primary key — NOT NULL
- position_title — varchar(50) — NOT NULL — 부서명
Project (프로젝트)
- project_id — number — Primary key — NOT NULL
- project_name — varchar(50) — NOT NULL — 부서명
- start_date — date
- end_date — date
Salary (Untitled)
- salary_id (Key) — int — Primary key — NOT NULL
- employee_id — number — Foreign key → Employee.employee_id — NOT NULL — 부서 ID
- amount (Field) — number — NOT NULL
- start_date (Field2) — date
- end_date (Field3) — date