create table users (id integer autoincrement primary key, username varchar(32), password_hash varbinary(32)); create table questions (id integer autoincrement primary key, user integer references users(id), title varchar(256), body bigtext); create table answers (id integer autoincrement primary key, question integer references questions(id), user integer references users(id), body bigtext);
but actually that's just a tiny fraction of actually making Stack Overflow.
create table users (id integer autoincrement primary key, username varchar(32), password_hash varbinary(32)); create table questions (id integer autoincrement primary key, user integer references users(id), title varchar(256), body bigtext); create table answers (id integer autoincrement primary key, question integer references questions(id), user integer references users(id), body bigtext);
but actually that's just a tiny fraction of actually making Stack Overflow.