chrom_info (
chrom		VARCHAR(25),
start_pt	INTEGER,
stop_pt		INTEGER,
species		VARCHAR(25),
)

repeat_family_info ( 
family  	VARCHAR(50)  
)

repeat_class_info ( 
class   	VARCHAR(50) 
)

tfbind_info ( 
factor		VARCHAR(25), 
id		VARCHAR(20) 
)

genes ( 
id 		INTEGER,
symbol  	VARCHAR(50), 
official	VARCHAR(1), 
description	VARCHAR(200), 
type_of_gene	VARCHAR(55), 
chrom		VARCHAR(10), 
start_pt 	INTEGER, 
stop_pt		INTEGER, 
orientation 	VARCHAR(1), 
cds_start 	INTEGER, 
cds_stop 	INTEGER, 
function_summary VARCHAR(500), 
source		VARCHAR(10), 
num_of_exons	SMALLINT, 
evidence	VARCHAR(2) 
)

gene_dbIDs ( 
id      	INTEGER, 
db		VARCHAR(50), 
dbID		VARCHAR(50),
)

exons ( 
name		VARCHAR(20), 
chrom		VARCHAR(10), 
start_pt 	INTEGER, 
stop_pt 	INTEGER, 
gene_id		INTEGER,
orientation 	VARCHAR(1), 
)

conserved_regions ( 
local_id 	INTEGER, 
chrom    	VARCHAR(10), 
start_pt 	INTEGER, 
stop_pt  	INTEGER, 
min_perc_id 	SMALLINT, 
ave_percent_identity DECIMAL(5,2), 
num_of_segs 	SMALLINT, 
)

seq_file ( 
ID		VARCHAR(9),
seq_file	VARCHAR(500), 
start_pt	INTEGER, 
stop_pt		INTEGER, 
header		VARCHAR(500) 
)

local_alignments ( 
chrom  		VARCHAR(10), 
start_pt 	INTEGER, 
stop_pt 	INTEGER, 
score 		INTEGER, 
ID		INTEGER, 
orientation 	VARCHAR(30), 
species 	VARCHAR(50), 
start2		INTEGER, 
stop2		INTEGER, 
other_seq   	VARCHAR(9), 
)

gap_free_align ( 
local_id 	INTEGER, 
chrom  		VARCHAR(10), 
start_pt 	INTEGER , 
stop_pt 	INTEGER , 
percent_identity SMALLINT, 
orientation 	VARCHAR(30), 
species 	VARCHAR(50), 
start2  	INTEGER, 
stop2   	INTEGER, 
len   		GENERATED ALWAYS AS (stop_pt - start_pt + 1), 
pct_bin 	GENERATED ALWAYS AS (INTEGER(percent_identity / 10)), 
)

gene_alias ( 
gene_id 	INTEGER,
name		VARCHAR(100), 
source  	VARCHAR(50), 
)

gene_cdd ( 
gene_id		INTEGER,
name		VARCHAR(300), 
domain_acc	VARCHAR(50), 
)

gene_model_prots ( 
gene_id      	INTEGER,
protein		VARCHAR(50), 
acc_no		VARCHAR(50) 
)

gene_product ( 
gene_id		INTEGER,
name		VARCHAR(200) 
)

gene_ontology ( 
gene_id		INTEGER,
category	VARCHAR(100), 
term		VARCHAR(250), 
evidence_code 	VARCHAR(20), 
source		VARCHAR(50), 
goID		VARCHAR(50) 
)

go_defs_info ( 
term		VARCHAR(200), 
goID		VARCHAR(20), 
definition	VARCHAR(2000), 
comments	VARCHAR(1000) 
)

evid_code_info ( 
code		VARCHAR(20), 
description	VARCHAR(200) 
)

snps ( 
snp_id		INTEGER, 
dbsource	VARCHAR(10), 
chrom		VARCHAR(10), 
start_pt	INTEGER, 
stop_pt		INTEGER, 
)

snp_allele ( 
snp_id		INTEGER , 
allele		VARCHAR(700) , 
freq		DECIMAL(20,19), 
type_of		VARCHAR(50), 
)

repeats ( 
name		VARCHAR(50), 
class		VARCHAR(50), 
family		VARCHAR(50), 
strand		VARCHAR(1), 
chrom		VARCHAR(10), 
start_pt	INTEGER, 
stop_pt		INTEGER, 
milliDiv	SMALLINT, 
lineage		VARCHAR(30), 
)

gene_expr ( 
gene_id		INTEGER, 
tissue		VARCHAR(100), 
dbsource	VARCHAR(50) 
)

tfbinding_sites ( 
chrom           VARCHAR(10), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
strand          VARCHAR(1), 
score           DECIMAL(3,2), 
id              VARCHAR(20) 
)

conserved_binding_sites ( 
chrom           VARCHAR(10), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
strand          VARCHAR(5), 
score           DECIMAL(3,2), 
id              VARCHAR(20) 
)

recomb_rate ( 
chrom 	        VARCHAR(10), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
name		VARCHAR(20), 
recomb_rate	INTEGER, 
recomb_rateF	INTEGER, 
recomb_rateM	INTEGER, 
source		VARCHAR(20), 
)

CpGislands (  
chrom		VARCHAR(10), 
start_pt	INTEGER, 
stop_pt		INTEGER, 
name		VARCHAR(50), 
)

other_genes ( 
name		VARCHAR(255), 
chrom		VARCHAR(10), 
strand		VARCHAR(1), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
cds_start	INTEGER, 
cds_stop	INTEGER, 
exon_cnt	SMALLINT, 
id		INTEGER, 
track_name	VARCHAR(50) 
)

other_exons ( 
name		SMALLINT, 
chrom           VARCHAR(10), 
strand		VARCHAR(1), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
gene_id		INTEGER 
)

genename_search ( 
gene_id		INTEGER, 
names		VARCHAR(4000) 
)

regulatory_regions ( 
chrom           VARCHAR(10), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
name		VARCHAR(25) 
)

gc_percent ( 
chrom           VARCHAR(10), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
score           DECIMAL(4,1)   
)

multiple_aligns (  
chrom           VARCHAR(25),  
start_pt        INTEGER,  
stop_pt         INTEGER,  
strand		VARCHAR(1), 
align_id	INTEGER,  
local_id	INTEGER,  
species_build   VARCHAR(10),  
align_builds	VARCHAR(50),  
score		DECIMAL(12,5),  
score_bin	INTEGER GENERATED ALWAYS AS (INTEGER(score / 10000))  
)

mult_align_segments (  
chrom           VARCHAR(25), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
gap_size	SMALLINT, 
local_id        INTEGER
)

enzyme_info (
enzyme		VARCHAR(25),
pattern		VARCHAR(25)
)

restriction_sites (
chrom		VARCHAR(10),
start_pt	INTEGER,
stop_pt		INTEGER,
enzyme		VARCHAR(25)
)

parallel_aligns (
chrom           VARCHAR(10),
start_pt        INTEGER,
stop_pt         INTEGER,
align		VARCHAR(20),
repeat		VARCHAR(20)
)

regulatory_potential_mult (
chrom           VARCHAR(10),
start_pt        INTEGER,
stop_pt         INTEGER,
score		DECIMAL(25, 24),
score_bin	INTEGER GENERATED ALWAYS AS (INTEGER(score * 1000))
)