temp

Tables (4)

Employee (아르바이트)

  • Employee_id (아르바이트_id) — number(7) — Primary key — NOT NULL
  • Boss_id (사장님 _id) — varchar2(40) — Foreign key → Employer.Boss_id — NOT NULL
  • pay (시급) — number(5)

Employer (사장님)

  • Boss_id (사장님 _id) — number(7) — Primary key — NOT NULL
  • deposit (예치금) — number(8)

salary (급여명세서)

  • Employee_id (아르바이트_id) — number(7) — Foreign key → Employee.Employee_id — NOT NULL
  • Employer_ck (사장확인란) — varchar2(1)
  • Employee_ck (알바확인란) — varchar2(1)
  • pay_ck (급여 지급유무) — varchar2(1)
  • sum (월 총급여) — number(7)

work (근태)

  • Employee_id (아르바이트_id) — number(7) — Foreign key → Employee.Employee_id — NOT NULL
  • schedule-start (출근예정) — date
  • schedule-end (퇴근예정) — date
  • real-start (실출근) — date
  • real-end (실퇴근) — date
  • schedule-check (근태이상유무) — varchar2(2)