TABLES
114
VIEWS
1
COLUMNS
726
Constraints
144
Anomalies
31
Routines
47
Database Properties
Database Type: PostgreSQL - 11.22 (Debian 11.22-0+deb10u2)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| accession | 16 | 3 | 6 | 0 | Table | |
| accession_names | 1 | 1 | 3 | 0 | Table | |
| annotation_target_type | 1 | 0 | 5 | 0 | Table | |
| authors | 0 | 0 | 3 | 0 | Table | |
| blast_annotations | 1 | 3 | 9 | 0 | Table | |
| blast_db | 4 | 1 | 13 | 1 | Table | This table holds metadata about the BLAST databases that we keep in stock. |
| blast_db_blast_db_group | 0 | 2 | 3 | 1 | Table | |
| blast_db_group | 2 | 0 | 3 | 1 | Table | |
| blast_db_organism | 0 | 2 | 3 | 0 | Table | |
| blast_defline | 1 | 1 | 6 | 0 | Table | |
| blast_hits | 0 | 2 | 9 | 0 | Table | |
| blast_targets | 2 | 0 | 5 | 0 | Table | |
| cds | 3 | 2 | 15 | 0 | Table | |
| chadoprop | 0 | 1 | 4 | 0 | Table | This table is different from other prop tables in the database, as it is for storing information about the database itself, like schema version |
| clone | 2 | 2 | 4 | 0 | Table | |
| cloning_vector | 1 | 0 | 3 | 0 | Table | |
| common_name | 5 | 0 | 2 | 1 | Table | |
| common_nameprop | 0 | 2 | 5 | 0 | Table | |
| cos_markers | 0 | 1 | 16 | 0 | Table | |
| cosii_ortholog | 0 | 4 | 9 | 0 | Table | |
| deprecated_linkage_groups | 1 | 1 | 4 | 0 | Table | |
| deprecated_map_cross | 0 | 2 | 3 | 0 | Table | |
| deprecated_mapdata | 1 | 2 | 6 | 0 | Table | |
| deprecated_maps | 5 | 0 | 15 | 0 | Table | |
| deprecated_marker_confidences | 2 | 0 | 3 | 0 | Table | |
| deprecated_marker_locations | 0 | 3 | 7 | 0 | Table | |
| deprecated_marker_types | 1 | 0 | 4 | 0 | Table | |
| deprecated_markers | 4 | 1 | 3 | 0 | Table | |
| derived_from_source | 1 | 0 | 5 | 0 | Table | |
| domain | 1 | 3 | 8 | 0 | Table | |
| domain_match | 0 | 3 | 10 | 0 | Table | |
| enzyme_restriction_sites | 0 | 1 | 3 | 0 | Table | |
| enzymes | 4 | 0 | 2 | 0 | Table | |
| est | 4 | 1 | 12 | 0 | Table | |
| est_dbxref | 0 | 2 | 3 | 0 | Table | |
| ests_mapped_by_clone | 0 | 2 | 3 | 0 | Table | |
| experiment_type | 1 | 0 | 3 | 1 | Table | |
| facility | 1 | 2 | 14 | 0 | Table | |
| family | 2 | 1 | 9 | 0 | Table | |
| family_build | 1 | 0 | 6 | 0 | Table | |
| family_member | 0 | 2 | 7 | 0 | Table | |
| family_tree | 0 | 1 | 5 | 0 | Table | |
| fish_chromatin_density_constants | 2 | 0 | 2 | 0 | Table | |
| fish_experimenter | 2 | 0 | 2 | 0 | Table | |
| fish_file | 0 | 0 | 3 | 0 | Table | |
| fish_image | 0 | 0 | 3 | 0 | Table | |
| fish_karyotype_constants | 0 | 0 | 6 | 0 | Table | |
| fish_karyotype_constants_old | 2 | 0 | 9 | 0 | Table | |
| fish_result | 1 | 6 | 10 | 0 | Table | |
| fish_result_composite | 0 | 3 | 16 | 0 | Table |