Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table PARAMETRY_WAR | Next Table |
Comment |
---|
Tabela parametroww warsztatu |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_WYDZIALU | NUMBER(6) | Identyfikator wydzialu okrajacego warsztat | ||
2 | KONTO_ROZ_KOSZT_WYDZ | VARCHAR2(32 BYTE) | |||
3 | REJESTR_ROZ_KOSZT_WYDZ | VARCHAR2(5 BYTE) | |||
4 | KONTO_PRZE_KOSZT | VARCHAR2(32 BYTE) | |||
5 | REJESTR_PRZE_KOSZT | VARCHAR2(5 BYTE) | |||
6 | KLUCZ_PODZIALOWY | VARCHAR2(30 BYTE) | |||
7 | ID_REGULY_ROZ_KOSZT_WYDZ | NUMBER | |||
8 | ID_REGULY_PRZE_KOSZT | NUMBER |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_PARAMEMETRY_IDREGULYPRZEKO | NORMAL | ID_REGULY_PRZE_KOSZT | <none> | ||||
NON-UNIQUE | IX_PARAMEMETRY_IDREGULYROZKOS | NORMAL | ID_REGULY_ROZ_KOSZT_WYDZ | <none> | ||||
NON-UNIQUE | IX_PARAMEMETRY_KLUCZPODZIALOW | NORMAL | KLUCZ_PODZIALOWY | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_PARAMETRY_WAR_KL_PODZ | KLUCZ_PODZIALOWY | F_54 | STALE | STALA | NO ACTION | ENABLED | No | No |
FK_PAR_WAR_ID_REG_RKW | ID_REGULY_ROZ_KOSZT_WYDZ | F_54 | REGULY_KS | ID_REGULY | NO ACTION | ENABLED | No | No |
FK_PAR_WAR_ID_REG_RKZ | ID_REGULY_PRZE_KOSZT | F_54 | REGULY_KS | ID_REGULY | NO ACTION | ENABLED | No | No |
Partitions |
Primary Key, Unique, or Check Constraints |
Redaction Policies |