Source

main / Source / WebClient / Database / dbo / tables / DocumentStore.sql

CREATE TABLE [dbo].[DocumentStore]
(
    [Id] INT IDENTITY(1,1) NOT NULL , 
    [Title] NVARCHAR(1000) NOT NULL, 
    [Description] NVARCHAR(MAX) NULL, 
    [Size] FLOAT NOT NULL, 
    [Status] NVARCHAR(200) NOT NULL, 
    [Metadata] NVARCHAR(MAX) NULL, 
    [Identifier] NVARCHAR(150) NULL, 
    [Citation] NVARCHAR(1000) NULL, 
    [UserId] INT NOT NULL, 
    [Filename] NVARCHAR(1000) NOT NULL, 
    [FileData] VARBINARY(MAX) NULL, 
    [FileId] NVARCHAR(200) NULL, 
    [UploadedDate] DATETIME NULL, 
    [MimeType] NVARCHAR(200) NULL, 
    CONSTRAINT [FK_DocumentStore_User] FOREIGN KEY ([UserId]) REFERENCES [User]([Id]), 
    CONSTRAINT [PK_DocumentStore] PRIMARY KEY ([Id])
)