SDM_DATA_SET
This table stores all data sets of the system.
Details
Object type: TABLE
Primary Key
Table 4-21 Primary Key Table
| Constraint Name | Columns |
|---|---|
| SDM_DS_PK | DATA_SET_ID |
Foreign Key
Table 4-22 Foreign Key Table
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| SDM_DATA_SET | SDM_DC_INTERVAL | DCI_ID |
| SDM_DATA_SET | SDM_DATA_SET | MASTER_ID |
Columns
Table 4-23 Column Details Table
| Name | Data Type | Length | Precision | Scale | Null Allowed | Comments |
|---|---|---|---|---|---|---|
| DATA_SET_ID | NUMBER | 18 | 0 | No | Unique identifier of the record. | |
| NAME | VARCHAR2 | 80 | No | Name of the data set. | ||
| DCI_ID | NUMBER | 18 | 0 | No | Interval, to which, this record belongs. Refers to DCI_ID of SDM_DC_INTERVAL table. | |
| IS_SUB_COLLECTION | CHAR | 1 | No | Indicates whether this data set is Sub-Collection or not. | ||
| IS_SHARE_DATA | CHAR | 1 | No | Indicates whether the data is shared across templates. | ||
| IS_TRANSLATABLE | CHAR | 1 | No | Indicates whether name should be translated for display or not. | ||
| INTERNAL_ID | VARCHAR2 | 100 | Yes | Internal id for the object. Used primarily in LCM. | ||
| DESCRIPTION | VARCHAR2 | 1000 | Yes | Description of the data set. | ||
| DB_TABLE_NAME | VARCHAR2 | 50 | 18 | 0 | Yes | For each data set, one table is created dynamically to store the data. This field indicates the database table name. |
| DB_TABLE_NAME2 | VARCHAR2 | 50 | Yes | For each data set, one association table is created dynamically to store association between data and form instance. This field indicates the database table name. | ||
| MASTER_ID | NUMBER | 18 | 0 | Yes | During deploy, copy record is created. This field is populated in copy record to point to the master record. Refers to primary key of this same table. | |
| IS_MASTER_MODIFIED | CHAR | 1 | Yes | Indicates whether master record is modified after deploy. This field is applicable for copy records only. It will always be NULL for master record. | ||
| DCP_ID | NUMBER | 18 | 0 | Yes | Data Collection Period, to which, this copy record belongs. Refers to DCP_ID of SDM_DATA_COLLECTION_PERIOD table. | |
| APP_ID | NUMBER | 1 | 0 | No | Identifier for the application to which the row corresponds to, for example, SDM:4. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 0 | No | 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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 255 | Yes | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 255 | No | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | DATE | No | Who column: indicates the date and time of the last update of the row. | |||
| CREATED_BY | VARCHAR2 | 255 | No | Who column: indicates the user who created the row. | ||
| CREATION_DATE | DATE | No | Who column: indicates the date and time of the creation of the row. |
Indexes
Table 4-24 Index Table
| Index | Uniqueness | Columns |
|---|---|---|
| SDM_DS_PK | UNIQUE | DATA_SET_ID |
| SDM_DS_U1_NAME_DCP | UNIQUE | SYS_NC00021$, DCP_ID, APP_ID |
| SDM_DS_U2_MASTER_DCP | UNIQUE | MASTER_ID, DCP_ID |
| SDM_DS_U3_INTERNAL_ID | UNIQUE | SYS_NC00022$, DCP_ID, APP_ID |