Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Release (
- id INT PRIMARY KEY IDENTITY,
- categoryName VARCHAR(100) ,
- ownerId INT ,
- releaseName VARCHAR(200) ,
- releaseDescription VARCHAR(2000),
- imgLocation VARCHAR(200) ,
- releaseDate DateTime ,
- creationDate DateTime DEFAULT GETDATE()
- followerCount int DEFAULT 0
- );
- CREATE TABLE Category (
- categoryName VARCHAR(100) PRIMARY KEY,
- imgLocation VARCHAR(200)
- );
- CREATE TABLE Comment(
- id INT PRIMARY KEY IDENTITY,
- releaseId INT ,
- userId INT ,
- postDate DateTime ,
- replyId INT,
- commentText VARCHAR(1000)
- );
- CREATE TABLE releaseUser(
- id INT PRIMARY KEY IDENTITY,
- username VARCHAR(20) ,
- passHash VARCHAR(200) ,
- imgLocation VARCHAR(200),
- accountCreationDate DateTime DEFAULT GETDATE()
- );
- CREATE TABLE User_Release(
- userId INT ,
- releaseId INT
- );
Advertisement
Add Comment
Please, Sign In to add comment