PROPOSAL_ITEM_VERSIONSERIAL_0
Description
This table stores serialized data for the versions of item proposals.
Columns
| Column Name | Data Type | Description |
| ID | bigint | The unique identifier for the version serialized. |
| ATTRIBUTES | longtext | The serialized attributes of the version. |
| ITEM_ID | varchar | The identifier of the item associated with the version. |
| NAME | varchar | The name of the version. |
| FIXED_ITEMS_PROPOSAL_VERSION0 | bigint | The foreign key referencing the ID of the proposal version for fixed items. |
| FIXED_ITEMS_HJORDER | int | The order of the fixed items. |
| ADDITIONAL_ITEMS_PROPOSAL_VE_0 | bigint | The foreign key referencing the ID of the proposal version for additional items. |
| ADDITIONAL_ITEMS_HJORDER | int | The order of the additional items. |
Foreign Key Relationships
- This table has a foreign key relationship with PROPOSAL_VERSION(ID) for fixed items.
- This table has a foreign key relationship with PROPOSAL_VERSION(ID) for additional items.