Table: History_Of_File_Transfer | |||
Columns | |||
Name | Type | Constraints | Description |
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL | |
revise__changeset_KEY | int | NOT NULL | |
history_action_KEY | tinyint (3) | NOT NULL | |
file_transfer_KEY | int | NOT NULL | |
file_transfer_type_KEY | int | NOT NULL | |
file_transfer_status_KEY | int | NOT NULL | |
staff__portal_user_KEY | int | NOT NULL | |
staff__contact_KEY | int | NOT NULL | |
contact__portal_user_KEY | int | NOT NULL | |
contact__contact_KEY | int | NOT NULL | |
of__contact_KEY | int | ||
subject | nvarchar (255) | NOT NULL | |
body | nvarchar (-1) | NOT NULL | |
file_count | int | NOT NULL | |
total_file_size | int | NOT NULL | |
expiration_date_utc | datetime | NOT NULL | |
file_transfer_create_date_utc | datetime | NOT NULL | |
complete_date_utc | datetime |
Primary key | |||
Name | Columns | Description | |
PK_History_Of_File_Transfer$file_transfer_KEY$create__changeset_KEY$revise__changeset_KEY | file_transfer_KEY, create__changeset_KEY, revise__changeset_KEY | CLUSTERED |