User notes dimension table
bi_dimusernotes
Field | Description | Field Type | Primary Key |
|---|---|---|---|
alert | boolean | ||
centerid | varchar ( 36 ) | ||
createdate | timestamp without time zone | ||
createdby | varchar ( 512 ) | ||
entity | bigint | ||
etllastupdatedby | varchar ( 50 ) | ||
etllastupdatedon | timestamp without time zone | ||
isprivate | boolean | ||
note | varchar ( 65535 ) | ||
noteid | varchar ( 36 ) | ||
notetype | varchar ( 2048 ) | ||
objectid | varchar ( 36 ) | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
privacytype | varchar ( 2048 ) | ||
source | varchar ( 128 ) | ||
updatedby | varchar ( 512 ) | ||
updatedon | timestamp without time zone | ||
userid | varchar ( 36 ) | ||
usernoteswid | bigint | ||
void | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |