create table if not exists file_object ( key varchar(64) not null primary key, mime_type varchar(64) not null, file_name varchar(64) not null, data bytea not null ); create table if not exists download ( key varchar(64) not null references file_object(key), ip_address varchar(32) not null, user_agent varchar(128) not null, time timestamp not null );