pggeodb.nancy.inra.fr/db_robot - db_robot on pggeodb.nancy.inra.fr |
|
Table: pgmfavorites
pggeodb.nancy.inra.fr/db_robot - db_robot on pggeodb.nancy.inra.fr |
|
Table: pgmfavorites
Schema
public
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table pgmfavorites
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id |
bigserial |
|
|
|
nextval('pgmfavorites_seq_id'::regclass) |
|
|
|
fav_name |
text |
|
|
|
|
|
|
|
fav_source |
text |
|
|
|
|
|
|
|
fav_path |
text |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table pgmfavorites
Check Constraints
There are no check constraints for table pgmfavorites
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
id |
|
|
|
Triggers
There are no triggers for table pgmfavorites
Rules
There are no rules for table pgmfavorites
Policies
There are no policies for table pgmfavorites
Referenced
There are no tables referenced by table pgmfavorites
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
2 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
|
Definition
id BIGINT DEFAULT nextval('pgmfavorites_seq_id'::regclass) NOT NULL,
fav_name TEXT,
fav_source TEXT,
fav_path TEXT,
CONSTRAINT pgmfavorites_pkey PRIMARY KEY(id)
)
WITH (oids = false);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 26/02/2014 11:51 |
|