Table of Contents

Table Sys_Object_Files

Entity

Entity: Systems.Core.ObjectFiles

Contains files attached to objects. Entity: Sys_Object_Files

Owner Tables Hierarchy

Summary

Name Type Description
Access_Permission nvarchar(2) Allowed: CU, IN, EX Indicates who has permission to access this file.
Content_Location nvarchar(3) Allowed: EMB, URL, FSL The location of the file contents. EMB=Embedded in the database; URL=Internet URL; FSL=File system link.
Creation_Time_Utc datetime Time (in UTC), when the file was created.
Creation_User_Id uniqueidentifier The user, who created the file record. NULL if it is unknown.
Embedded_File_Contents varbinary Contains the contents of the file, when it is embedded in the database. NULL for linked files
Embedded_Thumbnail_Contents varbinary Readonly Contains the compressed and/or resized contents of the file if applicable.
File_Name nvarchar(254) The file name of the linked or embedded file
File_Size_Bytes int The file size in bytes. If empty the file size is unknown.
Last_Update_Time_Utc datetime Time (in UTC), when the file was last updated.
Last_Update_User_Id uniqueidentifier The user, who performed the last update to the file record. NULL if it is unknown.
Linked_File_Path nvarchar(1024) When the file is linked, contains the full path (including the file name) to the linked file. NULL for embedded files
Media_Height int Used (non-null) only for media files. Specifies the width for displaying the media.
Media_Type nvarchar(128) For media files, contains the Media Type as per the IANA registry (formerly known as the MIME Type). NULL for non-media files.
Media_Width int Used (non-null) only for media files. Specifies the width for displaying the media.
Notes nvarchar(max) User notes for the file attachment
Object_File_Id uniqueidentifier PK .
Object_Id uniqueidentifier The object to which the file is attached
Purpose_Code nvarchar(32) Code, designating the usage purpose of the file. The meaning of each code is up to the application with the exception of 'default/image', which is standartised as the default image for many types of objects.
Row_Version timestamp
Section nvarchar(64) A section name used to group files

Columns

Access_Permission

Indicates who has permission to access this file.

Property Value
Allowed Values CU, IN, EX
Auto Complete no
Data Filter no
Default Value IN
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type nvarchar(2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Access_Permission - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Content_Location

The location of the file contents. EMB=Embedded in the database; URL=Internet URL; FSL=File system link.

Property Value
Allowed Values EMB, URL, FSL
Auto Complete no
Data Filter no
Default Value EMB
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 3
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type nvarchar(3)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Content_Location - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Creation_Time_Utc

Time (in UTC), when the file was created.

Property Value
Auto Complete no
Data Filter no
Default Value CurrentDateTimeUtc
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type datetime
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Creation_Time_Utc - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Creation_User_Id

The user, who created the file record. NULL if it is unknown.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Sec_Users
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Creation_User_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Embedded_File_Contents

Contains the contents of the file, when it is embedded in the database. NULL for linked files

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type varbinary (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Embedded_Thumbnail_Contents

Contains the compressed and/or resized contents of the file if applicable.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly yes
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type varbinary (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

File_Name

The file name of the linked or embedded file

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 254
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(254)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

File_Name - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
Like None no no

File_Size_Bytes

The file size in bytes. If empty the file size is unknown.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type int (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Last_Update_Time_Utc

Time (in UTC), when the file was last updated.

Property Value
Auto Complete no
Data Filter no
Default Value CurrentDateTimeUtc
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type datetime
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Last_Update_Time_Utc - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Last_Update_User_Id

The user, who performed the last update to the file record. NULL if it is unknown.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Sec_Users
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Last_Update_User_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Linked_File_Path

When the file is linked, contains the full path (including the file name) to the linked file. NULL for embedded files

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 1024
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(1024) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Linked_File_Path - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no
Like None no no

Media_Height

Used (non-null) only for media files. Specifies the width for displaying the media.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type int (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Media_Type

For media files, contains the Media Type as per the IANA registry (formerly known as the MIME Type). NULL for non-media files.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 128
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(128) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Media_Width

Used (non-null) only for media files. Specifies the width for displaying the media.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type int (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Notes

User notes for the file attachment

Property Value
Attributes IsLongString
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2147483647
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(max) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Object_File_Id

.

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key yes (order: 1)
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Object_File_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes

Object_Id

The object to which the file is attached

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference yes
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Sys_Objects
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Object_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes

Purpose_Code

Code, designating the usage purpose of the file. The meaning of each code is up to the application with the exception of 'default/image', which is standartised as the default image for many types of objects.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 32
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(32) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Purpose_Code - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Row_Version

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type timestamp
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Section

A section name used to group files

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 64
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(64) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes
Suggest improvement to this page