Mariage - Laravel Schema Designer

evenements

id increments
timestamps timestamps
softDeletes softDeletes
defaultceremonie_id integer
slug string (255)
button_qr_code string (10)
image_qr_code string (255)
menu_pdf string (255)
nom string (255)
nom_madame string (255)
nom_monsieur string (255)
date datetime
base_date_event datetime
date_fermeture_reponse datetime
email string (255)
histoire text
show_cagnotte string (10)
pk_pay string (255)
sk_pay string (255)
apropos_madame text
apropos_monsieur text
invite_accompagner string (10)
texte_billet text
texte_cagnotte text
texte_envoi_invitation text
texte_spontane text
mois_avant integer
mois_apres integer
admin_forme integer
ceremonie_max integer
invite_max integer
photo_max integer
cagnotte_max integer
domaine string (255)
force_visibility string (10)
num_vert string (255)
statut string (10)

admins_evenements

id increments
timestamps timestamps
softDeletes softDeletes
evenement_id ^FK integer
global_admin_id ^FK integer
slug string (255)
role string (10)
matricule string (255)
pass string (255)
nom string (255)
statut string (10)

invites

id increments
timestamps timestamps
softDeletes softDeletes
evenement_id ^FK integer
table_id ^FK integer
invite_id ^FK integer
slug string (255)
qr_code string (255)
nom string (255)
prenom string (255)
sexe string (255)
telephone string (255)
email string (255)
lien string (255)
type string (255)
statut_invitation string (10)
statut string (10)

globals_admins

id increments
timestamps timestamps
softDeletes softDeletes
slug string (255)
role string (10)
matricule string (255)
pass string (255)
nom string (255)
statut string (10)

tables

id increments
timestamps timestamps
softDeletes softDeletes
ceremonie_id ^FK integer
slug string (255)
numero integer
nom string (255)
statut string (10)

temoignages

timestamps timestamps
softDeletes softDeletes
id increments
evenement_id ^FK integer
invite_id ^FK integer
slug string (255)
nom string (255)
texte text
statut string (10)

photos

id increments
timestamps timestamps
softDeletes softDeletes
slug string (255)
evenement_id ^FK integer
nom string (255)
statut string (10)

menus

id increments
timestamps timestamps
softDeletes softDeletes
ceremonie_id ^FK integer
slug string (255)
nom string (255)
groupe string (10)
description string (255)
statut string (10)

questionnaires

id increments
timestamps timestamps
softDeletes softDeletes
evenement_id ^FK integer
slug string (255)
logement string (10)
nom string (255)
score string (10)
statut string (10)

questions

id increments
timestamps timestamps
softDeletes softDeletes
questionnaire_id ^FK integer
slug string (255)
libelle text
statut string (10)

reponses_questions

timestamps timestamps
id increments
softDeletes softDeletes
question_id ^FK integer
slug string (255)
etat string (10)
libelle text
statut string (10)

invites_reponses_questions

id increments
timestamps timestamps
softDeletes softDeletes
slug string (255)
invite_id ^FK integer
reponse_question_id ^FK integer
statut string (10)

ceremonies

id increments
timestamps timestamps
softDeletes softDeletes
evenement_id ^FK integer
slug string (255)
nom string (255)
lieu string (255)
coordonnees string (255)
description text
date datetime
qr_code_menu string (255)
statut string (10)

categories

id increments
timestamps timestamps
softDeletes softDeletes
evenement_id ^FK integer
slug string (255)
nom string (255)
statut string (10)

positions

id increments
timestamps timestamps
softDeletes softDeletes
slug string (255)
nom string (255)
statut string (10)

positions_photos

id increments
timestamps timestamps
softDeletes softDeletes
slug string (255)
photo_id ^FK integer
position_id ^FK integer

categories_photos

id increments
timestamps timestamps
softDeletes softDeletes
slug string (255)
categorie_id ^FK integer
photo_id ^FK integer

cadeaux

id increments
timestamps timestamps
softDeletes softDeletes
invite_id ^FK integer
slug string (255)
key_pay_api string (255)
montant string (255)
received_amount string (225)
nom string (255)
devise string (255)
methode string (255)
statut string (10)

configs

id increments
timestamps timestamps
softDeletes softDeletes
global_admin_id ^FK integer
slug string (255)
texte_spontane text
prix string (10)
mois_avant integer
plus_mois_avant integer
prix_plus_mois_avant integer
mois_apres integer
plus_mois_apres integer
prix_plus_mois_apres integer
infini_mois_apres string (10)
admin_forme integer
plus_admin_forme integer
prix_plus_admin_forme integer
infini_admin_forme string (10)
ceremonie_max integer
plus_ceremonie_max integer
prix_plus_ceremonie_max integer
infini_ceremonie_max string (10)
invite_max integer
plus_invite_max integer
prix_plus_invite_max integer
infini_invite_max string (10)
photo_max integer
plus_photo_max integer
prix_plus_photo_max integer
infini_photo_max string (10)
cagnotte_max integer
plus_cagnotte_max integer
prix_plus_cagnotte_max integer
infini_cagnotte_max string (10)
num_vert string (255)
statut string (10)

versements

id increments
timestamps timestamps
softDeletes softDeletes
slug string (255)
evenement_id ^FK integer
prix string (10)
mois_avant integer
mois_apres integer
admin_forme integer
ceremonie_max integer
invite_max integer
photo_max integer
cagnotte_max integer
domaine string (255)
statut string (10)

invite_ceremonie

id increments
timestamps timestamps
softDeletes softDeletes
invite_id ^FK integer
ceremonie_id ^FK integer
status string (10)

invites_tables

id increments
timestamps timestamps
softDeletes softDeletes
slug string (225)
invite_id ^FK integer
table_id ^FK integer
statut string (10)

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