SQL> desc service
Name Null? Type
----------- ---- --
CDSRV NOT NULL CHAR(2)
NOM NOT NULL VARCHAR2(25)
LOCALIS NOT NULL VARCHAR2(20)
BATIM NOT NULL VARCHAR2(10)
TLPHN NOT NULL CHAR(10)
SQL> desc personnel
Name Null? Type
----------- ---- --
CDPRS NOT NULL CHAR(3)
NOM NOT NULL VARCHAR2(15)
PRNM NOT NULL VARCHAR2(15)
SX NOT NULL CHAR(1)
DATNAIS NOT NULL DATE
QUALIF NOT NULL VARCHAR2(25)
CDSRV NOT NULL CHAR(2)
DATTIT DATE
CDSPR CHAR(3)
TRTMNT NUMBER(8,2)
VACTN NUMBER(8,2)
|
|
SQL> desc patient
Name Null? Type
------------ ---- --
CDPAT NOT NULL CHAR(3)
NOM NOT NULL VARCHAR2(15)
PRNM NOT NULL VARCHAR2(15)
SX NOT NULL CHAR(1)
DATNAIS NOT NULL DATE
INSEE CHAR(13)
PROF NOT NULL VARCHAR2(25)
SQL> desc consultation
Name Null? Type
------------ ---- --
CDPAT NOT NULL CHAR(3)
CDPRS NOT NULL CHAR(3)
DATCLT DATE
|
|