sql projet

create table Adherant (
    AdherantId VARCHAR(20)
        CONSTRAINT adherant_id_non_null  NOT NULL
        CONSTRAINT padherant_k_adherant  PRIMARY KEY,
    prenom VARCHAR(20)
        CONSTRAINT adherant_prenom_non_null NOT NULL,
    nom VARCHAR(20)
        CONSTRAINT adherant_nom_non_null NOT NULL,
    mail VARCHAR(40)
        CONSTRAINT adherant_mail_non_null NOT NULL
        /*CONSTRAINT mail_valide*/,
    telephone CHAR(10) NULL
        CONSTRAINT adherant_numero_valide CHECK(telephone LIKE('[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')),
    date_de_naissance DATE DEFAULT(SYSDATE)
        CONSTRAINT adherant_date_non_null NOT NULL,
    mot_de_passe VARCHAR2(20)
        CONSTRAINT adherant_mdp_non_null NOT NULL);

create table Organise(
    asso VARCHAR(10)
        CONSTRAINT fk_asso REFERENCES Association(RNA) ON DELETE SET NULL,
    event NUMBER(5,0)
        CONSTRAINT fk_event REFERENCES  Evenement(EventId) ON DELETE SET NULL
);

create table Tache(
    nom VARCHAR(20)
        CONSTRAINT adherant_nom_non_null NOT NULL,
    numero NUMBER(5,0)
        CONSTRAINT pk_numero PRIMARY KEY
        CONSTRAINT numero_non_null NOT NULL
)
create table Necessite(
    tache VARCHAR(20)
        CONSTRAINT fk_tache REFERENCES Tache(numero) ON DELETE SET NULL,
    event NUMBER(5,0)
        CONSTRAINT fk_event REFERENCES  Evenement(EventId) ON DELETE SET NULL
);