garico_pro - Laravel Schema Designer

subvention

id_subvention increments
Solde float (8.2)
id_group mediumInteger
description longText
timestamps timestamps

enveloppe

id_enveloppe increments
id_subvention ^FK integer
label string (500)
active boolean
softDeletes softDeletes
timestamps timestamps
date_debut datetime
date_fin datetime

plafond

id_plafond increments
id_subvention ^FK integer
montant_max float (8,2)
quantite_max mediumInteger
date_debut datetime
unite_periode tinyInteger
valeur_periode smallInteger
libelle string (500)
type tinyInteger
softDeletes softDeletes
timestamps timestamps

critere

id_critere ^FK integer
id_subvention ^FK integer
label string (500)
active boolean
type tinyInteger
timestamps timestamps
softDeletes softDeletes

subvention_reapprovisionnement

id increments
id_subvention ^FK integer
montant float (8,2)
id_utilisateur integer
timestamps timestamps

subvention_admins

id_utilisateur integer
id_subvention integer

critere_utilisateur_valeur

id_critere_utilisateur_valeur increments
id_utilisateur integer
valeur string (100)
id_criitere integer
timestamps timestamps

critere_tranche

id_criitere_tranche increments
id_criterion ^FK integer
min smallInteger
max smallInteger
timestamps timestamps

critere_selecion

id_criitere_selection increments
id_critere ^FK integer
valeur string (100)
timestamps timestamps

enveloppe_utilisateur_utilisation

id_enveloppe_utilisateur_utilisation increments
id_utilisateur integer
id_enveloppe ^FK integer
id_covoiturage integer
montant_subvention float (8,2)
timestamps timestamps

ecpr

id_ecpr increments
timestamps timestamps
id_enveloppe ^FK integer
id_plafond_somme ^FK integer
is_plafond_quantite ^FK integer
reduction float (8,2)
reduction_type tinyInteger
id_critere_option integer
citerion_type tinyInteger

covoiturage_configuration

id_covoiturage_configuration increments
rype smallInteger
value string (100)
id_covoiturage bigInteger
timestamps timestamps

utilisateur_configuration

id_utilisateur_configuration increments
type smallInteger
value string (100)
id_utilisateur integer
timestamps timestamps

role_configuration

id_role_configuration increments
id_role integer
type smallInteger
value string (100)
timestamps timestamps

abonnment

id_abonnment increments
libelle string (100)
prix float (8,2)
timestamps timestamps

abonement_role

id_abonnment ^FK integer
id_role integer

utilisateur_abonnement

id_utilisateur integer
id_abonnement integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01