Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table SMS_KANALY_GRUPY_ROLE | Next Table |
Comment |
---|
Tabela wiążąca grupy z kanałami sms |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_POZ | NUMBER | Y | PK generowany z sekwencji SEQ_sms_kanaly_grupy_role | |
2 | ID_KANALU | NUMBER | Id kanału (FK -> sms_sl_kanaly) | ||
3 | ID_GRUPY_ROLE | NUMBER | Id grupy (FK -> sl_grupy_uzytkownicy). W kolumnie powinny znajdować się tylko grupy nadające role 'MGATOOLSV3$SMS' |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | INDX_SMS_KANALY_IDGRUPYROLE | NORMAL | ID_GRUPY_ROLE | <none> | ||||
UNIQUE | PK_SMS_KANALY_GRUPY_ROLE | NORMAL | ID_POZ | <none> | ||||
UNIQUE | UQ_SMS_KAN_GR_ROLE_KANGR_ROLE | NORMAL | ID_KANALU, ID_GRUPY_ROLE | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_SMS_KANALY_GRUPY_ROLE_GRUPY | ID_GRUPY_ROLE | F_54 | SL_GRUPY_UZYTKOWNICY | ID | NO ACTION | ENABLED | No | No |
FK_SMS_KANALY_GRUPY_ROLE_KANAL | ID_KANALU | F_54 | SMS_SL_KANALY | ID_KANALU | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
PK_SMS_KANALY_GRUPY_ROLE | Primary Key | ENABLED | ID_POZ | |
UQ_SMS_KAN_GR_ROLE_KANGR_ROLE | Unique | ENABLED | ID_KANALU, ID_GRUPY_ROLE |
Partitions |
Redaction Policies |