Contains Point of Interest (POI) record
descriptions.
Column Descriptions:
Name | Type | Description |
POIDESC_ID | BIGINT NOT NULL | Primary key of the POI description. |
POINTOFINTEREST_ID | BIGINT NOT NULL | Primary key of the POI. |
LANGUAGE_ID | INTEGER NOT NULL | Primary key of the language. |
NAME | VARCHAR (256) | Translated name of the POI. |
SHORTDESCRIPTION | VARCHAR (1024) | Translated short description of the POI. |
LONGDESCRIPTION | VARCHAR (4000) | Translated long description of the POI. |
DISPLAYIMAGE1 | VARCHAR (1024) | URL of the POI's display image. |
DISPLAYIMAGE2 | VARCHAR (1024) | URL of the POI's display image. |
FIELD1 | BIGINT | Customizable field. |
FIELD2 | DECIMAL (20,5) | Customizable field. |
FIELD3 | VARCHAR (256) | Customizable field. |
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> | POIDESC_ID | Primary Key |
I0001437 | POINTOFINTEREST_ID+LANGUAGE_ID | Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_3713 | POINTOFINTEREST_ID | POINTOFINTEREST | POINTOFINTEREST_ID | Cascade |