Table meta_common.users
Permanence System - ACL

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
user_id varchar 16 ID of the officer (As defined in the user_id field of the LDAP database)
creation_time datetime 19 0000-00-00 00:00:00 Date & Time at which this record has been inserted
creation_user_id varchar 16 LDAP user_id of the user who has inserted this record
ldap_title varchar 5  √  null Cached value of the LDAP title attribute
ldap_firstname varchar 255  √  null Cached value of the LDAP firstname attribute
ldap_lastname varchar 255  √  null Cached value of the LDAP lastname attribute
ldap_displayname varchar 255  √  null Cached value of the LDAP displayname attribute
ldap_department varchar 255  √  null Cached value of the LDAP department attribute
ldap_email varchar 255  √  null Cached value of the LDAP email attribute
ldap_phone varchar 255  √  null Cached value of the LDAP phone attribute
ldap_office varchar 255  √  null Cached value of the LDAP office attribute
ldap_group text 65535 Cached value of the LDAP list of user groups (comma separated)
deleted_from_ldap enum 2  √  n If set to 'y' the user has been deleted from LDAP

Analyzed at Wed Apr 25 13:19 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
user_id Primary key Asc PRIMARY