visual_db.txt

CREATE TABLE manifest (
	id INTEGER NOT NULL, 
	filename VARCHAR(30) NOT NULL, 
	content_md5sum VARCHAR(35) NOT NULL, 
	md5sum VARCHAR(35) NOT NULL, 
	first_item VARCHAR(20) NOT NULL, 
	last_item VARCHAR(20) NOT NULL, 
	num_items INTEGER NOT NULL, 
	seq_num INTEGER NOT NULL, 
	size BIGINT NOT NULL, 
	timestamp VARCHAR(25) NOT NULL, 
	yymm VARCHAR(10) NOT NULL, 
	PRIMARY KEY (id)
);
CREATE TABLE articles (
	pk INTEGER NOT NULL, 
	tarfile_id INTEGER NOT NULL, 
	id VARCHAR(50) NOT NULL, 
	guidislink BOOLEAN, 
	updated_parsed DATETIME, 
	published_parsed DATETIME, 
	title VARCHAR(300) NOT NULL, 
	summary VARCHAR(5000) NOT NULL, 
	authors VARCHAR(1000) NOT NULL, 
	author_detail VARCHAR(50) NOT NULL, 
	author VARCHAR(50) NOT NULL, 
	arxiv_comment VARCHAR(100), 
	tags VARCHAR(500) NOT NULL, 
	arxiv_url VARCHAR(1000) NOT NULL, 
	doi VARCHAR(120), 
	PRIMARY KEY (pk), 
	FOREIGN KEY(tarfile_id) REFERENCES manifest (id), 
	CHECK (guidislink IN (0, 1))
);