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)
) |
Partager