Table tariqa3.briefcase_folders
The briefcase folders

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
folder_id int unsigned 10  √ 
briefcase_content.folder_id FK_briefcase_content_folders R
briefcase_content_backup.folder_id Implied Constraint R
briefcase_folder_rss.folder_id fk_briefcase_folder_rss C
briefcase_folders.parent_id FK_briefcase_folders_parents N
The folder identifier
name varchar 100 The folder name
description text 65535  √  null The folder description
parent_id int unsigned 10  √  null
briefcase_folders.folder_id FK_briefcase_folders_parents N
The parent identifier
type_id int unsigned 10  √  null
briefcase_contents_types.type_id FK_briefcase_folders_types R
The type identifier
user_id varchar 16
known_users.user_id Implied Constraint R
The user identifier
archived enum 2  √  n
time timestamp 19 CURRENT_TIMESTAMP

Analyzed at Wed Apr 25 13:30 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
folder_id Primary key Asc PRIMARY
type_id Performance Asc FK_briefcase_folders_types
parent_id Performance Asc Index_2

Close relationships  within of separation: