1. Tables and Views for Sales and Fusion Service
  2. SVC_IOT_REG_REQS

SVC_IOT_REG_REQS

This table is used to store registration requests from IOT cloud. REGISTRATION_REQ_ID is primary key in this table.

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

SVC_IOT_REG_REQS_PK

REGISTRATION_REQ_ID

Columns

Name Datatype Length Precision Not-null Comments Status
REGISTRATION_REQ_ID NUMBER Yes Auto-generated number and primary key for this table.
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 255 Specifies the original system reference if record was imported.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. 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
ASSET_ID NUMBER Yes CRM ASSET_ID corresponding to the device to be registered.
DEVICE_UID VARCHAR2 255 Unique identifier of the device to be registered.
SHARED_SECRET VARCHAR2 255 Activation Secret for the device to be registered. Should be ASCII printable characters.
DEVICE_ID VARCHAR2 255 Stores IoT Cloud Service Device Id.
DEVICE_NAME VARCHAR2 255 Name of the device to be registered.
DEVICE_MANUFACTURER VARCHAR2 64 Stores Device manufacturer name.
DEVICE_MODEL VARCHAR2 64 Stores model number of the device.
DEVICE_SERIAL_NUMBER VARCHAR2 128 Stores serial number of the device.
DEVICE_DESCRIPTION VARCHAR2 2000 Stores description of the device.
GPS_LATITUDE NUMBER Stores GPS Latitude of the device.
GPS_LONGITUDE NUMBER Stores GPS Longitude of the device.
GPS_ALTITUDE NUMBER Stores GPS Altitude of the device.
DEVICE_CREATION_STATUS VARCHAR2 20 Stores creation status of the device.
DEVICE_CREATION_DATE DATE Stores creation date of the device.
DEVICE_REGISTRATION_STATUS VARCHAR2 20 Stores registration status of the device.
DEVICE_REGITSRATION_DATE DATE Stores registration date of the device.

Foreign Keys

Table Foreign Table Foreign Key Column
SVC_IOT_REG_REQS zca_asset ASSET_ID
svc_iot_reg_metadata svc_iot_reg_reqs REGISTRATION_REQ_ID

Indexes

Index Uniqueness Tablespace Columns
SVC_IOT_REG_REQS_F1 Non Unique Default ASSET_ID
SVC_IOT_REG_REQS_PK Unique Default REGISTRATION_REQ_ID
SVC_IOT_REG_REQS_U1 Unique Default ORIGINAL_SYSTEM_REFERENCE
SVC_IOT_REG_REQS_U2 Unique Default LAST_UPDATE_DATE, REGISTRATION_REQ_ID