tbl_physical_sample_features

7968 rows


Description

This table establishes a many-to-many relationship between samples and specific features, allowing a feature to be related to multiple samples and a sample to be linked to multiple features. This supports scenarios where samples originate from nested feature groups or features with multiple identifiers.

Columns

Column Type Size Nulls Auto Children Parents Comments
physical_sample_feature_id int4 10 √

Primary key (automatically incremented).
date_updated timestamptz 35,6 √
feature_id int4 10
tbl_features.feature_id fk_physical_sample_features_feature_id C

Specifies the unique identifier of a feature.
physical_sample_id int4 10
tbl_physical_samples.physical_sample_id fk_physical_sample_features_physical_sample_id C

Identifies the specific physical sample.

Indexes

Constraint Name Type Sort Column(s)
tbl_physical_sample_features_pkey Primary key Asc physical_sample_feature_id
idx_physical_sample_features_feature_id Performance Asc feature_id
idx_physical_sample_features_physical_sample_id Performance Asc physical_sample_id
idx_tbl_physical_sample_features_feature_id Performance Asc feature_id

Relationships

Close relationships within degrees of separation