You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
18 lines
519 B
18 lines
519 B
|
|
CREATE TABLE CONTATTI
|
|
( NOME VARCHAR2(255 BYTE) NOT NULL,
|
|
COGNOME VARCHAR2(255 BYTE) NOT NULL ,
|
|
SERVIZIO_SOCIALE VARCHAR2(255 BYTE),
|
|
AREA VARCHAR2(255 BYTE),
|
|
INDIRIZZO VARCHAR2(255 BYTE) NOT NULL,
|
|
TELEFONO NUMBER(10) PRIMARY KEY,
|
|
NUMERO NUMBER(2) NOT NULL ,
|
|
COMPOSIZIONE_NUCLEO VARCHAR2(255 BYTE) NOT NULL ,
|
|
NOTE_SACCHETTO VARCHAR2(255 BYTE),
|
|
ULTIMA_CONSEGNA DATE,
|
|
EMAIL VARCHAR2(256 BYTE)
|
|
) ;
|
|
|
|
CREATE TABLE ORDINI
|
|
( TELEFONO NUMBER(10) PRIMARY KEY REFERENCES CONTATTI(TELEFONO)
|
|
) ; |