ar.md

ar

Description

Table Definition

CREATE TABLE ar (
    tax_id             INTEGER,
    organism_name      VARCHAR (255),
    bioproject         VARCHAR (50),
    biosample          VARCHAR (50),
    assembly_accession VARCHAR (50),
    refseq_category    VARCHAR (50),
    assembly_level     VARCHAR (50),
    genome_rep         VARCHAR (50),
    seq_rel_date       DATE,
    asm_name           VARCHAR (255),
    ftp_path           VARCHAR (255),
    family             VARCHAR (50),
    family_id          INTEGER,
    genus              VARCHAR (50),
    genus_id           INTEGER,
    species            VARCHAR (50),
    species_id         INTEGER
)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
tax_id	INTEGER		true
organism_name	VARCHAR (255)		true
bioproject	VARCHAR (50)		true
biosample	VARCHAR (50)		true
assembly_accession	VARCHAR (50)		true
refseq_category	VARCHAR (50)		true
assembly_level	VARCHAR (50)		true
genome_rep	VARCHAR (50)		true
seq_rel_date	DATE		true
asm_name	VARCHAR (255)		true
ftp_path	VARCHAR (255)		true
family	VARCHAR (50)		true
family_id	INTEGER		true
genus	VARCHAR (50)		true
genus_id	INTEGER		true
species	VARCHAR (50)		true
species_id	INTEGER		true

Indexes

Name	Definition
idx_ar_species_id	CREATE INDEX idx_ar_species_id ON ar(species_id)
idx_ar_species	CREATE INDEX idx_ar_species ON ar(species)
idx_ar_genus_id	CREATE INDEX idx_ar_genus_id ON ar(genus_id)
idx_ar_genus	CREATE INDEX idx_ar_genus ON ar(genus)
idx_ar_family_id	CREATE INDEX idx_ar_family_id ON ar(family_id)
idx_ar_family	CREATE INDEX idx_ar_family ON ar(family)
idx_ar_tax_id	CREATE INDEX idx_ar_tax_id ON ar(tax_id)

Relations

---

Generated by tbls