pggeodb-preprod.nancy.inra.fr/db_diams

Table: nematrait

Schema

public

Owner

postgres

Tablespace

(default)

Descriptions

There is no description for table nematrait

Columns

Foreign Keys

There are no foreign keys for table nematrait

Check Constraints

There are no check constraints for table nematrait

Indices

Triggers

There are no triggers for table nematrait

Rules

There are no rules for table nematrait

Policies

There are no policies for table nematrait

Referenced

There are no tables referenced by table nematrait

Properties

Definition

CREATE TABLE public.nematrait (
 id_nematrait SERIAL,
 families VARCHAR,
 general VARCHAR,
 cp VARCHAR,
 pp VARCHAR,
 tt VARCHAR,
 tg VARCHAR,
 fgnum VARCHAR,
 bo_sh VARCHAR,
 bo_lg VARCHAR,
 bo_wd VARCHAR,
 bo_ma VARCHAR,
 cu_an VARCHAR,
 cu_ss VARCHAR,
 he_am_ty VARCHAR,
 he_am_sz VARCHAR,
 he_cs VARCHAR,
 he_fl VARCHAR,
 he_lp VARCHAR,
 he_cp VARCHAR,
 mo_lg VARCHAR,
 mo_wd VARCHAR,
 mo_sh VARCHAR,
 mo_sc VARCHAR,
 mo_ar_ty VARCHAR,
 mo_ar_ss_lg VARCHAR,
 mo_ar_aos_lg VARCHAR,
 mo_ar_sos_lg VARCHAR,
 mo_ar_cos_lg VARCHAR,
 mo_ar_mu_lg VARCHAR,
 mo_ar_do_sz VARCHAR,
 mo_ar_kn VARCHAR,
 mo_ar_od VARCHAR,
 mo_ar_do_m VARCHAR,
 mo_ar_sm VARCHAR,
 mo_ar_rr VARCHAR,
 mo_ar_wa VARCHAR,
 mo_ar_mt VARCHAR,
 mo_ar_dt VARCHAR,
 mo_ar_ga VARCHAR,
 mo_co VARCHAR,
 ph_lg VARCHAR,
 ph_cy VARCHAR,
 ph_mc VARCHAR,
 ph_is VARCHAR,
 ph_bb VARCHAR,
 ph_ov VARCHAR,
 ph_gl VARCHAR,
 go_vu VARCHAR,
 go_ty VARCHAR,
 ta_lg VARCHAR,
 ta_wd VARCHAR,
 ta_pd VARCHAR,
 ta_gl VARCHAR,
 ex_ty VARCHAR,
 aa VARCHAR,
 bb VARCHAR,
 cc VARCHAR,
 cprime VARCHAR,
 vv VARCHAR,
 cpr VARCHAR,
 dcb VARCHAR,
 dl VARCHAR,
 orders VARCHAR,
 CONSTRAINT nematrait_pkey PRIMARY KEY(id_nematrait)
) ;

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