datafields

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
datafield_id VARCHAR 32
name VARCHAR 255 null
object_type enum('sem', 'inst', 'user', 'userinstrole', 'usersemdata', 'roleinstdata', 'moduldeskriptor', 'modulteildeskriptor') 19 null
object_class VARCHAR 255 null
edit_perms enum('user', 'autor', 'tutor', 'dozent', 'admin', 'root') 6 null
view_perms enum('all', 'user', 'autor', 'tutor', 'dozent', 'admin', 'root') 6 null
priority TINYINT UNSIGNED 3 0
mkdate INT UNSIGNED 10 null
chdate INT UNSIGNED 10 null
type enum('bool', 'textline', 'textarea', 'selectbox', 'date', 'time', 'email', 'phone', 'radio', 'combo', 'link', 'selectboxmultiple') 17 textline
typeparam TEXT 65535 null
is_required TINYINT 3 0
is_userfilter TINYINT UNSIGNED 3 0
description TEXT 65535 null
system BIT 1 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc datafield_id
object_type Performance Asc object_type

Diagram producer might be missing

No diagrams were produced please see application output for any errors