add intron/exon schema and mrna cds loader

[dbsnp.git] / schema / extra_schema / intron_exon_schema.sql

diff --git a/schema/extra_schema/intron_exon_schema.sql b/schema/extra_schema/intron_exon_schema.sql
new file mode 100644 (file)
index 0000000..e1aed7f
--- /dev/null
+++ b/schema/extra_schema/intron_exon_schema.sql
@@ -0,0 +1,56 @@
+CREATE TABLE contigs (
+       tax_id int NOT NULL,
+       chr VARCHAR(127) NOT NULL,
+       chr_start INT NOT NULL,
+       chr_stop INT NOT NULL,
+       orientation VARCHAR(1) NOT NULL DEFAULT '+',
+       feature_name VARCHAR(127) NOT NULL,
+       gi INT,
+       feature_type VARCHAR(127) NOT NULL
+);
+
+CREATE TABLE exons (
+       gi int NOT NULL,
+       accession VARCHAR(127) NOT NULL,
+       accession_ver INT NOT NULL,
+       number INT NOT NULL,
+       start INT NOT NULL,
+       stop INT NOT NULL       
+       );
+
+CREATE TABLE cds (
+       gi int NOT NULL,
+       accession VARCHAR(127) NOT NULL,
+       accession_ver INT NOT NULL,
+       variant VARCHAR(127),
+       complement BOOLEAN DEFAULT FALSE,
+       gene VARCHAR (127),
+       geneid INT NOT NULL,
+       contig_gi INT NOT NULL,
+       chr VARCHAR (127),
+       number INT NOT NULL,
+       phase INT NOT NULL,
+       start INT NOT NULL,
+       stop INT NOT NULL,
+       contig_start INT NOT NULL,      
+       contig_stop INT NOT NULL,
+       position INT NOT NULL);
+
+CREATE TABLE mrna (
+       gi int NOT NULL,
+       accession VARCHAR(127) NOT NULL,
+       accession_ver INT NOT NULL,
+       variant INT,
+       complement BOOLEAN DEFAULT FALSE,
+       gene VARCHAR (127),
+       geneid INT NOT NULL,
+       contig_gi INT NOT NULL,
+       chr VARCHAR (127),
+       exon BOOLEAN DEFAULT TRUE,
+       number INT NOT NULL,
+       start INT NOT NULL,
+       stop INT NOT NULL,
+       contig_start INT NOT NULL,      
+       contig_stop INT NOT NULL);
+
+