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)