SQL> DESC service
cdsrv char(2) primary key,
nom varchar(25) not null,
localis varchar(20) not null,
batim varchar(10) not null,
tlphn char(10) not null
SQL> DESC personnel
cdprs char(3) primary key,
nom varchar(15) not null,
prnm varchar(15) not null,
datnais date not null,
qualif varchar(25) not null,
cdsrv char(2) not null,
dattit date,
cdspr char(3),
trtmnt number(8,2),
vactn number(8,2)
|
|
SQL> DESC patient
cdpat char(3) primary key,
nom varchar(15) not null,
prnm varchar(15) not null,
sx char(1) not null,
datnais date not null,
insee char(13),
prof varchar(25) not null
SQL> DESC consultation
cdpat char(3) not null,
cdprs char(3) not null,
datclt date
|
|