1 | create table Kompanija(
|
---|
2 | ime varchar2(50) primary key,
|
---|
3 | drzava varchar2(50) not null,
|
---|
4 | lokacija varchar2(50) not null
|
---|
5 | );
|
---|
6 | create table Distributeri(
|
---|
7 | id_distributer number primary key,
|
---|
8 | email varchar2(50) not null,
|
---|
9 | ime_prezime varchar2(100) not null,
|
---|
10 | zarabotka number not null,
|
---|
11 | ime_dostavuva_katalozi varchar2(50) not null references kompanija(ime),
|
---|
12 | ime_dostavuva_naracki varchar2(50) not null references kompanija(ime)
|
---|
13 | );
|
---|
14 | create table Katalog (
|
---|
15 | id_katalog number primary key,
|
---|
16 | cena number not null,
|
---|
17 | id_proizvod number not null,
|
---|
18 | ime_go_objavuva varchar2(50) not null references kompanija(ime)
|
---|
19 | );
|
---|
20 | create table Klient(
|
---|
21 | naziv varchar2(100) primary key,
|
---|
22 | adresa varchar2(100) not null,
|
---|
23 | email varchar2(100) not null,
|
---|
24 | tel_broj varchar2(50) not null
|
---|
25 | );
|
---|
26 | create table razgleduva(
|
---|
27 | id_katalog number not null references katalog(id_katalog),
|
---|
28 | naziv varchar2(100) not null references klient(naziv),
|
---|
29 | primary key(id_katalog,naziv)
|
---|
30 | );
|
---|
31 | create table pravi_naracki_preku(
|
---|
32 | id_distributer number not null references distributer(id_distributer),
|
---|
33 | naziv varchar2(100) not null references klient(naziv),
|
---|
34 | primary key(id_distributer,naziv)
|
---|
35 | );
|
---|
36 | create table dostavuva_katalozi_za(
|
---|
37 | id_distributer number not null references distributer(id_distributer),
|
---|
38 | naziv varchar2(100) not null references klient(naziv),
|
---|
39 | primary key(id_distributer,naziv)
|
---|
40 | );
|
---|
41 | create table Tip_distributer(
|
---|
42 | id_distributer number primary key references distributer(id_distributer),
|
---|
43 | nagradi number not null,
|
---|
44 | provizija number not null
|
---|
45 | );
|
---|
46 | create table standard(
|
---|
47 | id_distributer number primary key references tip_distributer(id_distributer)
|
---|
48 | );
|
---|
49 | create table pocetnik(
|
---|
50 | id_distributer number primary key references tip_distributer(id_distributer)
|
---|
51 | );
|
---|
52 | create table vip(
|
---|
53 | id_distributer number primary key references tip_distributer(id_distributer)
|
---|
54 | );
|
---|
55 |
|
---|