Comment for Table POSESJA_USLUGI_RABATY
Comment
Tabela wiążąca rabat z daną ułsugą na posesji

Columns of Table POSESJA_USLUGI_RABATY
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_USLUGI1 NUMBER(8) Y   ID USLUGI z tabeli POSESJA_USLUGI
2 ID_RABATU2 NUMBER(8) Y   id rabatu z tabeli rabatu
3 PR_RABATU NUMBER(5,2)     procent rabatu

Indexes on Table POSESJA_USLUGI_RABATY
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_POSESJGIRAB_IDRABATU NORMAL ID_RABATU <none>        
UNIQUE PK_POSESJAUSLUGIRABATY NORMAL ID_USLUGI, ID_RABATU <none>        

Foreign Key Constraints on Table POSESJA_USLUGI_RABATY
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_USLUGIRABATY_IDRABATU ID_RABATU F_54 RABATY ID_RABATU NO ACTION ENABLED No No
FK_USLUGIRABATY_IDUSLUGI ID_USLUGI F_54 POSESJA_USLUGI ID_USLUGI NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table POSESJA_USLUGI_RABATY
Constraint Name Type Condition Status Columns
SYS_C0054728 Check "ID_USLUGI" IS NOT NULL ENABLED ID_USLUGI
SYS_C0054729 Check "ID_RABATU" IS NOT NULL ENABLED ID_RABATU
PK_POSESJAUSLUGIRABATY Primary Key   ENABLED ID_USLUGI, ID_RABATU

Table POSESJA_USLUGI_RABATY does not have...
Partitions
Redaction Policies