SCV table structure

The valid combination definitions are saved in SCV using the SZ_VALID_COMBINATIONS and SZ_VALID_COMBINATIONS_TABLE tables. SCV receives only the related tables (selected tables or override tables) that are used for valid combinations.

The table structure is as follows:

CREATE TABLE SZ_VALID_COMBINATIONS (
        valid_combinations_id       bigint          NOT NULL,
        valid_combinations_name     nvarchar(80)    NOT NULL,
        description                 nvarchar(400)       NULL,
        status                      nvarchar(30)    NOT NULL
        sc_indicator                nvarchar(1)     NOT NULL,
        created_by                  nvarchar(80)    NOT NULL,
        creation_time               datetime2(7)    NOT NULL,
        modified_by                 nvarchar(80)    NOT NULL,
        modification_time           datetime2(7)    NOT NULL
    )

    CREATE TABLE SZ_VALID_COMBINATIONS_TABLE (
        valid_combinations_id      bigint                 NOT NULL,
        table_name                 nvarchar(80)           NOT NULL,
        rank                       int                        NULL
        created_by                  nvarchar(80)    NOT NULL,
        creation_time               datetime2(7)    NOT NULL,
        modified_by                 nvarchar(80)    NOT NULL,
        modification_time           datetime2(7)    NOT NULL
    )