| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| date_last_modified | TIMESTAMP | Date last modified (GMT) | |||||
| description | VARCHAR2 | 75 | Description | ||||
| is_inactive | VARCHAR2 | 1 | Is inactive | ||||
| note_type | VARCHAR2 | 40 | Note type | ||||
| note_type_extid | VARCHAR2 | 255 | Note type external ID | ||||
| note_type_id | NUMBER | 39 | 0 | Note type ID |
| PK Column Name |
|---|
| note_type_id |
| FK Name | PK Column Name | FK Table Name | FK Column Name | Key Seq |
|---|---|---|---|---|
| Notes_user_notetype_fk | note_type_id | Notes_user | note_type_id | 1 |
| System_notes_custom_notetype_fk | note_type_id | System_notes_custom | note_type_id | 1 |
| System_notes_notetype_fk | note_type_id | System_notes | note_type_id | 1 |