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)
gps_longitude string (255)
gps_latitude 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
depotInitial string (255)
methode_financement_pref enum
signature_date date
interpreter_name string (255)
interpreter_address string (255)
interpreter_language string (255)
bank_accountNumber string (255)
bank_customerld string (255)
bank_accountofficer string
bank_branchCode string
date_approbation date
bank_approvedBy string
risques string (255)
statut_verification string (255)
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)

mobiles_money

id increments
timestamps timestamps
softDeletes softDeletes
compte ^FK integer
orangeMoney string (255)
mtnMobileMoney string (255)
autre string (255)
status string (10)

bancassurances

id increments
timestamps timestamps
softDeletes softDeletes
label enum
fraisEnterrement string (255)
mrh string (255)
compteParrain string (255)
sante string (255)
auto string (255)
cartes string (255)
compte ^FK integer
status string (10)

effectifs_pour_comptes

id increments
timestamps timestamps
softDeletes softDeletes
categorie enum
lettre_indemnisation boolean
signature_cachet boolean
confirmation_cheque boolean
instructions_amountToConfirm string
compte ^FK integer
status string (10)

pieces_jointes

id increments
timestamps timestamps
softDeletes softDeletes
compte ^FK integer
date date
nom string (255)
path string (255)
status string (10)

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