Table tariqa3.briefcase_content_backup
The briefcase content backup

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
content_id int unsigned 10
briefcase_content.content_id Implied Constraint R
The content identifier
name blob 65535 The content name
type_id int unsigned 10
briefcase_contents_types.type_id Implied Constraint R
The content type
folder_id int unsigned 10  √  null
briefcase_folders.folder_id Implied Constraint R
The content folder
data longblob 2147483647  √  null The content data
description text 65535  √  null The content descirption
mime_type varchar 255  √  null The content mime type or NULL
length int unsigned 10  √  null The content length or NULL
item_id varchar 255  √  null The item identifier (e.g.: article id)
user_id varchar 16
known_users.user_id Implied Constraint R
The user identifier
display_order int 10 0

Analyzed at Wed Apr 25 13:30 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
content_id Primary key Asc PRIMARY
folder_id Performance Asc Index_folder_id
type_id Performance Asc Index_type_id

Close relationships: