| Table p_file_info |
|
Description: Store information about the physical location of a file linked into Petra |
| PRIMARY KEY | ||
|
p_key_n
bigint NOT NULL | ||
|
p_partner_key_n
bigint NOT NULL | Partner key that the file is linked with (needed for performance reasons) | p_partner |
|
s_volume_name_c
varchar (160) | Volume this file can be found in (use either volume or path) | s_volume |
|
p_path_c
varchar (4096) | Path this file can be found in (use either volume or path) | |
|
p_file_name_c
varchar (1024) | File name this file can be found under in given volume or path | |
|
p_name_c
varchar (160) | Internal name of the file, different from actual file name | |
|
p_file_type_c
varchar (100) | Information about the file type | |
|
p_comment_c
varchar (1000) | Comment for the user | |
|
p_restricted_l
boolean default: '0' | Indicates whether or not the file info has restricted access. If it does then the access will be controlled by s_group_file_info. | |
|
s_date_created_d
date default: CURRENT_DATE | The date the record was created. | |
|
s_created_by_c
varchar (20) | User ID of who created this record. | s_user |
|
s_date_modified_d
date | The date the record was modified. | |
|
s_modified_by_c
varchar (20) | User ID of who last modified this record. | s_user |
|
s_modification_id_t
timestamp default: CURRENT_TIMESTAMP | This identifies the current version of the record. | |
FOREIGN KEY p_file_info_fk1: p_partner_key_n => p_partner p_file_info_fk2: s_volume_name_c => s_volume p_file_info_fkcr: s_created_by_c => s_user p_file_info_fkmd: s_modified_by_c => s_user | ||
REFERENCED BY p_partner_graphic, p_partner_file, pm_person_file, p_partner_contact_file, pm_document_file, pm_application_file, s_group_file_info | ||