payment - Laravel Schema Designer

banks

id increments
timestamps timestamps
bankName string (50)

organinsations

id increments
timestamps timestamps
name string (150)
address string (255)
phone_number string (25)
wallet_id ^FK integer

wallets

id increments
timestamps timestamps
balance decimal (15,2)
status tinyInteger

organisationBanks

id increments
timestamps timestamps
accountNumber string (50)
organinsation_id ^FK integer
bank_id ^FK integer

merchatns

id increments
timestamps timestamps
social_reason string (100)
address string (255)
phone_number string (30)
email string (100)
website string (100)
wallet_id ^FK integer

walletTransactions

id increments
timestamps timestamps
wallet_id ^FK integer
status tinyInteger
merchant_id ^FK integer
transaction_initialized_by ^FK integer
transaction_validated_by ^FK integer
financial_institution string (100)

Users

id increments
timestamps timestamps
user_name string (50)
user_password string (255)
remember_token string (255)
lock_enabled tinyInteger
is_active tinyInteger
login_attemps smallInteger
lock_expired_at datetime
double_auth_active tinyInteger

UserInfos

id increments
timestamps timestamps
firstname string (50)
lastname string (50)
address string (255)
email string (150)
other_email string (150)
phone_number string (30)
postal_code string
birthdate string (255)
sex enum
user_id ^FK integer
organinsation_id ^FK integer

roles

id increments
timestamps timestamps
label string (100)
display_label string (255)
description text

roleUsers

id increments
timestamps timestamps
user_id ^FK integer
role_id ^FK integer

permissions

id increments
timestamps timestamps
label string (100)
display_label string (255)
description text

PermissionRoles

id increments
timestamps timestamps
permission_id ^FK integer
role_id ^FK integer

merchantPlateformConfigs

id increments
timestamps timestamps
merchant_logo string (75)
plateform_primary_color string (50)
plateform_secondary_color string (50)
reference_get_url string (255)
reference_list_get_url string (255)
notification_url string (255)
merchant_id ^FK integer

userConnexions

id increments
timestamps timestamps
identifier string (100)
status tinyInteger
ip_address string (25)

plateformConfigurations

id increments
timestamps timestamps
key string (60)
value string (60)

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