1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| CREATE TABLE TYPE_OBSERVATION
(
TypeObservationId INT NOT NULL,
CategorieId INT NOT NULL,
TypeObservationLibelle VARCHAR(45) NOT NULL,
CONSTRAINT TYPE_OBSERVATION_PK PRIMARY KEY (TypeObservationId),
CONSTRAINT OBSERVATION_CATEGORIE_FK FOREIGN KEY (CategorieId)
REFERENCES CATEGORIE (CategorieId)
) ;
INSERT INTO TYPE_OBSERVATION (TypeObservationId, CategorieId, TypeObservationLibelle) VALUES (1,1, 'Sans population') ;
INSERT INTO TYPE_OBSERVATION (TypeObservationId, CategorieId, TypeObservationLibelle) VALUES (2,1, 'Population permanente') ;
INSERT INTO TYPE_OBSERVATION (TypeObservationId, CategorieId, TypeObservationLibelle) VALUES (3,1, 'Population temporaire') ;
INSERT INTO TYPE_OBSERVATION (TypeObservationId, CategorieId, TypeObservationLibelle) VALUES (4,2, 'Escalade') ;
INSERT INTO TYPE_OBSERVATION (TypeObservationId, CategorieId, TypeObservationLibelle) VALUES (5,2, 'Activités de plage') ;
INSERT INTO TYPE_OBSERVATION (TypeObservationId, CategorieId, TypeObservationLibelle) VALUES (6,2, 'Chasse') ;
INSERT INTO TYPE_OBSERVATION (TypeObservationId, CategorieId, TypeObservationLibelle) VALUES (7,2, 'Nautisme de plaisance') ;
INSERT INTO TYPE_OBSERVATION (TypeObservationId, CategorieId, TypeObservationLibelle) VALUES (8,2, 'Promenade') ;
SELECT *, '' AS '<= TYPE_OBSERVATION' FROM TYPE_OBSERVATION ; |
Partager