Table of Contents

dbo.filearchive

Columns

Column name1) Column type Description Notes
PK fa_id INT
fa_name NVARCHAR(255)
fa_archive_name NVARCHAR(255)
fa_storage_group NVARCHAR(16)
fa_storage_key NVARCHAR(64)
fa_deleted_user INT
fa_deleted_timestamp VARCHAR(14)
fa_deleted_reason NVARCHAR(MAX)
fa_size INT
fa_width INT
fa_height INT
fa_metadata VARBINARY(MAX)
fa_bits INT
fa_media_type VARCHAR(16)
fa_major_mime VARCHAR(16)
fa_minor_mime NVARCHAR(100)
fa_description NVARCHAR(255)
FK1 fa_user INT
fa_user_text NVARCHAR(255)
fa_timestamp VARCHAR(14)
fa_deleted TINYINT
fa_sha1 NVARCHAR(32)

Relationships

This table belongs to the Content module.

References to other tables

Attributes
(in this table) 		Referenced table Referenced attributes
(in referenced table)
FK1 fa_user dbo.mwuser user_id

References to this table from others

Relationship Attributes
(in referencing table) 		Referenced attributes
(in this table)
(None).

Page generated from database metadata by DbScout.

1)
Columns with names in bold are non-nullable; columns with underlined names are participants in the table's primary key.