pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Table: t_phy_exphy

 

 

Schema

para_phy

 

Owner

ychaval

 

Tablespace

(default)

 

Descriptions

There is no description for table t_phy_exphy

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

 

exphy_ani_cpt

text

 

 

 

 

 

 

 

exphy_ani_etiq

text

 

 

 

 

 

 

 

albumine_concentration

text

 

 

 

 

 

 

 

albumine_percent

text

 

 

 

 

 

 

 

azote_fecale

text

 

 

 

 

 

 

 

b12

text

 

 

 

 

 

 

 

carbone_fecale

text

 

 

 

 

 

 

 

cayman_cortisol_elisa_kit

text

 

 

 

 

 

 

 

cayman_cortisol_elisa_kit_duplicate

text

 

 

 

 

 

 

 

cayman_cortisol_elisa_kit_mean

text

 

 

 

 

 

 

 

concentration_corpusculaire_en_hgb_mchc

text

 

 

 

 

 

 

 

creatinine

text

 

 

 

 

 

 

 

creatinine_kinase

text

 

 

 

 

 

 

 

differential_white_blood_cell_count

text

 

 

 

 

 

 

 

fibrinogene

text

 

 

 

 

 

 

 

fructosamine

text

 

 

 

 

 

 

 

globule_blanc_wbc

text

 

 

 

 

 

 

 

globule_rouge_rbc

text

 

 

 

 

 

 

 

globuline

text

 

 

 

 

 

 

 

globuline_alpha1_concentration

text

 

 

 

 

 

 

 

globuline_alpha1_percent

text

 

 

 

 

 

 

 

globuline_alpha2_concentration

text

 

 

 

 

 

 

 

globuline_alpha2_percent

text

 

 

 

 

 

 

 

globuline_beta_concentration

text

 

 

 

 

 

 

 

globuline_beta_percent

text

 

 

 

 

 

 

 

globuline_gamma_concentration

text

 

 

 

 

 

 

 

globuline_gamma_percent

text

 

 

 

 

 

 

 

gluco_corticoid_07_08

text

 

 

 

 

 

 

 

gluco_corticoid_10_11

text

 

 

 

 

 

 

 

gnb_granulocyte_basophile

text

 

 

 

 

 

 

 

gnb_granulocyte_basophile_total

text

 

 

 

 

 

 

 

gne_granulocyte_eosinophile

text

 

 

 

 

 

 

 

gne_granulocyte_eosinophile_total

text

 

 

 

 

 

 

 

gnn_granulocyte_basophil

text

 

 

 

 

 

 

 

gnn_granulocyte_basophil_auto

text

 

 

 

 

 

 

 

gnn_granulocyte_basophil_count

text

 

 

 

 

 

 

 

gnn_granulocyte_eosinophil

text

 

 

 

 

 

 

 

gnn_granulocyte_eosinophil_count

text

 

 

 

 

 

 

 

gnn_granulocyte_neutrophile

text

 

 

 

 

 

 

 

gnn_granulocyte_neutrophile_total

text

 

 

 

 

 

 

 

hemagglutination_ha

text

 

 

 

 

 

 

 

hematocrite_hct

text

 

 

 

 

 

 

 

hemoglobine_hgb

text

 

 

 

 

 

 

 

hemolysis_hl

text

 

 

 

 

 

 

 

high_fluorescence_reticulocyte

text

 

 

 

 

 

 

 

immature_reticulocyte_fraction

text

 

 

 

 

 

 

 

low_fluorescence_reticulocyte

text

 

 

 

 

 

 

 

lymphocyte

text

 

 

 

 

 

 

 

lymphocyte_total

text

 

 

 

 

 

 

 

mean_platelet_volume

text

 

 

 

 

 

 

 

microhematocrites_percent

text

 

 

 

 

 

 

 

middle_fluorescence_reticulocyte

text

 

 

 

 

 

 

 

monocytes

text

 

 

 

 

 

 

 

monocyte_total

text

 

 

 

 

 

 

 

phosphore_fecale

text

 

 

 

 

 

 

 

plaquette_comptage_plt_o

text

 

 

 

 

 

 

 

plaquette_impedance_plt

text

 

 

 

 

 

 

 

platelet_crit

text

 

 

 

 

 

 

 

platelet_distribution_width

text

 

 

 

 

 

 

 

platelet_larger_cell_ratio

text

 

 

 

 

 

 

 

proteine_totale

text

 

 

 

 

 

 

 

ratio_albumine_globuline

text

 

 

 

 

 

 

 

red_blood_cell_hemoglobin_equivalent

text

 

 

 

 

 

 

 

red_cell_distribution_width

text

 

 

 

 

 

 

 

red_cell_distribution_width_percent

text

 

 

 

 

 

 

 

remark_formule_sanguine

text

 

 

 

 

 

 

 

reticulocyte_count

text

 

 

 

 

 

 

 

reticulocyte_hemoglobin_equivalent

text

 

 

 

 

 

 

 

reticulocyte_rate

text

 

 

 

 

 

 

 

t4

text

 

 

 

 

 

 

 

taux_corpusculaire_moyen_mch

text

 

 

 

 

 

 

 

texture_feces

text

 

 

 

 

 

 

 

uree

text

 

 

 

 

 

 

 

volume_globulaire_moyen_mcv

text

 

 

 

 

 

 

 

exphy_cap_id

integer

 

 

 

 

 

 

 

exphy_cap_bague

varchar(12)

 

 

 

 

 

 

Foreign Keys

There are no foreign keys for table t_phy_exphy

 

Check Constraints

There are no check constraints for table t_phy_exphy

 

Indices

There are no indices for table t_phy_exphy

 

Triggers

There are no triggers for table t_phy_exphy

 

Rules

There are no rules for table t_phy_exphy

 

Policies

There are no policies for table t_phy_exphy

 

Referenced

There are no tables referenced by table t_phy_exphy

 

Properties

Property

Value

Inherited From

 

Rows

601

Pages

38

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE para_phy.t_phy_exphy (
 exphy_ani_cpt TEXT,
 exphy_ani_etiq TEXT,
 albumine_concentration TEXT,
 albumine_percent TEXT,
 azote_fecale TEXT,
 b12 TEXT,
 carbone_fecale TEXT,
 cayman_cortisol_elisa_kit TEXT,
 cayman_cortisol_elisa_kit_duplicate TEXT,
 cayman_cortisol_elisa_kit_mean TEXT,
 concentration_corpusculaire_en_hgb_mchc TEXT,
 creatinine TEXT,
 creatinine_kinase TEXT,
 differential_white_blood_cell_count TEXT,
 fibrinogene TEXT,
 fructosamine TEXT,
 globule_blanc_wbc TEXT,
 globule_rouge_rbc TEXT,
 globuline TEXT,
 globuline_alpha1_concentration TEXT,
 globuline_alpha1_percent TEXT,
 globuline_alpha2_concentration TEXT,
 globuline_alpha2_percent TEXT,
 globuline_beta_concentration TEXT,
 globuline_beta_percent TEXT,
 globuline_gamma_concentration TEXT,
 globuline_gamma_percent TEXT,
 gluco_corticoid_07_08 TEXT,
 gluco_corticoid_10_11 TEXT,
 gnb_granulocyte_basophile TEXT,
 gnb_granulocyte_basophile_total TEXT,
 gne_granulocyte_eosinophile TEXT,
 gne_granulocyte_eosinophile_total TEXT,
 gnn_granulocyte_basophil TEXT,
 gnn_granulocyte_basophil_auto TEXT,
 gnn_granulocyte_basophil_count TEXT,
 gnn_granulocyte_eosinophil TEXT,
 gnn_granulocyte_eosinophil_count TEXT,
 gnn_granulocyte_neutrophile TEXT,
 gnn_granulocyte_neutrophile_total TEXT,
 hemagglutination_ha TEXT,
 hematocrite_hct TEXT,
 hemoglobine_hgb TEXT,
 hemolysis_hl TEXT,
 high_fluorescence_reticulocyte TEXT,
 immature_reticulocyte_fraction TEXT,
 low_fluorescence_reticulocyte TEXT,
 lymphocyte TEXT,
 lymphocyte_total TEXT,
 mean_platelet_volume TEXT,
 microhematocrites_percent TEXT,
 middle_fluorescence_reticulocyte TEXT,
 monocytes TEXT,
 monocyte_total TEXT,
 phosphore_fecale TEXT,
 plaquette_comptage_plt_o TEXT,
 plaquette_impedance_plt TEXT,
 platelet_crit TEXT,
 platelet_distribution_width TEXT,
 platelet_larger_cell_ratio TEXT,
 proteine_totale TEXT,
 ratio_albumine_globuline TEXT,
 red_blood_cell_hemoglobin_equivalent TEXT,
 red_cell_distribution_width TEXT,
 red_cell_distribution_width_percent TEXT,
 remark_formule_sanguine TEXT,
 reticulocyte_count TEXT,
 reticulocyte_hemoglobin_equivalent TEXT,
 reticulocyte_rate TEXT,
 t4 TEXT,
 taux_corpusculaire_moyen_mch TEXT,
 texture_feces TEXT,
 uree TEXT,
 volume_globulaire_moyen_mcv TEXT,
 exphy_cap_id INTEGER,
 exphy_cap_bague VARCHAR(12)
)
WITH (oids = false);

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