sct2_identifier

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
identifierSchemeId	BIGINT	19			null

|

| | | alternateIdentifier | BIGINT | 19 | | | null |

|

| | | effectiveTime | DATE | 10 | | | null |

|

| | | active | INT | 10 | | | null |

|

| | | moduleId | BIGINT | 19 | | | null |

|

| | | referencedComponentId | BIGINT | 19 | | | null |

|

| |

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	identifierSchemeId

Relationships

Close relationships within degrees of separation