Table studipjlu_31.files 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
file_id char 32
file_refs.file_id Implied Constraint R
user_id char 32
user_online.user_id Implied Constraint R
filename varchar 255
mime_type varchar 64
size bigint unsigned 20
restricted bit 0 0
storage varchar 32 DiskFileStorage
storage_id varchar 32
mkdate int unsigned 10 0
chdate int unsigned 10 0

Table contained 0 rows at Do Aug 02 15:57 GMT+01:00 2018

Indexes:
Column(s) Type Sort Constraint Name
file_id Primary key Asc PRIMARY

Close relationships: