| Assay_document_ID |
| Base Entity | Assay_document |
| Attribute Name | Assay_document_ID |
| Logical Rolename | |
| ColumnName | Assay_document_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Assay_document_ID Logical Attribute Properties |
| Logical Attribute Name | Assay_document_ID |
| Datatype | BIGINT |
| Nullable | NO |
| Assay_document_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Assay_document_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Assay_document Assay_document_ID |
NO | ||
| BARD_Dev (Oracle) ASSAY_DOCUMENT Assay_document_ID |
NO |
| Assay_ID |
| Base Entity | Assay_document |
| Attribute Name | Assay_ID |
| Logical Rolename | |
| ColumnName | Assay_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Assay_ID Logical Attribute Properties |
| Logical Attribute Name | Assay_ID |
| Datatype | BIGINT |
| Nullable | NO |
| Assay_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Assay_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Assay_document Assay_ID |
NO | ||
| BARD_Dev (Oracle) ASSAY_DOCUMENT ASSAY_ID |
NO |
| Document_Name |
| Base Entity | Assay_document |
| Attribute Name | Document_Name |
| Logical Rolename | |
| ColumnName | Document_Name |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Document_Name Logical Attribute Properties |
| Logical Attribute Name | Document_Name |
| Datatype | VARCHAR(500) |
| Nullable | NO |
| Document_Name Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Document_Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Assay_document Document_Name |
NO | ||
| BARD_Dev (Oracle) ASSAY_DOCUMENT Document_Name |
NO |
| Document_Type |
| Base Entity | Assay_document |
| Attribute Name | Document_Type |
| Logical Rolename | |
| ColumnName | Document_Type |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Document_Type Logical Attribute Properties |
| Logical Attribute Name | Document_Type |
| Datatype | VARCHAR(20) |
| Nullable | NO |
| Document_Type Domain Restrictions |
| CheckConstraint | Document_Type IN ('Description', 'Protocol', 'Comments', 'Publication', 'External URL', 'Other') | ||
| Check Constraint Name | ck_assay_document_type | ||
| Bound Rule | |||
| Declared Default | 'Description' | ||
| Bound Default |
| Document_Type Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Assay_document Document_Type |
NO | ||
| BARD_Dev (Oracle) ASSAY_DOCUMENT DOCUMENT_TYPE |
NO |
| Document_Content |
| Base Entity | Assay_document |
| Attribute Name | Document_Content |
| Logical Rolename | |
| ColumnName | Document_Content |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Document_Content Logical Attribute Properties |
| Logical Attribute Name | Document_Content |
| Datatype | TEXT |
| Nullable | YES |
| Document_Content Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | EMPTY_CLOB() | ||
| Bound Default |
| Document_Content Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Assay_document Document_Content |
NO | ||
| BARD_Dev (Oracle) ASSAY_DOCUMENT DOCUMENT_CONTENT |
NO |
| Version |
| Base Entity | Assay_document |
| Attribute Name | Version |
| Logical Rolename | |
| ColumnName | Version |
| RoleName | |
| Domain | Version |
| Logical Only | NO |
| Definition | |
| Note |
| Version Logical Attribute Properties |
| Logical Attribute Name | Version |
| Datatype | INTEGER |
| Nullable | NO |
| Version Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 0 |
| Bound Default |
| Version Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Assay_document Version |
NO | ||
| BARD_Dev (Oracle) ASSAY_DOCUMENT VERSION |
NO |
| Date_Created |
| Base Entity | Assay_document |
| Attribute Name | Date_Created |
| Logical Rolename | |
| ColumnName | Date_Created |
| RoleName | |
| Domain | Date_Created |
| Logical Only | NO |
| Definition | |
| Note |
| Date_Created Logical Attribute Properties |
| Logical Attribute Name | Date_Created |
| Datatype | TIMESTAMP/DATE |
| Nullable | NO |
| Date_Created Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Date_Created Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Assay_document Date_Created |
NO | ||
| BARD_Dev (Oracle) ASSAY_DOCUMENT Date_Created |
NO |
| Last_Updated |
| Base Entity | Assay_document |
| Attribute Name | Last_Updated |
| Logical Rolename | |
| ColumnName | Last_Updated |
| RoleName | |
| Domain | Last_Updated |
| Logical Only | NO |
| Definition | |
| Note |
| Last_Updated Logical Attribute Properties |
| Logical Attribute Name | Last_Updated |
| Datatype | DATETIME |
| Nullable | NO |
| Last_Updated Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | SYSDATE |
| Bound Default |
| Last_Updated Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Assay_document Last_Updated |
NO | ||
| BARD_Dev (Oracle) ASSAY_DOCUMENT Last_Updated |
NO |
| Modified_by |
| Base Entity | Assay_document |
| Attribute Name | Modified_by |
| Logical Rolename | |
| ColumnName | Modified_by |
| RoleName | |
| Domain | Modified_by |
| Logical Only | NO |
| Definition | |
| Note |
| Modified_by Logical Attribute Properties |
| Logical Attribute Name | Modified_by |
| Datatype | VARCHAR(40) |
| Nullable | YES |
| Modified_by Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Modified_by Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Assay_document Modified_by |
NO | ||
| BARD_Dev (Oracle) ASSAY_DOCUMENT MODIFIED_BY |
NO |