SchemaSpy Analysis of transmart.fmapp - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Jun 26 00:11 CEST 2019 |
| ||||||
|
transmart.fmapp contains 29 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
fm_file | active_ind | bool | 1 | ||||
fm_folder | active_ind | bool | 1 | ||||
fm_file | create_date | timestamp | 29,6 | ||||
fm_folder | description | varchar | 2000 | √ | null | ||
fm_file | display_name | varchar | 1000 | ||||
fm_file | file_id | int8 | 19 | ||||
fm_folder_file_association | file_id | int8 | 19 | ||||
fm_file | file_size | numeric | 131089 | √ | null | ||
fm_file | file_type | varchar | 100 | √ | null | ||
fm_file | file_version | numeric | 131089 | √ | null | ||
fm_file | filestore_location | varchar | 1000 | √ | null | ||
fm_file | filestore_name | varchar | 1000 | √ | null | ||
fm_data_uid | fm_data_id | int8 | 19 | ||||
fm_data_uid | fm_data_type | varchar | 100 | ||||
fm_folder | folder_full_name | varchar | 1000 | ||||
fm_folder | folder_id | int8 | 19 | ||||
fm_folder_association | folder_id | int8 | 19 | ||||
fm_folder_file_association | folder_id | int8 | 19 | ||||
fm_folder | folder_level | int8 | 19 | ||||
fm_folder | folder_name | varchar | 1000 | ||||
fm_folder | folder_tag | varchar | 50 | √ | null | ||
fm_folder | folder_type | varchar | 100 | ||||
fm_file | link_url | varchar | 1000 | √ | null | ||
fm_folder_association | object_type | varchar | 100 | ||||
fm_folder_association | object_uid | varchar | 300 | ||||
fm_file | original_name | varchar | 1000 | ||||
fm_folder | parent_id | int8 | 19 | √ | null | ||
fm_data_uid | unique_id | varchar | 300 | ||||
fm_file | update_date | timestamp | 29,6 |