Notetype

Columns

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

Primary key

PK Column Name
note_type_id

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Notes_system_custom_notetype_fk note_type_id Notes_system_custom note_type_id 1
Notes_system_notetype_fk note_type_id Notes_system note_type_id 1
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