1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
CREATE TABLE "EMPREX".FOURNISSEUR
(
NOFOUR number(5) not null,
RSFOUR varchar2(50) not null,
CAFOUR number(8,2),
CONSTRAINT pk_nofour Primary key(NOFOUR)
)
CREATE TABLE "EMPREX".MATERIEL
(
NOMATERIEL number(6) not null,
LIBMATERIEL varchar2(50) not null,
DATEACHAT date,
PRIXACHAT number(8,2),
CAUTION number(8,2),
NOFOUR number(6) not null,
CONSTRAINT pk_nomateriel Primary key(NOMATERIEL),
CONSTRAINT fk_four_materiel Foreign key (NOFOUR) References FOURNISSEUR(NOFOUR)
)
CREATE TABLE "EMPREX".ADHERENT
(
NOADHERENT number(6) not null,
NOMADHERENT varchar2(30) not null,
PRNADHERENT varchar2(20),
CIVADHERENT varchar(5),
RUEADHERENT varchar2(50),
CPADHERENT char(5) not null,
VILADHERENT varchar2(30),
TELADHERENT char(10),
DATENAISSANCE date not null,
CONSTRAINT pk_noadherent Primary key(NOADHERENT)
)
CREATE TABLE "EMPREX".ACTIVITE
(
NOACTIVITE number(6) not null,
NOMACTIVITE varchar2(30) not null,
RUEACTIVITE varchar2(50),
CPACTIVITE char(5),
VILACTIVITE varchar2(30),
MTCOTISATION number(8,2),
DEBUTSAISON date,
DUREEACTIVITE number(1),
TELACTIVITE char(10),
FAXACTIVITE char(10),
CONSTRAINT pk_noactivite Primary key(NOACTIVITE)
)
CREATE TABLE "EMPREX".PRET
(
NOMATERIEL number(6) not null,
DATEPRET date not null,
NOADHERENT number(6) not null,
DATERETOUR date,
CONSTRAINT pk_pret Primary key(NOMATERIEL, DATEPRET, NOADHERENT)
)
CREATE TABLE "EMPREX".ADHESION
(
NOADHERENT number(6) not null,
NOACTIVITE number(6) not null,
DATEADHESION date not null,
CONSTRAINT pk_adhesion Primary key(NOADHERENT, NOACTIVITE, DATEADHESION)
) |
