Table: History_Of_File_Transfer
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
revise__changeset_KEYintNOT NULL
history_action_KEYtinyint (3)NOT NULL
file_transfer_KEYintNOT NULL
file_transfer_type_KEYintNOT NULL
file_transfer_status_KEYintNOT NULL
staff__portal_user_KEYintNOT NULL
staff__contact_KEYintNOT NULL
contact__portal_user_KEYintNOT NULL
contact__contact_KEYintNOT NULL
of__contact_KEYint
subjectnvarchar (255)NOT NULL
bodynvarchar (-1)NOT NULL
file_countintNOT NULL
total_file_sizeintNOT NULL
expiration_date_utcdatetimeNOT NULL
file_transfer_create_date_utcdatetimeNOT NULL
complete_date_utcdatetime
Primary key
NameColumnsDescription
PK_History_Of_File_Transfer$file_transfer_KEY$create__changeset_KEY$revise__changeset_KEYfile_transfer_KEY, create__changeset_KEY, revise__changeset_KEYCLUSTERED

Schema diagram