Current database structure

cursor.execute(‘CREATE TABLE articles (id INTEGER PRIMARY KEY, title VARCHAR(50) UNIQUE, content VARCHAR(1000), date DATE, source_id INTEGER, phrase_id VARCHAR(100))’)
cursor.execute(‘CREATE TABLE sources (id INTEGER PRIMARY KEY, title VARCHAR(50), url VARCHAR(100), weight INTEGER)’)
cursor.execute(‘CREATE TABLE phrases (id INTEGER PRIMARY KEY, phrase TEXT UNIQUE, pos VARCHAR(5), rating varchar(100), count INTEGER, words varchar(50))’)
cursor.execute(‘CREATE TABLE score (date DATE PRIMARY KEY, score INTEGER)’)
cursor.execute(‘CREATE TABLE words (id INTEGER PRIMARY KEY, wordtagged TEXT UNIQUE, word TEXT, pos VARCHAR(5), count INTEGER, q1 TEXT, q2 TEXT, q3 TEXT, q4 TEXT, q5 TEXT, q6 TEXT, q7 TEXT, q8 TEXT)’)