# ar

## Description

<details>
<summary><strong>Table Definition</strong></summary>

```sql
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
)
```

</details>

## 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

![er](ar.svg)

---

> Generated by [tbls](https://github.com/k1LoW/tbls)