CREATE TABLE pieces( NOP INTEGER , Des VARCHAR (50), couleur VARCHAR(50) check(couleur in("rouge","vert","bleu","jaune")), poids FLOAT, PRIMARY KEY(NOP) ); CREATE TABLE service( NOS INTEGER(50), Intitle VARCHAR (50), localisation VARCHAR(50), PRIMARY KEY(NOS) ); CREATE TABLE Ordre( NOP INTEGER, NOS INTEGER, QUANTITE INTEGER, PRIMARY KEY(NOP,NOS), FOREIGN KEY (NOP) REFERENCES pieces, FOREIGN KEY (NOS) REFERENCES service ); CREATE TABLE nome( NOPA INTEGER, NOPC INTEGER, QUANTITE INTEGER, PRIMARY KEY(NOPA,NOPC), FOREIGN KEY (NOPA) REFERENCES pieces(NOP), FOREIGN KEY (NOPC) REFERENCES service(NOS) ); INSERT INTO pieces VALUES (1, 'Vis', 'rouge', 0.5); INSERT INTO pieces VALUES (5, 'Ecrou', 'bleu', 0.3); INSERT INTO service VALUES (2, 'Montage', 'Tunis'); INSERT INTO service VALUES (7, 'Assemblage', 'Sfax'); INSERT INTO Ordre VALUES (1, 2, 100); INSERT INTO nome VALUES (5, 7, 49); SELECT * from pieces; SELECT * from service; SELECT * from Ordre; SELECT * from nome;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter