Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table WAR_PWU_CZAS | Next Table |
Comment |
---|
Tabela zawierajÄ?ca informacje o przepracowanych iloĹ?ciach godzin pracownikĂłw nad danym zleceniem |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_PWU | NUMBER(8) | Y | Id zlecenia | |
2 | ID_PRAC | NUMBER(8) | Y | Id pracownika | |
3 | DATA | DATE | DzieĹ? pracy | ||
4 | ILOSC_GODZIN | NUMBER(6) | Y | IloĹ?Ä? przepracowanych godzin | |
5 | ILOSC_MINUT | NUMBER(2) | IloĹ?Ä? przepracowanych minut | ||
6 | ID | NUMBER | Y | ||
7 | IL_GODZIN_ZLECEN | NUMBER |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_WARPWURPWUC_IDPRAC | NORMAL | ID_PRAC | <none> | ||||
NON-UNIQUE | IX_WARPWURPWUC_IDPWU | NORMAL | ID_PWU | <none> | ||||
UNIQUE | PK_WAR_PWU_CZAS_ID | NORMAL | ID | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_WARPWU_CZAS_PRACOWNICY | ID_PRAC | F_54 | PRACOWNICY | ID_PRAC | NO ACTION | ENABLED | No | No |
FK_WARPWU_CZAS_WARPWU | ID_PWU | F_54 | WAR_PWU | ID_PWU | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
SYS_C0054905 | Check | "ID_PWU" IS NOT NULL | ENABLED | ID_PWU |
SYS_C0054906 | Check | "ID_PRAC" IS NOT NULL | ENABLED | ID_PRAC |
SYS_C0054907 | Check | "ILOSC_GODZIN" IS NOT NULL | ENABLED | ILOSC_GODZIN |
PK_WAR_PWU_CZAS_ID | Primary Key | ENABLED | ID |
Partitions |
Redaction Policies |