Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
property_id | VARCHAR | 32 |
|
|
||||
name | VARCHAR | 255 |
|
|
||||
description | TEXT | 65535 | √ | null |
|
|
||
type | set('bool', 'text', 'num', 'select', 'user', 'institute', 'position', 'fileref', 'url', 'resource_ref_list') | 74 | √ | null |
|
|
||
options | TEXT | 65535 | null |
|
|
|||
system | BIT | 1 | 0 |
|
|
|||
info_label | TINYINT | 3 | 0 |
|
|
|||
display_name | VARCHAR | 512 |
|
|
||||
searchable | BIT | 1 | 0 |
|
|
|||
range_search | BIT | 1 | 0 |
|
|
|||
write_permission_level | VARCHAR | 16 | admin-global |
|
|
|||
property_group_id | INT | 10 | √ | null |
|
|
||
property_group_pos | TINYINT | 3 | √ | null |
|
|
||
mkdate | INT UNSIGNED | 10 | 0 |
|
|
|||
chdate | INT UNSIGNED | 10 | 0 |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | property_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors