SchemaSpy - Table zfindb.public.feature

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

feature_zdb_id

text

2147483647

amsterdam_file.af_feature_zdb_id	af_feature_zdb_id_fk C
feature_assay.featassay_feature_zdb_id	featassay_feature_zdb_id_fk C
feature_audit.feature_zdb_id	Implied Constraint R
feature_community_contribution.fcc_feature_zdb_id	fcc_feature_zdb_id_foreign_key C
feature_dna_mutation_detail.fdmd_feature_zdb_id	fdmd_feature_zdb_id_foreign_key R
feature_genomic_mutation_detail.fgmd_feature_zdb_id	fgmd_feature_fk_odc C
feature_history.fhist_ftr_zdb_id	fhist_ftr_zdb_id_foreign_key_odc C
feature_marker_relationship.fmrel_ftr_zdb_id	fmrel_ftr_zdb_id_foreign_key C
feature_protein_mutation_detail.fpmd_feature_zdb_id	fpmd_feature_zdb_id_fk_constraint R
feature_transcript_mutation_detail.ftmd_feature_zdb_id	ftmd_feature_zdb_id_fk_odc C
genotype_feature.genofeat_feature_zdb_id	genofeat_feature_foreign_key_odc C
one_to_one_accession.ooa_feature_zdb_id	ooa_feature_zdb_id_foreign_key R

zdb_active_data.zactvd_zdb_id

feature_zactvd_zdb_id_foreign_key_odc C

feature_name

text

2147483647

feature_abbrev

text

2147483647

feature_type

text

2147483647

feature_type.ftrtype_name

feature_type_foreign_key R

feature_name_order

text

2147483647

feature_abbrev_order

text

2147483647

feature_date_entered

timestamp

29,6

√

now()

feature_lab_prefix_id

int8

19

√

null

feature_prefix.fp_pk_id

feature_lab_prefix_id_foreign_key C

feature_line_number

text

2147483647

√

null

feature_df_transloc_complex_prefix

text

2147483647

√

null

feature_dominant

bool

1

false

feature_unspecified

bool

1

false

feature_unrecovered

bool

1

false

feature_known_insertion_site

bool

1

false

feature_tg_suffix

text

2147483647

√

null

ftr_chr_info_date

timestamp

29,6

√

null

Table contained 72,073 rows at Wed Sep 15 00:41 PDT 2021

Indexes:

Column(s)	Type	Sort	Constraint Name
feature_zdb_id	Primary key	Asc	feature_primary_key
feature_abbrev	Must be unique	Asc	feature_abbrev_alternate_key
feature_lab_prefix_id	Performance	Asc	feature_lab_feature_prefix_fk_index
feature_name	Must be unique	Asc	feature_name_index
feature_type	Performance	Asc	feature_type_foreign_key_index