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