This table holds the SEO page definition for a
particular pageName at a site/store level
Column Descriptions:
| Name | Type | Description |
| SEOPAGEDEF_ID | BIGINT NOT NULL | Generated unique key for the SEO page
definition. |
| PAGENAME | VARCHAR (64) NOT NULL | The name of the page for which the page
definition is stored. |
| STOREENT_ID | INTEGER NOT NULL | The reference number of the store entity to which
the page belongs. |
| LASTUPDATE | TIMESTAMP NOT NULL | The last time the page definition was
updated. |
| CREATEDTIME | TIMESTAMP NOT NULL | The time the page definition is created. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | SEOPAGEDEF_ID | Primary Key |
| I0001409 | PAGENAME+STOREENT_ID | Unique Index |
| I0001410 | STOREENT_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3697 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_3698 | SEOPAGEDEF_ID | SEOPAGEDEFDESC | SEOPAGEDEF_ID | Cascade |
| F_3700 | SEOPAGEDEF_ID | SEOPAGEDEFOVR | SEOPAGEDEF_ID | Cascade |