[Home] [Help] [Dependency Information]
Object Name: | ORDDCM_UID_DEFS |
---|---|
Object Type: | TABLE |
Owner: | ORDSYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ORDDCM_UID_DEFS_PK | NORMAL | UNIQUE | SYSTEM | UDID |
ORDDCM_UID_DEFS_UK1 | NORMAL | UNIQUE | SYSTEM | DICOM_UID |
Table | |
Foreign Table | Foreign Key Column | ORDDCM_UID_DEFS | ORDDCM_DOCS | ORDDCM_UID_DEFS DOC_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UDID | NUMBER | (38) | Yes | |
DICOM_UID | VARCHAR2 | (128) | Yes | |
DOC_ID | NUMBER | (38) | Yes | |
NAME | VARCHAR2 | (128) | Yes | |
CLASSIFICATION | VARCHAR2 | (64) | Yes | |
ISLE | NUMBER | (1) | Yes | |
ISEVR | NUMBER | (1) | Yes | |
ISCOMPRESSED | NUMBER | (1) | Yes | |
ISRETIRED | NUMBER | (1) | Yes | |
CONTENTTYPE | VARCHAR2 | (64) | Yes | |
UID_DESC | VARCHAR2 | (1999) |
Cut, paste (and edit) the following text to query this object:
SELECT UDID
, DICOM_UID
, DOC_ID
, NAME
, CLASSIFICATION
, ISLE
, ISEVR
, ISCOMPRESSED
, ISRETIRED
, CONTENTTYPE
, UID_DESC
FROM ORDSYS.ORDDCM_UID_DEFS;
ORDSYS.ORDDCM_UID_DEFS does not reference any database object
ORDSYS.ORDDCM_UID_DEFS is not referenced by any database object
|
|
|