user_inst

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id VARCHAR 32 0
Institut_id VARCHAR 32 0
inst_perms enum('user', 'autor', 'tutor', 'dozent', 'admin') 6 user
sprechzeiten VARCHAR 200
raum VARCHAR 200
Telefon VARCHAR 32
Fax VARCHAR 32
externdefault TINYINT UNSIGNED 3 0
priority TINYINT UNSIGNED 3 0
visible TINYINT UNSIGNED 3 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc Institut_id + user_id
inst_perms Performance Asc/Asc inst_perms + Institut_id
user_id Performance Asc/Asc user_id + inst_perms

Diagram producer might be missing

No diagrams were produced please see application output for any errors