[Home] [Help] [Dependency Information]
Object Name: | CSF_MD_POIS_WM |
---|---|
Object Type: | TABLE |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
DEFINITION
This table defines POI (point of interest) for Map Display
EXAMPLE
Holiday Inn, Shell petrol station, etc.
MISCELLANEOUS
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000493320C00017$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000493320C00018$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POI_ID | NUMBER | (30) | Yes | A unique identifier for the POI. |
FEATURE_CODE | NUMBER | Yes | The FEATURE CODE defines the type the POI. | |
FOOD_TYPE | VARCHAR2 | (240) | The FOOD TYPE defines the type of food served in restaurants. | |
IMPORTANCE | VARCHAR2 | (3) | Yes | The IMPORTANCE defines if the POI if of local or national importance. |
POI_ADDRESS | VARCHAR2 | (240) | The POI ADDESS defines the streetname and house number of the POI. | |
TELEPHONE_NUMBER | VARCHAR2 | (240) | The POI telephone number | |
POPULATION | NUMBER | (25) | The POPULATION defines the estimated number of inhabitans of the city. | |
CHAIN_NAME | VARCHAR2 | (240) | The CHAIN NAME defines the name of the chain to which the POI belongs to. | |
INST_STYLE_ID | NUMBER | (30) | Yes | Generic unique identifier for an entity |
SECURITY_GROUP_ID | NUMBER | Identifier used for running in hosted mode. | ||
GEOMETRY | SDO_GEOMETRY | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT POI_ID
, FEATURE_CODE
, FOOD_TYPE
, IMPORTANCE
, POI_ADDRESS
, TELEPHONE_NUMBER
, POPULATION
, CHAIN_NAME
, INST_STYLE_ID
, SECURITY_GROUP_ID
, GEOMETRY
FROM CSF.CSF_MD_POIS_WM;
|
|
|