Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table CRM_KLIENCI | Next Table |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID | NUMBER | Y | id z sekwencji SQ_CRM_KLIENCI | |
2 | NAZWA | VARCHAR2(512 CHAR) | Y | nazwa klienta, wymagana,unikalna | |
3 | IMIE | VARCHAR2(64 CHAR) | imie klienta | ||
4 | NAZWISKO | VARCHAR2(64 CHAR) | nazwisko klienta | ||
5 | NIP | VARCHAR2(11 CHAR) | NIP klienta | ||
6 | REGON | VARCHAR2(14 CHAR) | REGON klienta | ||
7 | PESEL | VARCHAR2(11 CHAR) | PESEL klienta | ||
8 | NR_KONTR | NUMBER(6) | numer kontrahenta, klucz obcy na nr_kontr z kdo_wew | ||
9 | UWAGI | VARCHAR2(2000 CHAR) | uwagi klienta | ||
10 | KRAJ | VARCHAR2(3 BYTE) | Y | kod kraju, klucz obcy na kod_kraju z kraje | |
11 | AVATAR | VARCHAR2(2000 CHAR) | Sciezka do chronionego zasobu na dysku w aplikacji django EBOK2 | ||
12 | VARCHAR2(128 CHAR) | Adres e-mail klienta | |||
13 | TELKOM | VARCHAR2(16 CHAR) | Numer telfeonu komurkowy klienta | ||
14 | TEL | VARCHAR2(16 CHAR) | Numer telefonu klienta | ||
15 | WWW | VARCHAR2(265 CHAR) | Adres www dla klienta |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IDX_CRM_KLIENCI_NR_KONTR | NORMAL | NR_KONTR | <none> | ||||
NON-UNIQUE | INDX_CRM_KLIENC_KRAJ | NORMAL | KRAJ | <none> | ||||
UNIQUE | PK_CRM_KLIENCI_ID | NORMAL | ID | <none> | ||||
UNIQUE | UQ_CRM_KLIENCI_NAZWA | NORMAL | NAZWA | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_CRM_KLIENCI_KRAJ | KRAJ | F_54 | KRAJE | KOD_KRAJU | NO ACTION | ENABLED | No | No |
FK_CRM_KLIENCI_NR_KONTR | NR_KONTR | F_54 | KDO_WEW | NR_KONTR | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_CRM_KLIENCI_KRAJ | Check | "KRAJ" IS NOT NULL | ENABLED | KRAJ |
NN_CRM_KLIENCI_NAZWA | Check | "NAZWA" IS NOT NULL | ENABLED | NAZWA |
PK_CRM_KLIENCI_ID | Primary Key | ENABLED | ID | |
UQ_CRM_KLIENCI_NAZWA | Unique | ENABLED | NAZWA |
Comments |
Partitions |
Redaction Policies |