Columns of Table CRM_KONTAKTY_TAGI
Column ID Column Name Datatype Not Null Data Default Comments
1 ID NUMBER Y   PK z sekwencji sq_crm_kontakty_tagi
2 ID_CRM_KONTAKT NUMBER Y   FK do crm_kontakty - wymagane
3 ID_SL_CRM_TAG NUMBER Y   FK do sl_crm_tagi - wymagane

Indexes on Table CRM_KONTAKTY_TAGI
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE INDX_CRM_KONTAK_IDSLCRMTAG NORMAL ID_SL_CRM_TAG <none>        
UNIQUE PK_CRM_KONTAKTY_TAGI_ID NORMAL ID <none>        
UNIQUE UQ_CRM_KONT_TAG_FKS NORMAL ID_CRM_KONTAKT, ID_SL_CRM_TAG <none>        

Foreign Key Constraints on Table CRM_KONTAKTY_TAGI
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_CRM_KONT_TAG_CRM_KONTAKTY ID_CRM_KONTAKT F_54 CRM_KONTAKTY ID NO ACTION ENABLED No No
FK_CRM_KONT_TAG_SL_CRM_TAGI ID_SL_CRM_TAG F_54 SL_CRM_TAGI ID NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table CRM_KONTAKTY_TAGI
Constraint Name Type Condition Status Columns
NN_CRM_KONT_TAG_ID_CRM_KONT Check "ID_CRM_KONTAKT" IS NOT NULL ENABLED ID_CRM_KONTAKT
NN_CRM_KONT_TAG_ID_SL_CRM_TAG Check "ID_SL_CRM_TAG" IS NOT NULL ENABLED ID_SL_CRM_TAG
PK_CRM_KONTAKTY_TAGI_ID Primary Key   ENABLED ID
UQ_CRM_KONT_TAG_FKS Unique   ENABLED ID_CRM_KONTAKT, ID_SL_CRM_TAG

Table CRM_KONTAKTY_TAGI does not have...
Comments
Partitions
Redaction Policies