This repository was archived by the owner on Dec 19, 2022. It is now read-only.
PostgreSQL Table Setup
We have the following tables set up at as of v0.5.0
There is a pattern with the table naming convention:
Given a virus name {name}, create 2 tables:
{name}_accessions and {name}_genomes
{name}_accessions has the following information:
accession VARCHAR(50) PRIMARY KEY UNIQUE,
completeness VARCHAR(10) NOT NULL,
nucleotideLength INTEGER,
releaseDate TIMESTAMP,
sourceDatabase VARCHAR(50),
updateDate TIMESTAMP
{name}_genomes has the following information:
accession VARCHAR(50),
genomic_sequence VARCHAR(230000),