pggeodb-preprod.nancy.inra.fr/db_diams
Previous topic Chapter index Next topic

Table: histo_echant

 

 

Schema

public

 

Owner

postgres

 

Tablespace

(default)

 

Descriptions

There is no description for table histo_echant

 

Columns

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

id_histo

serial

 

nextval('histo_echant_pmk_histo_seq'::regclass)

 

 

 

id_histo_echant

integer

 

 

 

 

 

 

 

evenement

varchar

 

 

 

 

 

 

 

quantite

varchar

 

 

 

 

 

 

 

comment_histo

varchar

 

 

 

 

 

 

 

date_histo

varchar

 

 

 

 

 

 

Foreign Keys

There are no foreign keys for table histo_echant

 

Check Constraints

There are no check constraints for table histo_echant

 

Indices

Name

Type

Function

Columns

Primary Key

Unique

Description

pmk_histo

btree

 

id_histo

 

 

Triggers

There are no triggers for table histo_echant

 

Rules

There are no rules for table histo_echant

 

Policies

There are no policies for table histo_echant

 

Referenced

There are no tables referenced by table histo_echant

 

Properties

Property

Value

Inherited From

 

Rows

-1

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.histo_echant (
 id_histo SERIAL,
 id_histo_echant INTEGER,
 evenement VARCHAR,
 quantite VARCHAR,
 comment_histo VARCHAR,
 date_histo VARCHAR,
 CONSTRAINT pmk_histo PRIMARY KEY(id_histo)
) ;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23
Previous topic Chapter index Next topic