Constraints

24 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

type

poi_tourisme.type

poi_tourisme_val.code

Restrict delete

type

poi_service.type

poi_service_val.code

Restrict delete

noeud

repere.type_noeud

repere_val.code

Restrict delete

amenagement_type_amenagement

amenagement_type_segment_val.amenagement

amenagement_segment_val.code

Restrict delete

repere

liaison.id_repere

repere.id_repere

Restrict delete

poi

liaison.id_poi

poi.id_poi

Restrict delete

etape_itineraire_portion

etape.id_itineraire

itineraire.id_itineraire

Cascade on delete

etape_portion_segment

etape.id_portion

portion.id_portion

Cascade on delete

revetement

segment.revetement

revetement_val.code

Restrict delete

statut

segment.statut

statut_segment_val.code

Restrict delete

amenagement_type

segment.amenagement_type

amenagement_type_segment_val.code

Restrict delete

sens_unique_booleen

segment.sens_unique

booleen_val.code

Restrict delete

avancement

segment.avancement

etat_avancement_val.code

Restrict delete

amenagement

segment.amenagement

amenagement_segment_val.code

Restrict delete

geometrie_fictive_booleen

segment.geometrie_fictive

booleen_val.code

Restrict delete

desserte_college_booleen

segment.desserte_college

booleen_val.code

Restrict delete

type_portion

portion.type_portion

portion_val.code

Restrict delete

type

poi_acces_val.code

Restrict delete

element_segment

element.id_segment

segment.id_segment

Cascade on delete

element_portion_segment

element.id_portion

portion.id_portion

Cascade on delete

portion

frequentation.id_portion

portion.id_portion

Restrict delete

frequentation_repere

frequentation.id_repere

repere.id_repere

Restrict delete

est_inscrit_booleen

itineraire.est_inscrit

booleen_val.code

Restrict delete

niveau_schema

itineraire.niveau_schema

niveau_administratif_val.code

Restrict delete

Check Constraints

Table	Constraint Name	Constraint
frequentation	comptage	((comptage >= 0))