Documentation/EHI_Export/docs/tables/modules.html
| 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 |
|
| |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | mod_id + mod_directory |