modules


Columns

Column Type Size Nulls Auto Default Children Parents Comments
mod_id INT 10 √ null
mod_name VARCHAR 64 '0'
mod_directory VARCHAR 64 ''
mod_parent VARCHAR 64 ''
mod_type VARCHAR 64 ''
mod_active INT UNSIGNED 10 0
mod_ui_name VARCHAR 64 ''
mod_relative_link VARCHAR 64 ''
mod_ui_order TINYINT 3 0
mod_ui_active INT UNSIGNED 10 0
mod_description VARCHAR 255 ''
mod_nick_name VARCHAR 25 ''
mod_enc_menu VARCHAR 10 'no'
permissions_item_table CHAR 100 √ NULL
directory VARCHAR 255 null
date DATETIME 19 null
sql_run TINYINT 3 √ 0
type TINYINT 3 √ 0
sql_version VARCHAR 150 null
acl_version VARCHAR 150 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc mod_id + mod_directory

Relationships

Close relationships within degrees of separation