sofidy - Laravel Schema Designer

funds

id increments
fund_type_id ^FK bigInteger
name string
country_id ^FK bigInteger
currency string
closing_date date
name_documentation_file string
mime_type_documentation_file string
data_documentation_file binary
timestamps timestamps

fund_type

id increments
name string
slug string

shares

id increments
fund_id ^FK bigInteger
isin string
price float
percentage float (3,2)
currency_name string
nominal integer
mqnp integer
mqfp integer
mime_type_logo string
data_logo binary
timestamps timestamps

subscription_periods

id increments
share_id ^FK bigInteger
name string
start date
end date
timestamps timestamps
softDeletes softDeletes

customers

id increments
entity_id ^FK bigInteger
customer_type_id ^FK bigInteger
customer_class_id ^FK bigInteger
email string
status tinyInteger
main_entity_available tinyInteger
form_contact_user tinyInteger
first_name string
last_name string
company_name string
phone_number string
cgp_code string
password string
remember_token string
registration_token string
is_registered tinyInteger
is_deactivated tinyInteger
comments string
timestamps timestamps

subscriptions

id increments
customer_id ^FK bigInteger
subscription_period_id ^FK bigInteger
questionnaire_id ^FK bigInteger
data_ck_document binary
timestamps timestamps

questionnaire

id increments
step1 json
step2 json
step3 json
step4 json
step5 json
step6 json
timestamps timestamps

reports

id increments
subscription_id ^FK bigInteger
number_shares smallInteger
data binary
timestamps timestamps

countries

id increments
code string (2)
name string

country_share

id increments
counrty_id ^FK bigInteger
share_id ^FK bigInteger

entities

id increments
name string
entity_code string
timestamps timestamps

customer_type

id increments
timestamps timestamps

customer_class

id increments
name string
label string
timestamps timestamps

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