Database Table: ORCOMMENT

Each row in this table represents a comment associated to an Order in a Store.

Column Name Column Type Column Description
COMMENTS VARCHAR (1024)
NULL
The content of the comment.
LASTUPDATE TIMESTAMP
NULL
The time this comment is created.
ORCOMMENT_ID BIGINT
NOT NULL
Generated unique key.
ORDERS_ID BIGINT
NOT NULL
The Order.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035013890 ORCOMMENT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_483 ORDERS_ID ORDERS ORDERS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable