Shipment_Comments

The table below describes the Shipment_Comments table in the Minimal database schema.

This is a virtual table, and is linked to the Shipment table in the Minimal database schema (see Shipment).

None of the columns in this table are updatable.

This table contains the following foldable column:

  • Entity_Id

This table does not contain Return Primary Key columns.

Column Name SQL Type Nullable

Comments_Index

Primary Key
SQL_INTEGER(unsigned) True

Entity_Id

Primary Key
Foreign Key linked to column Entity_Id in Shipment table
SQL_INTEGER(unsigned) False

Comments_Comment

SQL_VARCHAR(255) True

Comments_Created_At

SQL_TIMESTAMP True

Comments_Entity_Id

SQL_INTEGER(unsigned) True

Comments_Is_Customer_Notified

SQL_INTEGER(signed) True

Comments_Is_Visible_On_Front

SQL_INTEGER(signed) True

Comments_Parent_Id

SQL_INTEGER(unsigned) True