1
2
3
4
5
6
7
8
9

create table customers
‎(‎
customer_id number primary key,‎
customer_name varchar2(30) not null,‎
city_add varchar2(10),‎
street_add varchar2(20),‎
phone_no number not null,‎
wep_site varchar2(30),‎
email varchar2(30) );‎

1
2
3
4
5

create table salesmen
‎(‎
salesman_id number primary key,‎
salesman_name varchar2(30) not null,‎
car_work_hour number );‎

1
2
3
4
5
6
7
8
9

create table suppliers
‎(‎
supplier_id number primary key,‎
supplier_name varchar2(30) not null,‎
city_add varchar2(20),‎
street_add varchar2(10),‎
wep_site varchar2(30),‎
email varchar2(30)‎
‎);‎

1
2
3
4
5

create table stocks
‎(‎
stock_id number primary key,‎
stock_add varchar2(30) not null,‎
‎);‎

1
2
3
4
5
6
7

create table items
‎(‎
item_id number primary key,‎
item_name varchar2(20) not null,‎
unit_price number not null,‎
measure_unit varchar2(10)‎
‎);‎

1
2
3
4
5
6

create table pbills‏)‏
pbill_id number primary key‏,‏
pbill_type varchar2(10) not null‏,‏
supplier_discount number‏,‏
pbill_date number not null‏,‏
notes varchar2(50));‎

1
2
3
4
5
6
7
8
9

create table sbills
‎(‎
sbill_id number primary key,‎
sbill_type varchar2(10) not null,‎
sbill_date number not null,‎
discount number,‎
customer_id number references customers(customer_id) on delete cascade, ‎
salesman_id number references salesmen(salesman_id) on delete cascade,‎
notes varchar2(50));‎

1
2
3
4
5
6
7

create table purchases
‎(‎
purchase_id number primary key,‎
qty  number not null,‎
pbill_id number references pbills(pbill_id) on delete cascade, ‎
item_id number references items(item_id) on delete cascade
‎);‎

1
2
3
4
5
6
7

create table sales
‎(‎
sale_id number primary key,‎
qty number not null,‎
sbill_id number references sbills(sbill_id) on delete cascade, ‎
item_id number references items(item_id) on delete cascade
‎);‎

1
2
3
4
5

create table pull
‎( ‎
item_id number references items(item_id) on delete cascade,‎
stock_id number references stocks(stock_id) on delete cascade,‎
constraint pk primary key(item_id,stock_id));‎

1
2
3
4
5
6

create table marketing
‎( ‎
item_id number references items(item_id) on delete cascade,‎
salesman_id number references salesmen(salesman_id) on delete cascade,‎
constraint pk1 primary key(item_id,salesman_id)‎
‎);‎

1
2
3
4
5
6

create table store
‎( ‎
stock_id number references stocks(stock_id) on delete cascade,‎
purchase_id number references purchases(purchase_id) on delete cascade,‎
constraint pk2 primary key(stock_id,purchase_id)‎
‎);‎

1
2
3
4
5
6

create table supply
‎( ‎
supplier_id number references suppliers(supplier_id) on delete cascade,‎
purchase_id number references purchases(purchase_id) on delete cascade,‎
constraint pk3 primary key(supplier_id,purchase_id)‎
‎);‎

1
2
3
4
5
6

create table sphones
‎( ‎
supplier_id number references suppliers(supplier_id) on delete cascade,‎
supplier_phone number not null,‎
constraint pk4 primary key(supplier_id,supplier_phone)‎
‎);‎

1
2
3
4
5
6

create table sdphones
‎( ‎
salesman_id number references salesmen(salesman_id) on delete cascade,‎
salesman_phone number not null,‎
constraint pk5 primary key(salesman_id,salesman_phone)‎
‎);‎