POIDESC

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