fanfic.sql

CREATE TABLE book_id (
	book_id INTEGER NOT NULL, 
	PRIMARY KEY (book_id)
);
CREATE TABLE chapter (
	scraped_at DATETIME NOT NULL, 
	book_id INTEGER NOT NULL, 
	chapter_number INTEGER NOT NULL, 
	chapter VARCHAR NOT NULL, 
	PRIMARY KEY (book_id, chapter_number), 
	FOREIGN KEY(book_id) REFERENCES book_id (book_id)
);
CREATE TABLE profile (
	book_id INTEGER NOT NULL, 
	title VARCHAR, 
	user_id INTEGER, 
	username VARCHAR, 
	summary VARCHAR, 
	rating VARCHAR, 
	language VARCHAR, 
	genres VARCHAR, 
	characters VARCHAR, 
	favorites INTEGER, 
	follows INTEGER, 
	published DATETIME, 
	updated DATETIME, 
	PRIMARY KEY (book_id), 
	FOREIGN KEY(book_id) REFERENCES book_id (book_id)
);
CREATE TABLE profile_html (
	scraped_at DATETIME NOT NULL, 
	book_id INTEGER NOT NULL, 
	html VARCHAR NOT NULL, 
	PRIMARY KEY (book_id), 
	FOREIGN KEY(book_id) REFERENCES book_id (book_id)
);
CREATE TABLE review (
	book_id INTEGER NOT NULL, 
	review_id INTEGER NOT NULL, 
	user_id INTEGER, 
	username VARCHAR, 
	chapter_number INTEGER, 
	review VARCHAR, 
	published DATETIME, 
	PRIMARY KEY (book_id, review_id), 
	FOREIGN KEY(book_id) REFERENCES book_id (book_id)
);
CREATE TABLE review_html (
	scraped_at DATETIME NOT NULL, 
	book_id INTEGER NOT NULL, 
	review_id INTEGER NOT NULL, 
	html VARCHAR NOT NULL, 
	PRIMARY KEY (book_id, review_id), 
	FOREIGN KEY(book_id) REFERENCES book_id (book_id)
);