Table tariqa3.briefcase_content
The briefcase content

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_backup.content_id Implied Constraint R
rss_log.content_id fk_log_briefcase N
The content identifier
name blob 65535 The content name
type_id int unsigned 10
briefcase_contents_types.type_id FK_briefcase_content_types R
The content type
folder_id int unsigned 10  √  null
briefcase_folders.folder_id FK_briefcase_content_folders 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 FK_briefcase_content_users C
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
user_id Performance Asc FK_briefcase_content_users
type_id Performance Asc Index_2
folder_id Performance Asc Index_3
item_id Performance Asc ixItem

Close relationships  within of separation: