CREATE TABLE ETUDIANT (
  ID INTEGER PRIMARY KEY,
  NOM TEXT NOT NULL,
  DdN DATE,
  PORTABLE TEXT
);

CREATE VIEW ETUDIANT_INJOIGNABLE AS 
   SELECT ID, NOM, DDN
   FROM ETUDIANT
   WHERE PORTABLE IS NULL;

CREATE TRIGGER ETUDIANT_INJOIGNABLE_INSERT
   INSTEAD OF INSERT ON ETUDIANT_INJOIGNABLE
   BEGIN
     INSERT INTO ETUDIANT (ID,NOM,DDN) 
     VALUES (NEW.ID,NEW.NOM,NEW.DDN);
   END;