CREATE TABLE [File].[FileDetail]
(
    [Id] [bigint] IDENTITY(1,1) NOT NULL,
    [AccountId] [bigint] NOT NULL,
    [TransferredDateTime] [datetime] NOT NULL,
    [IsEncrypted] [bit] NOT NULL,
    [EncyptionType] [nvarchar](50) NOT NULL,
    [EncryptionKey] [varbinary](2048) NULL,
    [EncryptionIV] [varbinary](2048) NULL,
    [OriginalPath] [nvarchar](400) NOT NULL,
    [SourceMachine] [nvarchar](4000) NOT NULL,
    [RelativeLocation] [nvarchar](400) NOT NULL,
    [FileCreationTime] [datetime] NOT NULL,
    [DurationMs] [int] NOT NULL,
    [EncryptionDurationMs] [int] NOT NULL,
    [CopiedSuccessfully] [bit] NOT NULL,
    [UserId] [bigint] NULL,
    [CustomerId] [bigint] NULL,
    [NumberCalled] [nvarchar](50) NULL,
    [TelephonyCallId] [uniqueidentifier] NULL,
    [SolutionInstanceId] [bigint] NULL,
    [Filename] [nvarchar](240) NULL,
    [NonCompliantFilename] [nvarchar](240) NULL,
    [StorageLocationType] [int] NOT NULL,
    [DeletedStatus] [int] NOT NULL,
    [DeletedStatusTimestamp] [datetime] NULL,
    [FileSize] [int] NULL
)