Home » Developer & Programmer » Designer » table design
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),
);
Previous Topic: for making dadatbase for company which update its name dayly
Next Topic: Maximum name sizes
Goto Forum:
  


Current Time: Fri Mar 29 09:28:52 CDT 2024