View tariqapro.users 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:31 CEST 2012

View Definition:
select `meta_common`.`users`.`user_id` AS `user_id`,`meta_common`.`users`.`creation_time` AS `creation_time`,`meta_common`.`users`.`creation_user_id` AS `creation_user_id`,`meta_common`.`users`.`ldap_title` AS `ldap_title`,`meta_common`.`users`.`ldap_firstname` AS `ldap_firstname`,`meta_common`.`users`.`ldap_lastname` AS `ldap_lastname`,`meta_common`.`users`.`ldap_displayname` AS `ldap_displayname`,`meta_common`.`users`.`ldap_department` AS `ldap_department`,`meta_common`.`users`.`ldap_email` AS `ldap_email`,`meta_common`.`users`.`ldap_phone` AS `ldap_phone`,`meta_common`.`users`.`ldap_office` AS `ldap_office`,`meta_common`.`users`.`ldap_group` AS `ldap_group`,`meta_common`.`users`.`deleted_from_ldap` AS `deleted_from_ldap` from `meta_common`.`users`