Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table MAGAZYNY | Next Table |
Comment |
---|
spis magazynow |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | MAGAZYN | NUMBER(3) | Y | id magazynu (PK) | |
2 | OPIS | VARCHAR2(40 BYTE) | opis magazynu | ||
3 | MWS | CHAR(1 BYTE) | |||
4 | ID_REGULY | NUMBER(8) | przypisana regula ksiegowania (FK) | ||
5 | CZY_KS | CHAR(1 BYTE) | 'T' | ||
6 | DEPOZYT | CHAR(1 BYTE) | 'N' | depozyt | |
7 | CENY | CHAR(1 BYTE) | 'Z' | czy ceny dot. magazynu | |
8 | BLOKADA | CHAR(1 BYTE) | 'N' | czy magazyn jest zablokowany | |
9 | MAG_OPAKOWAN | NUMBER(3) | Numer magazyny opakowan dla danego magazynu | ||
10 | KONTO | VARCHAR2(20 BYTE) | Konto na jakie bedzie ksiegowany magazyn w materialowce | ||
11 | DATA_STANU | DATE | Data przeliczenia stanu magazynu |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_MAGAZYMAGAZ_IDREGULY | NORMAL | ID_REGULY | <none> | ||||
NON-UNIQUE | IX_MAGAZYMAGAZ_MAGOPAKOWAN | NORMAL | MAG_OPAKOWAN | <none> | ||||
UNIQUE | PK_MAGAZYNY | NORMAL | MAGAZYN | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_MAGAZYNY_REGULYKS | ID_REGULY | F_54 | REGULY_KS | ID_REGULY | NO ACTION | ENABLED | No | No |
FK_MAG_OPAK | MAG_OPAKOWAN | F_54 | MAGAZYNY | MAGAZYN | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
PK_MAGAZYNY | Primary Key | ENABLED | MAGAZYN |
Partitions |
Redaction Policies |