TICAdashboard - Laravel Schema Designer

collaborateurs

id increments
timestamps timestamps
prenom string (30)
nom string (30)
initiales string (4)
email string (255)
date_arrivee date
date_depart date
salaire smallInteger
taux_facturable decimal (2,4)
infos string (255)
type_collaborateur_id ^FK integer

partenaires

id increments
timestamps timestamps
denomination string (50)
adresse string (255)
complement_adresse string (255)
code_postal string (5)
ville string (255)
telephone_fixe string (10)
telephone_portable string (10)
email string (255)
site_internet string (255)
prenom_contact string (255)
nom_contact string (255)
fonction_contact string (255)
forme_juridique string (10)
capital mediumInteger
siret string (14)
siren string (9)
rcs string (255)
naf_ape string (5)
infos string (255)

clients

id increments
timestamps timestamps
denomination string (50)
adresse string (255)
complement_adresse string (255)
code_postal string (5)
ville string (255)
telephone_fixe string (10)
telephone_portable string (10)
email string (255)
site_internet string (255)
prenom_contact string (255)
nom_contact string (255)
fonction_contact string (255)
forme_juridique string (10)
capital mediumInteger
siret string (14)
siren string (9)
rcs string (255)
naf_ape string (5)
infos string (255)
type_client_id ^FK integer

projets

id increments
timestamps timestamps
denomination_courte string (6)
denomination string (255)
date_demarrage date
is_termine boolean
couleur string (11)
adresse string (255)
complement_adresse string (255)
code_postal string (5)
ville string (255)
infos text
client_id ^FK integer
type_projet_id ^FK integer

phases

id increments
timestamps timestamps
date_prevue date
is_terminee boolean
is_option boolean
is_facturable boolean
is_avenant boolean
infos string (255)
projet_id ^FK integer
type_phase_id ^FK integer

missions

id increments
timestamps timestamps
competences string (255)
honoraires decimal (6,2)
tva decimal (4,4)
partenaire_id ^FK integer
phase_id ^FK integer

factures

id increments
timestamps timestamps
date_facture date
date_paiement date
date_relance date
pourcentage decimal (4,4)
infos string (255)
phase_id ^FK integer
reference string (255)

evenements

id increments
timestamps timestamps
debut datetime
fin datetime
duree smallInteger
is_css boolean
is_cp boolean
is_cm boolean
infos string (255)
collaborateur_id ^FK integer
phase_id ^FK integer

type_collaborateurs

id increments
timestamps timestamps
type string (30)
cout_horaire smallInteger

type_phases

id increments
timestamps timestamps
denomination string (255)
sigle string (12)

partenaire_projet

id increments
timestamps timestamps
partenaire_id ^FK integer
projet_id ^FK integer

type_projets

id increments
timestamps timestamps
type string (30)

parametres

id increments
timestamps timestamps
cle string (30)
valeur mediumInteger

deplacements

id increments
timestamps timestamps
date date
distance mediumInteger
phase_id integer
collaborateur_id ^FK integer

charges

id increments
timestamps timestamps
montant_ht decimal
tva decimal (4,4)
infos string (255)
collaborateur_id ^FK integer

vehicules

id increments
timestamps timestamps
denomination string (50)
type tinyInteger
infos string (255)
collaborateur_id ^FK integer

taches

id increments
timestamps timestamps
description string (255)
is_termine boolean
phase_id ^FK integer

type_prospections

id increments
timestamps timestamps
denomination string (255)

evenement_prospections

id increments
timestamps timestamps
date date
infos text
client_id ^FK integer

type_clients

id increments
timestamps timestamps
type string (255)
segment string (255)
is_public boolean

evenement_prospection_type_prospection

id increments
timestamps timestamps
evenement_prospection_id ^FK integer
type_prospection_id ^FK integer

candidatures

id increments
timestamps timestamps
lieu string (255)
distance smallInteger
date_publication date
date_reponse date
denomination string (255)
prenom_contact string (255)
nom_contact string (255)
telephone_contact string (10)
email_contact string (255)
montant_travaux mediumInteger
surface smallInteger
prix_surface smallInteger
infos text
competences_attendues text
reponse tinyInteger
is_offre boolean
is_methodo boolean
is_retenu boolean
is_seconde_phase boolean
client_id ^FK integer
collaborateur_id ^FK integer

candidature_partenaire

id increments
timestamps timestamps
competences string (255)
is_mandataire boolean
is_contacte boolean
is_partant boolean
is_transmis boolean
candidature_id ^FK integer
partenaire_id ^FK integer

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