catissue_consent_tier

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_consent_tier_response.CONSENT_TIER_ID FKFB1995FD17B9953R
catissue_consent_tier_status.CONSENT_TIER_ID FKF74E94AE17B9953R
COLL_PROTOCOL_ID BIGINT 19 √ null
catissue_collection_protocol.IDENTIFIER FK51725303E36A4B4FR
ACTIVITY_STATUS VARCHAR 16 Active
CONSENT_STMT_ID BIGINT 19 √ null
os_consent_statements.IDENTIFIER FK_CP_CONSENT_TIERS_CONSENT_IDR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK51725303E36A4B4F Performance Asc COLL_PROTOCOL_ID
FK_CP_CONSENT_TIERS_CONSENT_ID Performance Asc CONSENT_STMT_ID

Relationships

Close relationships within degrees of separation