Saas - Laravel Schema Designer

application

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
enabled integer

application_module

application_id integer
module_id integer

module

id increments
timestamps timestamps
softDeletes softDeletes
libelle string (255)
path string (255)

application_config

id increments
timestamps timestamps
application_id integer
key string (75)
value string (255)

application_user

id increments
timestamps timestamps
softDeletes softDeletes
application_id integer
login string (255)
password string (255)
name string (255)
application_user_role_id integer
secret_key string (255)
bearer_token string (255)

application_user_role

id increments
timestamps timestamps
softDeletes softDeletes
role string (255)
level integer

application_user_role_acl

id increments
timestamps timestamps
route string (255)
allowed boolean
application_user_role_id integer

event

id increments
timestamps timestamps
softDeletes softDeletes
owner integer
customer_contact_id integer
application_id integer

acl

id increments
timestamps timestamps
ressource string (255)
rules enum
application_user_id integer
application_user_role_id integer

id increments
timestamps timestamps
ressource string (255)
application_id integer
rules enum

customer_contact

id increments
timestamps timestamps
softDeletes softDeletes
owner integer
customer_service_id integer

advertiser

id increments
timestamps timestamps
softDeletes softDeletes
owner integer
application_id string

product

id increments
timestamps timestamps
softDeletes softDeletes
owner integer
advertiser_id integer
category_id integer
application_id integer

event_state

id increments
timestamps timestamps
event_list_state_id integer
event_id integer

event_date

id increments
timestamps timestamps
date datetime
event_id integer

application_field

id increments
timestamps timestamps
application_id integer
name string (255)
type enum
label string (255)
isRequired boolean
attributs text
module_id integer
condition text
inListing boolean
isSearchable boolean
application_tabs_id integer
location string (255)

application_field_value

id increments
timestamps timestamps
application_field_id integer
value text
ressource string

event_product

id increments
timestamps timestamps
softDeletes softDeletes
product_id integer
event_id integer

customer_groupe

id increments
timestamps timestamps
softDeletes softDeletes
application_id integer

customer_filiale

id increments
timestamps timestamps
softDeletes softDeletes
customer_groupe_id integer
name string (255)

customer_service

id increments
timestamps timestamps
softDeletes softDeletes
customer_filiale_id integer

event_list_state

id increments
timestamps timestamps
libelle string (255)
application_id integer

product_category

id increments
timestamps timestamps
libelle string (255)
application_id integer

product_package_package

id increments
timestamps timestamps
product_id integer
product_package_id integer

product_package

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)

advertiser_contact

id increments
timestamps timestamps
softDeletes softDeletes
advertiser_id integer

application_tabs

id increments
timestamps timestamps
softDeletes softDeletes
application_id integer
libelle string (255)
module_id integer