create table salaryExcel
(
sal_id NUMBER not null,
start_date DATE not null,
end_date DATE not null,
ser_no NUMBER not null,
days NUMBER not null,
hours NUMBER not null,
additional_hours NUMBER not null,
rate NUMBER not null,
money_earned NUMBER(9,2),
paid_in_payroll NUMBER(9,2),
insurance NUMBER(9,2),
money_deducted NUMBER(9,2),
money_owed_to_us NUMBER(9,2),
already_paid NUMBER(1) not null check (already_paid in (0,1)),
true_money_owed_to_us NUMBER(9,2)
);
create table moneyHeld(
held_id NUMBER not null,
amount_held NUMBER(9,2) not null,
year_current NUMBER not null
);
(
sal_id NUMBER not null,
start_date DATE not null,
end_date DATE not null,
ser_no NUMBER not null,
days NUMBER not null,
hours NUMBER not null,
additional_hours NUMBER not null,
rate NUMBER not null,
money_earned NUMBER(9,2),
paid_in_payroll NUMBER(9,2),
insurance NUMBER(9,2),
money_deducted NUMBER(9,2),
money_owed_to_us NUMBER(9,2),
already_paid NUMBER(1) not null check (already_paid in (0,1)),
true_money_owed_to_us NUMBER(9,2)
);
create table moneyHeld(
held_id NUMBER not null,
amount_held NUMBER(9,2) not null,
year_current NUMBER not null
);
No comments:
Post a Comment