Creating New Data Table

5G UDR supports a definite set of operations in v1.0.0. Only PCF_DATA is supported in initial release. However a new data table can be added using the following command.

To support operations for newly added data table, user need to put appropriate entries in RESOURCE_MAP table as well which is explained later in this article under section Support a new URI in UDR.

Pre-requisite: Login to the NDB Cluster's SQL node with configured username/password.

Example:

CREATE TABLE IF NOT EXISTS TABLE_NAME (COLUMN_NAME bigint NOT NULL, COLUMN_NAME json , COLUMN_NAME json , COLUMN_NAME json , PRIMARY KEY (PRIMARY_KEY_COLUMN_NAME))ENGINE=NDBCLUSTER;
Example:
  CREATE TABLE IF NOT EXISTS PCF_DATA2 (DATA_ID bigint NOT NULL, AM_DATA2 json , SM_DATA2 json , UE_POLICY_SET2 json , PRIMARY KEY (DATA_ID))ENGINE=NDBCLUSTER;