OKTOB draft

CREATE TABLE users (
userID NUMBER(10) PRIMARY KEY,
username VARCHAR(10) NOT NULL,
email VARCHAR(20) NOT NULL,
bio VARCHAR(500),
password VARCHAR(10) NOT NULL
)

---------------------------
CREATE TABLE stories (
storyID NUMBER(10) PRIMARY KEY,
userID NUMBER(10) FOREIGN KEY REFERENCES users(userID),
genre VARCHAR(10),
rating VARCHAR(2) NOT NULL,
language VARCHAR(2) NOT NULL,
chapters INTEGER DEFAULT '0',
DESC VARCHAR(500),
status VARCHAR(10) DEFAULT 'WIP',
uploadDate TIMESTAMP NOT NULL,
WordCount INTEGER DEFAULT '0',
UpdateDate TIMESTAMP
)

----------------------------

CREATE TABLE collection (
collectionID NUMBER(10) PRIMARY KEY,
userID NUMBER(10) FOREIGN KEY REFERENCES users(userID),
name VARCHAR(20) NOT NULL,
createDate TIMESTAMP NOT NULL
)

----------------------------

CREATE TABLE collection_stories (
collectionID NUMBER(10) FOREIGN KEY REFERENCES collection(collectionID),
storyID NUMBER(10) FOREIGN KEY REFERENCES stories(storyID),
addDate TIMESTAMP NOT NULL
)

-------------------------
CREATE TABLE user_followers (
followID NUMBER(10) PRIMARY KEY,
userID NUMBER(10) FOREIGN KEY REFERENCES users(userID),
followerID NUMBER(10) FOREIGN KEY REFERENCES users(userID),
followDate TIMESTAMP NOT NULL,
status CHAR(1) DEFAULT 'Y'
)

-------------------
CREATE TABLE user_following_stories (
followID NUMBER(10) PRIMARY KEY,
userID NUMBER(10) FOREIGN KEY REFERENCES users(userID),
storyID NUMBER(10) FOREIGN KEY REFERENCES stories(storyID),
followDate TIMESTAMP NOT NULL,
status CHAR(1) DEFAULT 'Y'
)

-----------------
//TODO: chapter, story_chapter_comments, likes