readinglist.sql

PRAGMA foreign_keys=ON;

CREATE TABLE user (
	   user_id INTEGER PRIMARY KEY,
	   user_name VARCHAR (255)
);

CREATE TABLE paper (
	   paper_id INTEGER PRIMARY KEY,
	   paper_source VARCHAR (255),
	   paper_handle VARCHAR(255),
	   paper_metadata TEXT,
	   paper_summary TEXT
);

CREATE TABLE user_to_paper (
	   user_id INTEGER,
	   paper_id INTEGER,
	   FOREIGN KEY (user_id)  REFERENCES user  (user_id),
	   FOREIGN KEY (paper_id) REFERENCES paper (paper_id),
	   UNIQUE (user_id, paper_id) ON CONFLICT IGNORE
);