Previous Topic: Prob_Category TableNext Topic: Property Table


Product Table

Reference table to denote the product that the complaint relates to.

Field

Data Type

Reference

Remarks

del

INTEGER

Active_Boolean_ Table::enum

Delete flag that indicates the following:
0—Active
1—Inactive/marked as deleted

id

INTEGER

 

Primary key of this table.

last_mod_by

byte(16)

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

INTEGER

 

Indicates the timestamp of when this record was last modified.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id).

sym

nvarchar(60)

 

Specifies the symbolic value for this Product.