CREATE SEQUENCE assembly_pkey_seq;

CREATE TABLE assembly (
        assembly_id                integer PRIMARY KEY default (nextval('assembly_pkey_seq')),
	bioentry_id	           int NOT NULL REFERENCES bioentry,
	length		           int NOT NULL,
	molecule	           varchar(10)
) ;


CREATE SEQUENCE assembly_fragment_pkey_seq;

CREATE TABLE assembly_fragment (
        assembly_fragment_id       integer PRIMARY KEY default (nextval('assembly_fragment_pkey_seq')),
	assembly_id		   int NOT NULL REFERENCES assembly,
	fragment_name		   varchar(40) NOT NULL,
	assembly_start		   int NOT NULL,
	assembly_end		   int NOT NULL,
	fragment_start		   int NOT NULL,
	fragment_end		   int NOT NULL,
	strand			   int
) ;