phoenix - Laravel Schema Designer

users

id increments
ldap_id string
first_name string
last_name string
timestamps timestamps

profiles

id increments
name string
description string
type string
timestamps timestamps

ldap_attributes

id increments
name string
active string
source string
timestamps timestamps

businesscategory

id increments
name string
description string
timestamps timestamps

departmentnumber

id increments
businesscategory_id ^FK integer
name string
description string
timestamps timestamps

ldap_attribute_profile_rights

id increments
profile_id ^FK integer
ldap_attribute_id ^FK integer
type string
ldap_filter string
timestamps timestamps

operational_profile_rights

id increments
profile_id ^FK integer
account_type_id ^FK integer
create boolean
update boolean
delete boolean
ldap_filter string
timestamps timestamps

account_types

id increments
timestamps timestamps
name string
description string (255)
creation boolean
inbound_transition boolean
outbound_transition boolean
deletion boolean

leases

id increments
start_date datetime
end_date datetime
timestamps timestamps

accounts

id increments
ldap_id string
user_id ^FK integer
timestamps timestamps

profile_user

id increments
user_id ^FK integer
profile_id ^FK integer
timestamps timestamps

ldap_attribute_user_rights

id increments
user_id ^FK integer
ldap_attribute_id ^FK integer
type string
ldap_filter string
timestamps timestamps

operational_user_rights

id increments
user_id ^FK integer
account_type_id ^FK integer
create boolean
update boolean
delete boolean
ldap_filter string
timestamps timestamps

requirements

id increments
timestamps timestamps
ldap_attribute_id ^FK integer
type string
account_type_id ^FK integer
template string
required boolean
validation_string string (255)

lease_values

id increments
timestamps timestamps
lease_id ^FK integer
ldap_attribute_id ^FK integer
value string (255)

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