Invoices_Comments
The table below describes the Invoices_Comments table in the Minimal database schema.
This is a virtual table, and is linked to the Invoices table in the Minimal database schema (see Invoices).
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 Invoices 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_BIT | True |
|
Comments_Is_Visible_On_Front |
SQL_BIT | True |
|
Comments_Parent_Id |
SQL_INTEGER(unsigned) | True |