1. Tables and Views
  2. PSC_COM_MAP_PROFILE

PSC_COM_MAP_PROFILE

The PSC_COM_MAP_PROFILE table stores the map profiles

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_COM_MAP_PROFILE_PK

AGENCY_ID, MAP_PROFILE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
AGENCY_ID NUMBER 8 Yes Agency Identifier. This is the first field of composite primary key Active
MAP_PROFILE_ID VARCHAR2 30 Yes Map Profile Identifier. This is the second field of composite primary key Active
IS_DEFAULT VARCHAR2 1 Yes To indicate whether the map profile is the default map profile Active
BASEMAP VARCHAR2 30 Yes To specify a basemap for the map Active
BASEMAPGALLERY_ENABLED VARCHAR2 1 Yes To indicate whether the user is allowed change the basemap Active
INIT_EXTENT_XMIN NUMBER Yes The top-left X-coordinate of the initial extent envelope Active
INIT_EXTENT_YMIN NUMBER Yes The bottom-left Y-coordinate of the initial extent envelope Active
INIT_EXTENT_XMAX NUMBER Yes The bottom-right X-coordinate of the initial extent envelope Active
INIT_EXTENT_YMAX NUMBER Yes The top-right Y-coordinate of the initial extent envelope Active
SPATIALREFERENCE_WKID NUMBER Yes The spatial reference of the geometry Active
GOTO_INIT_EXTENT_ENABLED VARCHAR2 1 Yes To indicate whether the user is allowed to go back to the initial extent Active
MAPIMAGELAYER_URL VARCHAR2 300 The MapImageLayer used in the map Obsolete
LAYERLIST_ENABLED VARCHAR2 1 Yes To indicate whether the user is allowed to see the list of layers, and switching on/off their visibility Active
POPUP_DOCK_ENABLED VARCHAR2 1 Yes To indicate whether the placement of the popup is docked to the side of the view Active
POPUP_DOCK_POSITION VARCHAR2 30 Yes To specify the position in the view at which to dock the popup Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active

Indexes

Index Uniqueness Tablespace Columns Status
PSC_COM_MAP_PROFILE_PK Unique Default AGENCY_ID, MAP_PROFILE_ID Active