Schema
public
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table producers
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id |
integer |
|
|
|
|
|
|
|
name |
varchar(255) |
|
|
|
|
|
|
|
varchar(255) |
|
|
|
|
|
|
|
|
active |
char(1) |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table producers
Checks
There are no check constraints for table producers
Indices
There are no indices for table producers
Triggers
There are no triggers for table producers
Rules
There are no rules for table producers
Referenced
There are no tables referenced by table producers
Options
Option | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE public.producers (
id INTEGER,
name VARCHAR(255),
email VARCHAR(255),
active CHAR(1)
)
WITH (oids = false);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2016-07-27 08:48 |
|