Atelier - Laravel Schema Designer

professeurs

id increments
nom string (150)
prenom string (150)
password string (100)
email string (100)
telephone integer
telephoneportable integer
adresse text
code_postal string (5)
ville string (191)
descriptif string (191)
timestamps timestamps
softDeletes softDeletes

directions

id increments
atelier_id ^FK integer
nom string (191)
prenom string (191)
role enum
password string (191)
email string (191)
telephone integer
telephoneportable integer
adresse text
code_postal string (5)
ville string (191)
timestamps timestamps
softDeletes softDeletes

prospects

id increments
nom string (191)
prenom string (191)
email string (191)
telephone integer
timestamps timestamps
softDeletes softDeletes

ateliers

id increments
nom string (191)
descriptif string (191)
adresse_atelier text
telephone integer
telephoneportable integer
timestamps timestamps
softDeletes softDeletes

atelier_prospect

id increments
prospect_id ^FK integer
atelier_id ^FK integer
timestamps timestamps
softDeletes softDeletes

eleves

id increments
nom string (191)
prenom string (191)
email text
telephone integer
telephoneportable integer
adresse text
code_postal string (5)
Ville string (191)
timestamps timestamps
softDeletes softDeletes
password string (191)

matieres

id increments
professeur_id ^FK integer
nom string (191)
effectif tinyInteger
type enum
descriptif string (191)
timestamps timestamps
softDeletes softDeletes

lecons

id increments
achat_id ^FK integer
horaire_id ^FK integer
date datetime
etat enum
commentaire string (191)
timestamps timestamps
softDeletes softDeletes

forfaits

id increments
nom text
prix float
nombre_cours integer
type enum
delais_mois tinyInteger
delais_semaine tinyInteger
delais_date datetime
officiel tinyInteger
timestamps timestamps
softDeletes softDeletes

honoraires

id increments
contrat_id ^FK integer
base_honoraire float
prime decimal (4,2)
honoraire float
date datetime
nombre_eleves integer
CA_matiere float
timestamps timestamps
softDeletes softDeletes

contrats

id increments
matiere_id ^FK integer
remuneration_style enum
remuneration decimal (5,2)
seuil_prime_remplissage tinyInteger
prime_remplissage decimal (4,2)
prime_1e decimal (4,2)
prime_2e decimal (4,2)
date date
timestamps timestamps
softDeletes softDeletes

honoraire_professeur

id increments
professeur_id ^FK integer
honoraire_id ^FK integer
timestamps timestamps
softDeletes softDeletes

achats

id increments
forfait_id ^FK integer
forfait_prix float (8,2)
date_debut date
date_validite date
date_achat date
facture_id integer
numero_facture tinyInteger
destination enum
proformat integer
convention tinyInteger
timestamps timestamps
softDeletes softDeletes

horaires

id increments
horaire_debut time
horaire_fin time
jours enum
timestamps timestamps
softDeletes softDeletes

medias

id increments
professeur_id ^FK integer
titre string (70)
img string (191)
video string (45)
format string (45)
description string (191)
timestamps timestamps
softDeletes softDeletes

horaireable

id increments
horaire_id ^FK integer
horaireable_id string
horaireable_type string
timestamps timestamps
softDeletes softDeletes

matiereable

id increments
matiere_id ^FK integer
matiereable_id string
matiereable_type string
timestamps timestamps
softDeletes softDeletes

honoraireable

id increments
honoraire_id ^FK integer
honoraireable_type string
honoraireable_id string
timestamps timestamps
softDeletes softDeletes

mediasable

id increments
media_id ^FK integer
mediasable_id string
mediasable_type string
timestamps timestamps
softDeletes softDeletes

achat_eleve

id increments
eleve_id ^FK integer
achat_id ^FK integer
timestamps timestamps
softDeletes softDeletes

factures_professeurs

id increments
date_debut date
date_fin date
honoraire_mensuel float
CA_mensuel float
timestamps timestamps
softDeletes softDeletes

honoraire_facture

id increments
honoraire_id ^FK integer
honoraire_facture_id ^FK integer
timestamps timestamps
softDeletes softDeletes

paiements

id increments
achat_id ^FK integer
paiement_type enum
date date
banque tinyInteger
montant float (8,2)
timestamps timestamps
softDeletes softDeletes

fermetures

id increments
date_debut datetime
date_fin datetime
descriptif string (191)
timestamps timestamps
softDeletes softDeletes

forfait_matiere

id increments
forfait_id ^FK integer
matiere_id ^FK integer
timestamps timestamps
softDeletes softDeletes

achat_horaire

id increments
achat_id ^FK integer
horaire_id ^FK integer
timestamps timestamps
softDeletes softDeletes

dates

id increments
matiere_id ^FK integer
date_debut date
date_fin date
horaire_debut time
horaire_fin time
descriptif string
timestamps timestamps