Restriction To Set
#
Data Dictionary - Entity Table: Restriction_To_SetMapping between restriction set and its constituents: separate restriction items. Many Restriction Sets can contain multiple Restrictions and also many Restrictions can take part in multiple Restriction sets.
Primary Key ('id') | . | ENGINE = InnoDB | . | . |
---|---|---|---|---|
Column Name | Data Type | PK Primary Key, NN-Not Null, Null | Example | Comments |
id | BIGINT(12) | PK, NN | 1 | PrimaryKey-ID, Not Null (auto creates) |
Resriction_Set | BIGINT(12) | NULL | 3 | Restriction set id |
Restriction | BIGINT(12) | NULL | 1 | Restriction id |
CONSTRAINT | FOREIGN KEY | REFERENCES | ON DELETE | ON UPDATE |
Restriction_Set | (Restriction_Set ) | Restriction_Set (id ) | NO ACTION | NO ACTION |
Restriction | (Restriction ) | Restriction (id ) | NO ACTION | NO ACTION |
CREATE INDEX | ON | ASC | VISIBLE | . |
Restriction_Set_idx | Restriction_To_Set | (Restriction_Set ASC) | VISIBLE | . |
Restriction_idx | Restriction_To_Set | (Restriction ASC) | VISIBLE | . |