Comment for Table USR_KDO_UPR_TYPYKON
Comment
tabela ograniczajaca dostep uzytkownikow do odp. typow kontrahentow

Columns of Table USR_KDO_UPR_TYPYKON
Column ID Column Name Datatype Not Null Data Default Comments
1 SCHEMAT VARCHAR2(30 BYTE) Y   nazwa uzytkownika
2 TYP_KONTR VARCHAR2(5 BYTE) Y   typ kontrahenta (FK)

Indexes on Table USR_KDO_UPR_TYPYKON
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_USRKDORTYPY_TYPKONTR NORMAL TYP_KONTR <none>        
UNIQUE UQ_USR_KDO_UPR_TYPYKON_SCHTYP NORMAL SCHEMAT, TYP_KONTR <none>        

Foreign Key Constraints on Table USR_KDO_UPR_TYPYKON
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_KDOURPTYPYKON_TYPYKON TYP_KONTR F_54 TYPYKON TYP NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table USR_KDO_UPR_TYPYKON
Constraint Name Type Condition Status Columns
CH_NN_USR_KDO_UPR_SCHEMAT Check "SCHEMAT" IS NOT NULL ENABLED SCHEMAT
CH_NN_USR_KDO_UPR_TYP_KONTR Check "TYP_KONTR" IS NOT NULL ENABLED TYP_KONTR
UQ_USR_KDO_UPR_TYPYKON_SCHTYP Unique   ENABLED SCHEMAT, TYP_KONTR

Table USR_KDO_UPR_TYPYKON does not have...
Partitions
Redaction Policies