POIDESC

Contains Point of Interest (POI) record descriptions.

Column Descriptions:

NameTypeDescription
POIDESC_IDBIGINT NOT NULLPrimary key of the POI description.
POINTOFINTEREST_IDBIGINT NOT NULLPrimary key of the POI.
LANGUAGE_IDINTEGER NOT NULLPrimary key of the language.
NAMEVARCHAR (256)Translated name of the POI.
SHORTDESCRIPTIONVARCHAR (1024)Translated short description of the POI.
LONGDESCRIPTIONVARCHAR (4000)Translated long description of the POI.
DISPLAYIMAGE1VARCHAR (1024)URL of the POI's display image.
DISPLAYIMAGE2VARCHAR (1024)URL of the POI's display image.
FIELD1BIGINTCustomizable field.
FIELD2DECIMAL (20,5)Customizable field.
FIELD3VARCHAR (256)Customizable field.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>POIDESC_IDPrimary Key
I0001437POINTOFINTEREST_ID+LANGUAGE_IDUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3713POINTOFINTEREST_IDPOINTOFINTERESTPOINTOFINTEREST_IDCascade