[Home] [Help] [Dependency Information]
Object Name: | CSF_LF_PLACE_NAMES_WM |
---|---|
Object Type: | TABLE |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
DEFINITION
Intersection table required since one place can have many names (e.g. Exonyms, Synonyms) and one Name can be used by multiple Places (e.g. Utrecht city, municipality and province).
EXAMPLE
MISCELLANEOUS
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLACE_NAME_ID | NUMBER | (30) | Yes | Surrogate key used for primary unique identifiers |
NAME_TYPE | VARCHAR2 | (1) | Yes | Indication if Name represents Official or Alternate name for Place. |
PLACE_ID | NUMBER | (30) | Yes | Unique key that identifies the place |
NAME_ID | NUMBER | (30) | Yes | Unique key for Name |
SECURITY_GROUP_ID | NUMBER | Identifier used for running in hosted mode |
Cut, paste (and edit) the following text to query this object:
SELECT PLACE_NAME_ID
, NAME_TYPE
, PLACE_ID
, NAME_ID
, SECURITY_GROUP_ID
FROM CSF.CSF_LF_PLACE_NAMES_WM;
CSF.CSF_LF_PLACE_NAMES_WM does not reference any database object
CSF.CSF_LF_PLACE_NAMES_WM is referenced by following:
|
|
|