Source

main / Source / WebClient / Web.DataLayer / Scripts / DocumentStore.sql

Naethra D 3ee1b94 


















Drop TABLE [dbo].[DocumentStore]
GO

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, 
    CONSTRAINT [FK_DocumentStore_User] FOREIGN KEY ([UserId]) REFERENCES [User]([Id]), 
    CONSTRAINT [PK_DocumentStore] PRIMARY KEY ([Id])
)
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.