Ecobank - Laravel Schema Designer

clients

id increments
timestamps timestamps
softDeletes softDeletes
titre enum
firstName string (255)
middleName string (255)
lastName string (255)
nationality string (255)
placeOfBirth string (255)
dateDeNaissance string (255)
genre enum
etatCivil enum
residenceCountry ^FK integer
tel string (255)
tel2 string (255)
email string (255)
adresse string (255)
nui string (255)
rccm string (255)
status string (10)

countries

id increments
timestamps timestamps
softDeletes softDeletes
nom string (255)
nom_complet string (255)
iso_code string (10)
code_telephone string (10)
flag string (10)

comptes

id increments
timestamps timestamps
softDeletes softDeletes
clientType enum
devise string (10)
client ^FK integer
objectif enum
categorie enum
status string (10)

services_financiers

id increments
timestamps timestamps
softDeletes softDeletes
label enum
status string (10)

services_comptes

id increments
timestamps timestamps
softDeletes softDeletes
compte ^FK integer
service_financier ^FK integer
status string (10)

acces_services

id increments
timestamps timestamps
softDeletes softDeletes
label enum
status string (10)

acces_comptes

id increments
timestamps timestamps
softDeletes softDeletes
compte ^FK integer
acces_service ^FK integer
status string (10)

types_comptes

id increments
timestamps timestamps
softDeletes softDeletes
label enum
status string (10)

suscriptions_types_comptes

id increments
timestamps timestamps
softDeletes softDeletes
compte ^FK integer
type_compte ^FK integer
groupe1 enum
groupe2 enum
diaspora boolean
epargne_projet enum
status string (10)

documents

id increments
timestamps timestamps
softDeletes softDeletes
type enum
documentNumber string (255)
dateDelivrance date
dateExpiration date
placeOflssue string (255)
countryoflssue ^FK integer
compte ^FK integer
status string (10)

parents

id increments
timestamps timestamps
softDeletes softDeletes
type enum
nom string (255)
prenom string (255)
prenom2 string (255)
relation string (255)
tel string (255)
tel2 string (255)
adresse string (255)
email string (255)
client ^FK integer
status string (10)

status_emploi

id increments
timestamps timestamps
softDeletes softDeletes
client ^FK integer
situation enum
trancheevenu enum
salaried_employerName string (255)
salaried_designation string (255)
salaried_industry string (255)
salaried_condition enum
soleProprietor_businessName string (255)
soleProprietor_registrationNo string (255)
soleProprietor_kraPin string (255)
soleProprietor_nature string (255)
student_institutionName string (255)
student_location string (255)
student_program string (255)
student_id string (255)
status string (10)

relations_in_bank

id increments
timestamps timestamps
softDeletes softDeletes
client ^FK integer
name string (255)
tel string (255)
existingAccountNumber string (255)
status string (10)

releves_comptes

id increments
timestamps timestamps
softDeletes softDeletes
compte ^FK integer
modeEnvoi enum
periode enum
status string (10)

cartes

id increments
timestamps timestamps
softDeletes softDeletes
compte ^FK integer
visa enum
prepaye enum
autres string (255)
status string (10)

produits_numeriques

id increments
timestamps timestamps
softDeletes softDeletes
label enum
status string (10)

suscriptions_produits_numeriques

id increments
timestamps timestamps
softDeletes softDeletes
produit_numerique ^FK integer
compte ^FK integer
status string (10)

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