Table iliasRelease_4_2_x_branch.dav_lock Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
token varchar 255
obj_id int 10 0
node_id int 10 0
ilias_owner int 10 0
dav_owner varchar 200  √  null
expires int 10 0
depth int 10 0
type char 1  √  w
scope char 1  √  s

Table contained 0 rows at Fri Apr 22 21:41 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
token Primary key Asc PRIMARY
token Must be unique Asc c1_idx
obj_id + node_id Performance Asc/Asc i1_idx
obj_id + node_id + token Performance Asc/Asc/Asc i2_idx
expires Performance Asc i3_idx