strooka - Laravel Schema Designer

customers

id integer
uuid string
email string (100)
password string (255)
access_token text
verified tinyInteger
guest tinyInteger
creation_time timestamp
activation_time timestamp
last_access timestamp
deleted tinyInteger

customer_data_types

id integer
name string (255)

customer_data

id integer
customer_data_has_marchant_id ^FK bigInteger
customer_data_type_id ^FK integer
name string (255)
surname string (255)
country_code string (3)
address_1 string (255)
address_2 string (255)
city string (255)
district string (255)
postal_code string (255)
phone string (255)
extra_fields longText
default_address tinyInteger
creation_time timestamp
deleted tinyInteger

customer_social_login_data

id bigInteger
user_id ^FK bigInteger
social_id string
social_type string
last_access timestampsTz

merchants

id increments
timestamps timestamps
softDeletes softDeletes

customer_has_merchants

id increments
timestamps timestamps
softDeletes softDeletes
customer_id ^FK bigInteger
marchant_id ^FK bigInteger
credit float
newsletter boolean
fidelity_points integer

providers

id increments
timestamps timestamps
softDeletes softDeletes
name string

marchants_has_providers

id increments
timestamps timestamps
softDeletes softDeletes

customerMarchant_has_providerMarchant

id increments
timestamps timestamps
softDeletes softDeletes
customer_has_marchant_id ^FK bigInteger
provider_has_marchant_id ^FK bigInteger
last_access timestampsTz

policies

id increments
timestamps timestamps
softDeletes softDeletes
customer_has_marchant_id ^FK bigInteger
marchant_id ^FK bigInteger

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