Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table DEK_ZM_ZNAKI_SPRAW_14947 | Next Table |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_SPRAWY | NUMBER | |||
2 | DATA_DODANIA | DATE | Y | ||
3 | OPERATOR_DODAJACY | VARCHAR2(30 BYTE) | Y | ||
4 | DATA_MODYFIKACJI | DATE | |||
5 | OPERATOR_MODYFIKUJACY | VARCHAR2(30 BYTE) | |||
6 | ZNAK_SPRAWY | VARCHAR2(128 BYTE) | Y | ||
7 | ZNAK_SPRAWY_DZIAL | VARCHAR2(32 BYTE) | Y | ||
8 | ZNAK_SPRAWY_SYMBOL | VARCHAR2(32 BYTE) | Y | ||
9 | ZNAK_SPRAWY_NUMER | NUMBER | Y | ||
10 | ZNAK_SPRAWY_ROK | NUMBER(4) | Y | ||
11 | TYTUL_SPRAWY | VARCHAR2(150 BYTE) | Y | ||
12 | NR_KONTR | NUMBER | |||
13 | NOWY_ZNAK_SPRAWY | VARCHAR2(200 BYTE) |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
SYS_C0055574 | Check | "DATA_DODANIA" IS NOT NULL | ENABLED | DATA_DODANIA |
SYS_C0055575 | Check | "OPERATOR_DODAJACY" IS NOT NULL | ENABLED | OPERATOR_DODAJACY |
SYS_C0055576 | Check | "ZNAK_SPRAWY" IS NOT NULL | ENABLED | ZNAK_SPRAWY |
SYS_C0055577 | Check | "ZNAK_SPRAWY_DZIAL" IS NOT NULL | ENABLED | ZNAK_SPRAWY_DZIAL |
SYS_C0055578 | Check | "ZNAK_SPRAWY_SYMBOL" IS NOT NULL | ENABLED | ZNAK_SPRAWY_SYMBOL |
SYS_C0055579 | Check | "ZNAK_SPRAWY_NUMER" IS NOT NULL | ENABLED | ZNAK_SPRAWY_NUMER |
SYS_C0055580 | Check | "ZNAK_SPRAWY_ROK" IS NOT NULL | ENABLED | ZNAK_SPRAWY_ROK |
SYS_C0055581 | Check | "TYTUL_SPRAWY" IS NOT NULL | ENABLED | TYTUL_SPRAWY |
Comments |
Partitions |
Indexes |
Foreign Key Constraints |
Redaction Policies |