resource_property_definitions

13 rows


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