Home
TICAdashboard
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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