KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - SDO_GEOM_METADATA_TABLE link

Properties
Name Value
Data Model Physical
Schema PMIS
Primary Key Clustered Unspecified
Unlogged false
Temporal false

Columns Summary
Column Name Data Type PK / FK Nullable Description
SDO_OWNER varchar2(32) Yes
SDO_TABLE_NAME varchar2(32) Yes
SDO_COLUMN_NAME varchar2(32) Yes
SDO_DIMINFO number(-1) Yes
SDO_SRID number(19) Yes

Columns Detail
Name Value
Name SDO_OWNER
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 32
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SDO_TABLE_NAME
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 32
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SDO_COLUMN_NAME
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 32
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SDO_DIMINFO
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name "MDSYS"."SDO_DIM_ARRAY"
Length -1
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SDO_SRID
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 19
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

KDOT PMS Replacement Project