Schema
Owner
ychaval
Tablespace
(default)
Descriptions
There is no description for table t_para_expar
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
|
expar_ani_cpt |
text |
|
|
|
|
|
|
|
expar_ani_etiq |
text |
|
|
|
|
|
|
|
adhs_dilution_neospora_caninum |
text |
|
|
|
|
|
|
|
adhs_dilution_toxoplasma_gondii |
text |
|
|
|
|
|
|
|
adhs_titre_neospora_caninum |
text |
|
|
|
|
|
|
|
adhs_titre_toxoplasma_gondii |
text |
|
|
|
|
|
|
|
anaplasma_pcr_anaplasma_phagocytophilum |
text |
|
|
|
|
|
|
|
babesia_digestion_clai_hinfi_babesia_capreoli |
text |
|
|
|
|
|
|
|
babesia_digestion_clai_hinfi_babesia_venatorum |
text |
|
|
|
|
|
|
|
babesia_pcr_babesia |
text |
|
|
|
|
|
|
|
babesia_sequence_babesia_capreoli |
text |
|
|
|
|
|
|
|
bartonella_schoenbuchensi_bacteraemia_bartonella_schoenbuchensi |
text |
|
|
|
|
|
|
|
bartonella_schoenbuchensi_boleen_bartonella_schoenbuchensis |
text |
|
|
|
|
|
|
|
brucellose_pcr_brucella_abortus |
text |
|
|
|
|
|
|
|
btv_elisa_blue_tongue_virus_btv |
text |
|
|
|
|
|
|
|
bvdv_elisa_bovine_viral_diarrhea_virus_bvdv |
text |
|
|
|
|
|
|
|
caev_elisa_caprine_arthritis_encephalitis_virus_caev_maed_visna |
text |
|
|
|
|
|
|
|
capillaria_capillaria |
integer |
|
|
|
|
|
|
|
capillaria_nematoda |
integer |
|
|
|
|
|
|
|
chlamydia_pcr_ecvag_chlamydiaceae |
text |
|
|
|
|
|
|
|
chlamydia_pcr_feces_chlamydiaceae |
text |
|
|
|
|
|
|
|
chlamydia_pcr_num_chlamydiaceae |
text |
|
|
|
|
|
|
|
chlamydia_pcr_serum_chlamydiaceae |
text |
|
|
|
|
|
|
|
chlamydia_pcr_serum_chlamydia_pecorum |
text |
|
|
|
|
|
|
|
chlamydia_pcr_serum_chlamydia_psittaci |
text |
|
|
|
|
|
|
|
chlamydia_pcr_serum_chlamydia_suis |
text |
|
|
|
|
|
|
|
chlamydia_pcr_serum_chlamydophila_abortus |
text |
|
|
|
|
|
|
|
chlamydophila_elisa_chlamydophila_abortus |
text |
|
|
|
|
|
|
|
coccidies_boleen_coccidia |
text |
|
|
|
|
|
|
|
coccidies_quantitatif_coccidia |
integer |
|
|
|
|
|
|
|
coccidies_quantitatif_plus_coccidia |
text |
|
|
|
|
|
|
|
dicrocoelium_lanceolatum_dicrocoelium_lanceolatum |
text |
|
|
|
|
|
|
|
dictyocaules_dictyocaulus |
text |
|
|
|
|
|
|
|
fievreq_elisa_coxiella_burnetii |
text |
|
|
|
|
|
|
|
fievreq_pcr_coxiella_burnetii |
text |
|
|
|
|
|
|
|
gene_18s_babesia_bigemina |
text |
|
|
|
|
|
|
|
gene_18s_babesia_canis_subsp_canis |
text |
|
|
|
|
|
|
|
gene_18s_babesia_ovis |
text |
|
|
|
|
|
|
|
gene_18s_babesia_venatorum |
text |
|
|
|
|
|
|
|
gene_18s_theileria_annulata |
text |
|
|
|
|
|
|
|
gene_23s_borrelia_spp |
text |
|
|
|
|
|
|
|
gene_btq_bartonella_quintana |
text |
|
|
|
|
|
|
|
gene_ccteta_babesia_bovis |
text |
|
|
|
|
|
|
|
gene_ccteta_babesia_major |
text |
|
|
|
|
|
|
|
gene_ccteta_babesia_microti |
text |
|
|
|
|
|
|
|
gene_dsb_ehrlichia_chaffeensis |
text |
|
|
|
|
|
|
|
gene_dsb_ehrlichia_ruminantium |
text |
|
|
|
|
|
|
|
gene_ema1r2_theileria_equi |
text |
|
|
|
|
|
|
|
gene_fla_borrelia_afzelii |
text |
|
|
|
|
|
|
|
gene_fla_borrelia_spielmanii |
text |
|
|
|
|
|
|
|
gene_fopa_francisella_tularensis |
text |
|
|
|
|
|
|
|
gene_glpq_borrelia_miyamotoi |
text |
|
|
|
|
|
|
|
gene_glta_rickettsia_spotted_fever_group |
text |
|
|
|
|
|
|
|
gene_groel_anaplasma_bovis |
text |
|
|
|
|
|
|
|
gene_groel_anaplasma_centrale |
text |
|
|
|
|
|
|
|
gene_groel_anaplasma_platys |
text |
|
|
|
|
|
|
|
gene_groel_candidatus_neoehrlichia_mikurensis |
text |
|
|
|
|
|
|
|
gene_hsp70_babesia_canis_subsp_vogeli |
text |
|
|
|
|
|
|
|
gene_hsp70_babesia_divergens_ou_babesia_capreoli |
text |
|
|
|
|
|
|
|
gene_icd_coxiella_burnetii |
text |
|
|
|
|
|
|
|
gene_is1111_coxiella_burnetii |
text |
|
|
|
|
|
|
|
gene_its_rickettsia_aeschlimannii |
text |
|
|
|
|
|
|
|
gene_its_rickettsia_conorii |
text |
|
|
|
|
|
|
|
gene_its_rickettsia_helvetica |
text |
|
|
|
|
|
|
|
gene_its_rickettsia_massiliae |
text |
|
|
|
|
|
|
|
gene_its_rickettsia_slovaca |
text |
|
|
|
|
|
|
|
gene_msp1_anaplasma_marginale |
text |
|
|
|
|
|
|
|
gene_msp2_anaplasma_phagocytophilum |
text |
|
|
|
|
|
|
|
gene_msp4_anaplasma_ovis |
text |
|
|
|
|
|
|
|
gene_ospa_borrelia_valaisiana |
text |
|
|
|
|
|
|
|
gene_pap31_bartonella_henselae |
text |
|
|
|
|
|
|
|
gene_rap1_babesia_caballi |
text |
|
|
|
|
|
|
|
gene_rpob_borrelia_bissettii |
text |
|
|
|
|
|
|
|
gene_rpob_borrelia_burgdorferi_sensu_stricto |
text |
|
|
|
|
|
|
|
gene_rpob_borrelia_garinii |
text |
|
|
|
|
|
|
|
gene_rpob_borrelia_lusitaniae |
text |
|
|
|
|
|
|
|
gene_tul4_francisella_tularensis |
text |
|
|
|
|
|
|
|
haemonchus_contortus_haemonchus_contortus |
text |
|
|
|
|
|
|
|
ibr_elisa_infectious_bovine_rhinotracheitis_ibr_bovine_herpesvi |
text |
|
|
|
|
|
|
|
moniezia_boleen_moniezia |
text |
|
|
|
|
|
|
|
moniezia_quantitatif_moniezia |
integer |
|
|
|
|
|
|
|
moniezia_quantitatif_plus_moniezia |
text |
|
|
|
|
|
|
|
mycoplasma_elisa_mycoplasma_agalactiae |
text |
|
|
|
|
|
|
|
nematodirus_nematodirus |
integer |
|
|
|
|
|
|
|
neospora_elisa_neospora_caninum |
text |
|
|
|
|
|
|
|
oxyures_oxyuris |
text |
|
|
|
|
|
|
|
paratub_elisa_mycobacterium_avium_subsp_paratuberculosis |
text |
|
|
|
|
|
|
|
recomline_chlamydia_chlamydia_pneumoniae |
text |
|
|
|
|
|
|
|
recomline_chlamydia_chlamydia_psittaci |
text |
|
|
|
|
|
|
|
recomline_chlamydia_chlamydia_trachomatis |
text |
|
|
|
|
|
|
|
salmonella_seroagglutination_salmonella_enterica_subsp_enterica |
text |
|
|
|
|
|
|
|
schmallenberg_elisa_schmallenberg_virus |
text |
|
|
|
|
|
|
|
strongles_gastro_intestinaux_strongylida |
integer |
|
|
|
|
|
|
|
strongles_tot_secernentea |
integer |
|
|
|
|
|
|
|
strongyloides_strongyloidea |
integer |
|
|
|
|
|
|
|
strongyloides_strongyloides_papillosus |
integer |
|
|
|
|
|
|
|
tiques_ixodida |
text |
|
|
|
|
|
|
|
toxo_elisa_toxoplasma_gondii |
text |
|
|
|
|
|
|
|
trichure_trichuris_ovis |
integer |
|
|
|
|
|
|
|
trichurides_tot_trichuridae |
integer |
|
|
|
|
|
|
|
expar_cap_id |
integer |
|
|
|
|
|
|
|
expar_cap_bague |
varchar(12) |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table t_para_expar
Check Constraints
There are no check constraints for table t_para_expar
Indices
There are no indices for table t_para_expar
Triggers
There are no triggers for table t_para_expar
Rules
There are no rules for table t_para_expar
Policies
There are no policies for table t_para_expar
Referenced
There are no tables referenced by table t_para_expar
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
475 |
Pages |
32 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE para_phy.t_para_expar (
expar_ani_cpt TEXT,
expar_ani_etiq TEXT,
adhs_dilution_neospora_caninum TEXT,
adhs_dilution_toxoplasma_gondii TEXT,
adhs_titre_neospora_caninum TEXT,
adhs_titre_toxoplasma_gondii TEXT,
anaplasma_pcr_anaplasma_phagocytophilum TEXT,
babesia_digestion_clai_hinfi_babesia_capreoli TEXT,
babesia_digestion_clai_hinfi_babesia_venatorum TEXT,
babesia_pcr_babesia TEXT,
babesia_sequence_babesia_capreoli TEXT,
bartonella_schoenbuchensi_bacteraemia_bartonella_schoenbuchensi TEXT,
bartonella_schoenbuchensi_boleen_bartonella_schoenbuchensis TEXT,
brucellose_pcr_brucella_abortus TEXT,
btv_elisa_blue_tongue_virus_btv TEXT,
bvdv_elisa_bovine_viral_diarrhea_virus_bvdv TEXT,
caev_elisa_caprine_arthritis_encephalitis_virus_caev_maed_visna TEXT,
capillaria_capillaria INTEGER,
capillaria_nematoda INTEGER,
chlamydia_pcr_ecvag_chlamydiaceae TEXT,
chlamydia_pcr_feces_chlamydiaceae TEXT,
chlamydia_pcr_num_chlamydiaceae TEXT,
chlamydia_pcr_serum_chlamydiaceae TEXT,
chlamydia_pcr_serum_chlamydia_pecorum TEXT,
chlamydia_pcr_serum_chlamydia_psittaci TEXT,
chlamydia_pcr_serum_chlamydia_suis TEXT,
chlamydia_pcr_serum_chlamydophila_abortus TEXT,
chlamydophila_elisa_chlamydophila_abortus TEXT,
coccidies_boleen_coccidia TEXT,
coccidies_quantitatif_coccidia INTEGER,
coccidies_quantitatif_plus_coccidia TEXT,
dicrocoelium_lanceolatum_dicrocoelium_lanceolatum TEXT,
dictyocaules_dictyocaulus TEXT,
fievreq_elisa_coxiella_burnetii TEXT,
fievreq_pcr_coxiella_burnetii TEXT,
gene_18s_babesia_bigemina TEXT,
gene_18s_babesia_canis_subsp_canis TEXT,
gene_18s_babesia_ovis TEXT,
gene_18s_babesia_venatorum TEXT,
gene_18s_theileria_annulata TEXT,
gene_23s_borrelia_spp TEXT,
gene_btq_bartonella_quintana TEXT,
gene_ccteta_babesia_bovis TEXT,
gene_ccteta_babesia_major TEXT,
gene_ccteta_babesia_microti TEXT,
gene_dsb_ehrlichia_chaffeensis TEXT,
gene_dsb_ehrlichia_ruminantium TEXT,
gene_ema1r2_theileria_equi TEXT,
gene_fla_borrelia_afzelii TEXT,
gene_fla_borrelia_spielmanii TEXT,
gene_fopa_francisella_tularensis TEXT,
gene_glpq_borrelia_miyamotoi TEXT,
gene_glta_rickettsia_spotted_fever_group TEXT,
gene_groel_anaplasma_bovis TEXT,
gene_groel_anaplasma_centrale TEXT,
gene_groel_anaplasma_platys TEXT,
gene_groel_candidatus_neoehrlichia_mikurensis TEXT,
gene_hsp70_babesia_canis_subsp_vogeli TEXT,
gene_hsp70_babesia_divergens_ou_babesia_capreoli TEXT,
gene_icd_coxiella_burnetii TEXT,
gene_is1111_coxiella_burnetii TEXT,
gene_its_rickettsia_aeschlimannii TEXT,
gene_its_rickettsia_conorii TEXT,
gene_its_rickettsia_helvetica TEXT,
gene_its_rickettsia_massiliae TEXT,
gene_its_rickettsia_slovaca TEXT,
gene_msp1_anaplasma_marginale TEXT,
gene_msp2_anaplasma_phagocytophilum TEXT,
gene_msp4_anaplasma_ovis TEXT,
gene_ospa_borrelia_valaisiana TEXT,
gene_pap31_bartonella_henselae TEXT,
gene_rap1_babesia_caballi TEXT,
gene_rpob_borrelia_bissettii TEXT,
gene_rpob_borrelia_burgdorferi_sensu_stricto TEXT,
gene_rpob_borrelia_garinii TEXT,
gene_rpob_borrelia_lusitaniae TEXT,
gene_tul4_francisella_tularensis TEXT,
haemonchus_contortus_haemonchus_contortus TEXT,
ibr_elisa_infectious_bovine_rhinotracheitis_ibr_bovine_herpesvi TEXT,
moniezia_boleen_moniezia TEXT,
moniezia_quantitatif_moniezia INTEGER,
moniezia_quantitatif_plus_moniezia TEXT,
mycoplasma_elisa_mycoplasma_agalactiae TEXT,
nematodirus_nematodirus INTEGER,
neospora_elisa_neospora_caninum TEXT,
oxyures_oxyuris TEXT,
paratub_elisa_mycobacterium_avium_subsp_paratuberculosis TEXT,
recomline_chlamydia_chlamydia_pneumoniae TEXT,
recomline_chlamydia_chlamydia_psittaci TEXT,
recomline_chlamydia_chlamydia_trachomatis TEXT,
salmonella_seroagglutination_salmonella_enterica_subsp_enterica TEXT,
schmallenberg_elisa_schmallenberg_virus TEXT,
strongles_gastro_intestinaux_strongylida INTEGER,
strongles_tot_secernentea INTEGER,
strongyloides_strongyloidea INTEGER,
strongyloides_strongyloides_papillosus INTEGER,
tiques_ixodida TEXT,
toxo_elisa_toxoplasma_gondii TEXT,
trichure_trichuris_ovis INTEGER,
trichurides_tot_trichuridae INTEGER,
expar_cap_id INTEGER,
expar_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 |