Home
Saas
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (2)
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
share
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
×
Comments for Saas
jeremydil . 12 June 2015
User => un role Role à un level (0 = superadmin, 1 = admin, 2 = commercial, ...) Au role des acl sur route sont créer. A ce niveau seul les routes sont géré. La table acl, lié au différente ressource, permet de donner les droits sur les ressource (deny, read, create, update, delete) C'est règle peut être ressource #41 has Read si application_user = 1 ressource #41 has update si application_user_role = admin Les règles seront computé. Dans l'admin, pour un module-ressource, il sera possible de définir une règle générale qui s'enregistrera la style : pour toute nouvelle ressource, user owner a tout les droits.
jeremydil . 12 June 2015
Ressource : module.id
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01