Comment for Table GMINY
Comment |
tabela dla gmin |
Columns of Table GMINY
Column ID |
Column Name |
Datatype |
Not Null |
Data Default |
Comments |
1 |
ID_GMINY |
NUMBER(8) |
Y |
|
identyfikator gminy (PK) |
2 |
ID_POW |
NUMBER(8) |
|
|
powiat (FK) |
3 |
GMINA |
VARCHAR2(60 BYTE) |
|
|
nazwa gminy |
4 |
KOD_TERC |
VARCHAR2(7 BYTE) |
|
|
kod TERC gminy |
5 |
NAZWA_TERC |
VARCHAR2(60 BYTE) |
|
|
nazwa TERC gminy |
Indexes on Table GMINY
Uniqueness |
Index Name |
Type |
Columns |
Partitions |
Partition Type |
Partition Columns |
Subpartition Type |
Subpartition Columns |
NON-UNIQUE |
IDX_gminy_upper_gmina |
FUNCTION-BASED NORMAL |
UPPER("GMINA") |
<none> |
|
|
|
|
NON-UNIQUE |
IX_GMINY_IDPOW |
NORMAL |
ID_POW |
<none> |
|
|
|
|
UNIQUE |
PK_GMINA |
NORMAL |
ID_GMINY |
<none> |
|
|
|
|
UNIQUE |
UK_GMINY_KOD_TERC |
NORMAL |
KOD_TERC |
<none> |
|
|
|
|
Foreign Key Constraints on Table GMINY
Constraint Name |
Columns |
Ref Table Owner |
Referenced Table Name |
Referenced Columns |
Delete Rule |
Status |
Deferrable |
Deferred |
FK_GMINY_POWIATY |
ID_POW |
F_54 |
POWIATY |
ID_POW |
NO ACTION |
ENABLED |
No |
No |
PK, UK, & Check Constraints on Table GMINY
Constraint Name |
Type |
Condition |
Status |
Columns |
PK_GMINA |
Primary Key |
|
ENABLED |
ID_GMINY |
UK_GMINY |
Unique |
|
DISABLED |
GMINA |
UK_GMINY_KOD_TERC |
Unique |
|
ENABLED |
KOD_TERC |
Table GMINY does not have...
Partitions |
Redaction Policies |