Table schema_generation.admin
InnoDB free: 7168 kB; (`admin_groups_id`) REFER `schema_generation/admin_groups`

Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
admin_id int 11  √ 
admin_groups_id int 11  √  null
admin_groups.admin_groups_id admin_ibfk_1
admin_firstname varchar 32
admin_lastname varchar 32  √  null
admin_email_address varchar 96
admin_password varchar 40
admin_created datetime 19  √  null
admin_modified datetime 19 0000-00-00 00:00:00
admin_logdate datetime 19  √  null
admin_lognum int 11 0

Table contained 0 rows at Mon Jun 18 16:54 CDT 2007

Indexes:
Column(s) Type Sort Constraint Name
admin_id Primary key Asc PRIMARY
admin_email_address Must be unique Asc admin_email_address
admin_groups_id Performance Asc admin_groups_id

Close relationships: