Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE PERSONNE (
- id INT PRIMARY KEY,
- nom VARCHAR(30) NOT NULL,
- prenom VARCHAR(30) NOT NULL,
- adresse VARCHAR(100) NOT NULL,
- age SMALLINT CHECK (age >= 18 AND age <= 150)
- )
- CREATE TABLE VEHICULE (
- numero CHAR(9) NOT NULL,
- marque VARCHAR(20) DEFAULT 'inconnue',
- puissance SMALLINT NULL,
- couleur VARCHAR(20) NULL,
- id_personne INT FOREIGN KEY REFERENCES PERSONNE(id) NOT NULL
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement