localhost/genw - genw on localhost |
|
Table: public_originators
localhost/genw - genw on localhost |
|
Table: public_originators
Schema
public
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table public_originators
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id |
integer |
|
|
|
|
|
|
|
name |
text |
|
|
|
|
|
|
|
created_at |
timestamptz |
|
|
|
|
|
|
|
deleted_at |
timestamptz |
|
|
|
|
|
|
|
city |
varchar(255) |
|
|
|
|
|
|
|
nip |
varchar(50) |
|
|
|
|
|
|
|
krs |
varchar(10) |
|
|
|
|
|
|
|
regon |
varchar(50) |
|
|
|
|
|
|
|
address |
varchar(255) |
|
|
|
|
|
|
|
zip_code |
varchar(6) |
|
|
|
|
|
|
|
phone |
varchar(20) |
|
|
|
|
|
|
|
card_administrator |
varchar(255) |
|
|
|
|
|
|
|
id_internal |
integer |
|
|
|
|
|
|
|
province_id |
integer |
|
|
|
|
|
|
|
possession |
varchar(255) |
|
|
|
|
|
|
|
place |
varchar(255) |
|
|
|
|
|
|
|
street |
varchar(255) |
|
|
|
|
|
|
|
idb |
integer |
|
|
|
|
|
|
|
ido |
integer |
|
|
|
|
|
|
|
id_pow |
integer |
|
|
|
|
|
|
|
id_gm |
integer |
|
|
|
|
|
|
|
id_woj |
integer |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table public_originators
Checks
There are no check constraints for table public_originators
Indices
There are no indices for table public_originators
Triggers
There are no triggers for table public_originators
Rules
There are no rules for table public_originators
Referenced
There are no tables referenced by table public_originators
Options
Option | Value |
|---|---|
Inherited From |
|
Rows |
1482 |
Pages |
41 |
System |
|
Temporary |
|
With OID |
|
Definition
id INTEGER,
name TEXT,
created_at TIMESTAMP WITH TIME ZONE,
deleted_at TIMESTAMP WITH TIME ZONE,
city VARCHAR(255),
nip VARCHAR(50),
krs VARCHAR(10),
regon VARCHAR(50),
address VARCHAR(255),
zip_code VARCHAR(6),
phone VARCHAR(20),
card_administrator VARCHAR(255),
id_internal INTEGER,
province_id INTEGER,
possession VARCHAR(255),
place VARCHAR(255),
street VARCHAR(255),
idb INTEGER,
ido INTEGER,
id_pow INTEGER,
id_gm INTEGER,
id_woj INTEGER
)
WITH (oids = false);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2016-07-27 08:48 |
|