Projet Sorties pour l'ENI
PHP 8.2.18
Symfony 6.4
Bootstrap 5.3
Bootswatch Theme: Vapor
MySQL 8.3.0
Table Trip {
tri_id integer [primary key]
tri_name varchar (30)
tri_starting_date date
tri_duration integer
tri_closing_date date
tri_max_inscription_number integer
tri_description longtext
tri_cancellation_reason longtext
tri_state integer
tri_location integer
tri_organiser integer
tri_site integer
}
Table Location {
loc_id integer [primary key]
loc_name varchar (30)
loc_street varchar (30)
loc_latitude float
loc_longitude float
loc_city integer
}
Table City {
cit_id integer [primary key]
cit_name varchar (30)
cit_post_code varchar (5)
}
Table Site {
sit_id integer [primary key]
sit_name varchar (30)
}
Table Participant {
par_id integer [primary key]
par_username varchar (180)
par_password varchar (255)
par_last_name varchar (30)
par_first_name varchar (30)
par_phone varchar (15)
par_email varchar (50)
par_picture varchar (255)
par_is_active boolean
par_site integer
roles json
}
Table State {
sta_id integer [primary key]
sta_label varchar (30)
}
Table Subscribe {
sub_id integer [primary key]
sub_participant_id integer
sub_trip_id integer
}
Ref: Trip.tri_location > Location.loc_id
Ref: Location.loc_city > City.cit_id
Ref: Trip.tri_state > State.sta_id
Ref: Trip.tri_site > Site.sit_id
Ref: Trip.tri_organiser > Participant.par_id
Ref: Trip.tri_id > Subscribe.sub_trip_id
Ref: Participant.par_id > Subscribe.sub_participant_id
Ref: Participant.par_site > Site.sit_id