Table transmart.fmapp.fm_folder 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 int8 19
fm_folder_association.folder_id fk_fm_folder_assoc_fm_folder R
fm_folder_file_association.folder_id fk_fm_folder_fm_folder R
folder_name varchar 1000
folder_full_name varchar 1000
folder_level int8 19
folder_type varchar 100
folder_tag varchar 50  √  null
active_ind bool 1
parent_id int8 19  √  null
description varchar 2000  √  null

Table contained 0 rows at Wed Jun 26 00:11 CEST 2019

Indexes:
Column(s) Type Sort Constraint Name
folder_id Primary key Asc fm_folder_pkey

Close relationships  within of separation: