Base de données du site IEUF

action_table

Field Type Collation Null Key Default Extra Comment
id mediumint unsigned NO PRI auto_increment
id_intervention smallint unsigned NO
tbl varchar(255) latin1_swedish_ci NO
id_element smallint NO
nature enum('a','m','s') latin1_swedish_ci NO
anc_donnees text latin1_swedish_ci YES
nou_donnees text latin1_swedish_ci YES

adhesion

Field Type Collation Null Key Default Extra Comment
id smallint unsigned NO PRI auto_increment
id_perso smallint unsigned NO
id_payeur smallint unsigned NO
date_adhesion date NO
cout decimal(5,2) unsigned NO 0.00
mod_du tinyint(1) NO 1
commentaire varchar(255) latin1_swedish_ci YES

animateur

Field Type Collation Null Key Default Extra Comment
id smallint unsigned NO PRI auto_increment
id_perso smallint unsigned NO
date_embauche date YES
duree_contrat varchar(255) latin1_swedish_ci YES
experience text latin1_swedish_ci YES
formation text latin1_swedish_ci YES
diplomes text latin1_swedish_ci YES
intervention varchar(255) latin1_swedish_ci YES

anime

Field Type Collation Null Key Default Extra Comment
id_atelier smallint unsigned NO MUL
id_animateur smallint NO

archives

Field Type Collation Null Key Default Extra Comment
id mediumint unsigned NO PRI auto_increment
id_parent mediumint unsigned NO
acces_l tinyint unsigned NO
acces_e tinyint unsigned NO
type char(1) utf8mb3_unicode_ci NO MUL
nom varchar(255) utf8mb3_unicode_ci NO
mots_cle text utf8mb3_unicode_ci YES
nom_interne varchar(255) utf8mb3_unicode_ci YES
date date NO

atelier

Field Type Collation Null Key Default Extra Comment
id smallint unsigned NO PRI auto_increment
nb_max tinyint unsigned NO 0
lettre char(1) latin1_swedish_ci NO
intitule varchar(255) latin1_swedish_ci YES
lieu_nom varchar(255) latin1_swedish_ci YES
lieu_rue varchar(255) latin1_swedish_ci YES
lieu_compl varchar(255) latin1_swedish_ci YES
lieu_cp char(5) latin1_swedish_ci YES
lieu_ville varchar(255) latin1_swedish_ci YES
lieu_gard varchar(255) latin1_swedish_ci YES
lieu_tel char(10) latin1_swedish_ci YES
lieu_mob char(10) latin1_swedish_ci YES
heure_deb time YES
heure_fin time YES
date_deb date YES
date_fin date YES
jour_repet tinyint YES
cout_trim tinyint YES
descriptif text latin1_swedish_ci YES

attente

Field Type Collation Null Key Default Extra Comment
id_perso smallint unsigned NO
id_atelier smallint unsigned NO
date_ins datetime NO

inscriptions

Field Type Collation Null Key Default Extra Comment
Id smallint unsigned NO PRI auto_increment
id_perso smallint unsigned NO 0
date_saisie date NO
clef tinytext latin1_swedish_ci NO
civilite enum('m.','mme','mlle') latin1_swedish_ci YES
Nom varchar(255) latin1_swedish_ci NO
Prenom varchar(255) latin1_swedish_ci NO
DateNaiss date YES
Adr_rue varchar(255) latin1_swedish_ci YES
Adr_comp varchar(255) latin1_swedish_ci YES
Adr_CP char(5) latin1_swedish_ci YES
Adr_ville varchar(255) latin1_swedish_ci YES
Tel_dom char(10) latin1_swedish_ci YES
Mobile char(10) latin1_swedish_ci YES
Tel_urgence char(10) latin1_swedish_ci YES
Email varchar(255) latin1_swedish_ci YES
Email2 varchar(255) latin1_swedish_ci YES e mail autre (professionnel, personne tutrice, etc)
lst_diff tinyint(1) NO 0
lst_diff2 tinyint(1) NO 0
Classe varchar(255) latin1_swedish_ci YES classe en cours (scolaire)
Comm varchar(255) latin1_swedish_ci YES
publimage enum('i','p','t') latin1_swedish_ci NO t Interdit, Privé, Tous
ateliers tinytext latin1_swedish_ci NO
adhesion tinyint unsigned NO 0
id_pere smallint unsigned NO
id_mere smallint unsigned NO
nom_pere text latin1_swedish_ci YES
prenom_pere text latin1_swedish_ci YES
nom_mere text latin1_swedish_ci YES
prenom_mere text latin1_swedish_ci YES

intervention

Field Type Collation Null Key Default Extra Comment
id smallint unsigned NO PRI auto_increment
id_pers smallint unsigned NO
date_heure datetime NO

media

Field Type Collation Null Key Default Extra Comment
id smallint unsigned NO PRI auto_increment
rang double NO
id_representation smallint unsigned NO
titre varchar(255) latin1_swedish_ci NO
public tinyint(1) NO 0
chemin varchar(255) latin1_swedish_ci NO
commentaire text latin1_swedish_ci YES

participe

Field Type Collation Null Key Default Extra Comment
id_adh smallint unsigned NO MUL
id_atelier smallint unsigned NO
cout_1 decimal(5,2) unsigned NO 0.00
cout_2 decimal(5,2) unsigned NO 0.00
cout_3 decimal(5,2) unsigned NO 0.00
date_entree date YES
date_sortie date YES

passe

Field Type Collation Null Key Default Extra Comment
id_prod smallint unsigned NO
id_spectacle smallint unsigned NO

payeur

Field Type Collation Null Key Default Extra Comment
id smallint unsigned NO PRI auto_increment
id_perso_p smallint unsigned NO
rib varchar(255) latin1_swedish_ci YES
dern_paiement date YES

personne

Field Type Collation Null Key Default Extra Comment
Id smallint unsigned NO PRI auto_increment
civilite enum('m.','mme','mlle') latin1_swedish_ci YES
Nom varchar(255) latin1_swedish_ci NO MUL
Prenom varchar(255) latin1_swedish_ci NO
role enum('pr','sc','tr','vp','sa','ta','ca') latin1_swedish_ci YES
DateNaiss date YES
Adr_rue varchar(255) latin1_swedish_ci YES
Adr_comp varchar(255) latin1_swedish_ci YES
Adr_CP char(5) latin1_swedish_ci YES
Adr_ville varchar(255) latin1_swedish_ci YES
Tel_dom char(10) latin1_swedish_ci YES
Mobile char(10) latin1_swedish_ci YES
Tel_urgence char(10) latin1_swedish_ci YES
Email varchar(255) latin1_swedish_ci YES
Email2 varchar(255) latin1_swedish_ci YES e mail autre (professionnel, personne tutrice, etc)
lst_diff tinyint(1) NO 0
lst_diff2 tinyint(1) NO 0
Classe varchar(255) latin1_swedish_ci YES classe en cours (scolaire)
Comm varchar(255) latin1_swedish_ci YES
id_pere smallint unsigned YES
id_mere smallint unsigned YES
publimage enum('i','p','t') latin1_swedish_ci NO t Interdit, Privé, Tous

production

Field Type Collation Null Key Default Extra Comment
id smallint unsigned NO PRI auto_increment
id_atelier smallint unsigned NO
titre varchar(255) latin1_swedish_ci NO
resume text latin1_swedish_ci YES
met_scene varchar(255) latin1_swedish_ci YES
auteur varchar(255) latin1_swedish_ci YES
commentaire text latin1_swedish_ci YES

reglement

Field Type Collation Null Key Default Extra Comment
id smallint unsigned NO PRI auto_increment
id_payeur smallint unsigned NO
nature enum('ch','esp','pc','au') latin1_swedish_ci NO cheque, especes,participation collectivite, autre
ident_paiement varchar(255) latin1_swedish_ci YES
date date YES
montant decimal(5,2) NO

relais_parent

Field Type Collation Null Key Default Extra Comment
id smallint unsigned NO PRI auto_increment
id_perso smallint unsigned YES
date_relais datetime NO

representation

Field Type Collation Null Key Default Extra Comment
id smallint unsigned NO PRI auto_increment
id_spectacle smallint unsigned NO
salle varchar(255) latin1_swedish_ci NO
lieu varchar(255) latin1_swedish_ci YES
ville varchar(255) latin1_swedish_ci YES
date datetime YES
duree smallint YES
preparation text latin1_swedish_ci YES
bilan text latin1_swedish_ci YES
media varchar(255) latin1_swedish_ci YES

requetes_sql

Field Type Collation Null Key Default Extra Comment
id tinyint NO
nom varchar(256) latin1_swedish_ci NO
corps longtext latin1_swedish_ci NO

spectacle

Field Type Collation Null Key Default Extra Comment
id smallint unsigned NO PRI auto_increment
titre varchar(255) latin1_swedish_ci NO
resume text latin1_swedish_ci YES
met_scene varchar(255) latin1_swedish_ci YES
auteur varchar(255) latin1_swedish_ci YES
compl_info text latin1_swedish_ci YES
commentaire text latin1_swedish_ci YES
media varchar(255) latin1_swedish_ci YES
reservation enum('x','p','i') latin1_swedish_ci NO p 'i' indispensable, 'p' possible, 'x' pas de reserv.

temoignages

Field Type Collation Null Key Default Extra Comment
id int unsigned NO PRI auto_increment
id_perso smallint unsigned NO
date date NO
validite smallint unsigned NO 0
texte text latin1_swedish_ci NO

temporaire

Field Type Collation Null Key Default Extra Comment
nom varchar(255) latin1_swedish_ci NO
prenom varchar(255) latin1_swedish_ci NO
date_adhesion varchar(255) latin1_swedish_ci NO
lettre_atelier varchar(255) latin1_swedish_ci NO
annee_naissance varchar(255) latin1_swedish_ci NO
age varchar(255) latin1_swedish_ci NO
date_naissance varchar(255) latin1_swedish_ci NO
rue varchar(255) latin1_swedish_ci NO
code_postal varchar(255) latin1_swedish_ci NO
ville varchar(255) latin1_swedish_ci NO
tel_dom varchar(255) latin1_swedish_ci NO
tel_trav varchar(255) latin1_swedish_ci NO
tel_port varchar(255) latin1_swedish_ci NO
mail_perso varchar(255) latin1_swedish_ci NO
mail_trav varchar(255) latin1_swedish_ci NO
int_cheque varchar(255) latin1_swedish_ci NO
adhesion_courrier varchar(255) latin1_swedish_ci NO
adhesion_cheque_jeune varchar(255) latin1_swedish_ci NO
passeport_IA varchar(255) latin1_swedish_ci NO
1_trim varchar(255) latin1_swedish_ci NO
2_trim varchar(255) latin1_swedish_ci NO
3_trim varchar(255) latin1_swedish_ci NO
courrier_inscription varchar(255) latin1_swedish_ci NO
attestation varchar(255) latin1_swedish_ci NO

utilisateur

Field Type Collation Null Key Default Extra Comment
id smallint unsigned NO PRI auto_increment
id_perso smallint YES
login varchar(255) latin1_swedish_ci NO
mdp char(40) latin1_swedish_ci NO
fonction enum('ad','pr','sc','tr','ca') latin1_swedish_ci YES