| table design [message #90557] |
Sat, 28 February 2004 20:43 |
Riaz
Messages: 112
Registered: February 2002
|
Senior Member |
|
|
I am trying to design tables for little store dept(where items are issued to employees). Apart from other tables some important tables are as below.But I am till confused whether these are correct or not.. Please guide.....cheers
create table stock_issued
(
emp_id number(3),
item_id number(4),
qty_issued number(3),
month varchar2(15),
issue_date DATE)
);
create table stock_received
(
item_id number(4),
qty_received number(3),
month varchar2(15),
receive_date DATE)
);
create table stock_balance
(
item_id number(4),
balance_cf number(5), --balance carried forward
qty_received number(3),
net_balance number(5),
month varchar2(15),
);
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
