[GeolLLibre] Re: BD => plan général
- From: Pierre Chevalier Géologue <pierrechevaliergeol@xxxxxxx>
- To: geolllibre@xxxxxxxxxx
- Date: Fri, 08 Jan 2010 19:39:13 +0100
Pierre Chevalier Géologue claviota:
Continuons le boulot. /*...*/ notre base de données géologique (qui a,
pour le moment, une *très* forte connotation exploration minière
La suite, donc. On va essayer d'accélérer, donc ça va être moins
didactique. Vraiment moins.
Voilà où j'en suis de l'implémentation, en PostgreSQL, de la bd en question.
Ceci vient de la commande suivante (ça se fait depuis un shell bash,
celui qui sait faire pareil sous window$ est prié de dire comment):
pg_dump bdexplo -s > sauvg_bdexplo_structure_`date +%Y_%m_%d_%Hh%M`.sql
Ensuite expurgée de pas mal de superflu, pour pas noyer tout le monde
dans des détails pas vraiment fondamentaux.
Pour le moment, tout est dans le schéma public, et le proprio, c'est ma
pomme, soit l'utilisateur postgresql "pierre". Il va de soi qu'il faudra
adapter ça.
Pour restaurer ça, il faut faire comme suit (c'est pas du chiqué, c'est
un vrai copié-collé de ce que je viens de faire, pour de vrai):
pierre@duran:/tmp$ echo "CREATE DATABASE test WITH
TEMPLATE=template_postgis ENCODING='UTF8'OWNER=pierre;" | psql
CREATE DATABASE
pierre@duran:/tmp$ psql test -f
sauvg_bdexplo_structure_2010_01_08_18h32_corr.sql &> erreurs
pierre@duran:/tmp$ less erreurs
La dernière commande, c'est juste pour regarder les messages d'erreurs
et messages d'informations éventuels renvoyés lors de la restauration.
Et au final, on obtient une coquille vide, avec la structure de la bd.
Pour voir ça, on ouvre un psql, la console à tout faire de PostgreSQL:
pierre@duran:/tmp$ psql test
Bienvenue dans psql 8.3.9, l'interface interactive de PostgreSQL.
Saisissez:
\copyright pour les termes de distribution
\h pour l'aide-mémoire des commandes SQL
\? pour l'aide-mémoire des commandes psql
\g ou point-virgule en fin d'instruction pour exécuter la requête
\q pour quitter
test=> \dt+
Liste des relations
Schéma | Nom | Type | Propriétaire
|
Description
--------+---------------------+-------+--------------+---------------------------------------------------------------------------------------------------------
public | ana_batch | table | pierre | Batches of
samples sent for analysis
public | ana_results | table | pierre | Assay
results, from amc_2008_08 database, and from files sent by Marc_Barbut
public | dh_collars | table | pierre | Drill holes
collars or trenches starting points
public | dh_collars_program | table | pierre |
public | dh_devia | table | pierre | Drill holes
deviation measurements
public | dh_litho | table | pierre | Drill holes
or trenches geological descriptions
public | dh_mine | table | pierre |
Mineralisation: stretch values over mineralised intervals
public | dh_sampling | table | pierre | Samples along
drill holes and trenches
public | dh_struct | table | pierre | Structures
along drill holes and trenches
public | dh_tech | table | pierre | technical
drilling data
public | geoch_ana | table | pierre | analysis
values of geoch_sampling table
public | geoch_sampling | table | pierre | location and
description of the geochemical samples
public | geometry_columns | table | postgres |
public | grade_ctrl | table | pierre | sampling data
made during mining exploitation
public | lab_ana_results | table | pierre | Laboratory
results table, after laboratory instructions, related to LIMS system
public | lex_directory | table | pierre | Look-up table
of datasources, directories and files
public | lex_drill_hole_type | table | pierre | Drill hole
type lexicon
public | lex_labo_analysis | table | pierre | Look_up
table, chemical analysis laboratories
public | lex_laboratory | table | pierre |
public | lex_litho | table | pierre |
public | licences | table | pierre | Licences,
tenements
public | locations | table | pierre | Zones,
prospects code, rectangle
public | occurrences | table | pierre | Occurences
table: targets, mines, showings, deposits, mines. Compiled from various
tables, and updated.
public | operations | table | pierre | Operations,
projects, operator or client name
public | qc_sampling | table | pierre |
public | qc_standards | table | pierre | samples
description used for the quality control
public | rock_ana | table | pierre |
public | rock_sampling | table | pierre | outcrop
sampling (taken with geological hammer)
public | shift_reports | table | pierre |
public | spatial_ref_sys | table | postgres |
(30 lignes)
test=>
Et voilà. Yapuka.
Rémi: te voilà maintenant pourvu de la structure de la bd, tel que je
travaille dessus en même temps. Tu noteras qu'il y a quelques traces
d'un héritage: ces traces disparaîtront dans le futur, au fur et à
mesure que la situation s'assainira.
Une précision: ça n'aura pas échappé aux autres, on bosse, en réel, sur
une base de données d'explo minière, Rémi et ma pomme.
JS: tu vas reconnaître pas mal de choses! Vu que tu es l'auteur de pas
mal de ces choses-là, /Redde Caesari/ quae sunt /Caesaris, comme il se
doit. Tu noteras également pas mal d'évolutions.../
A+
Pierre
--
____________________________________________________________________________
Pierre Chevalier Géologue EI
Mesté Duran
32100 Condom
Tél+fax : 09 75 27 45 62
05 62 28 06 83
06 37 80 33 64
Émail : pierrechevaliergeolCHEZfree.fr
icq# : 10432285
skype : pierre.chevalier1967
http://pierremariechevalier.free.fr/pierre_chevalier_geologue
____________________________________________________________________________
--
-- Name: ana_batch; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE ana_batch (
batch_id text,
expedition_id character varying(20),
da character varying(20),
analytical_labo character varying(50),
process_labo character varying(10),
scheme character varying,
shipment_date date,
sent_to_labo boolean,
labo_batch character varying(20),
reception_date date,
results_received boolean,
scheme2 character varying,
numbidon integer,
comments character varying(254),
preparation character varying(10),
datasource character varying
);
ALTER TABLE public.ana_batch OWNER TO pierre;
--
-- Name: TABLE ana_batch; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE ana_batch IS 'Batches of samples sent for analysis';
--
-- Name: ana_results; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE ana_results (
sample_id character varying(20),
labo character varying(50),
scheme character varying,
ana_type character varying(20),
unit character varying,
value numeric,
det_lim numeric,
splidx08 integer,
numauto08 integer,
datasource character varying,
ticket_id character varying,
ident character varying,
ident_modif character varying
);
ALTER TABLE public.ana_results OWNER TO pierre;
--
-- Name: TABLE ana_results; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE ana_results IS 'Assay results, from amc_2008_08 database, and
from files sent by Marc_Barbut';
--
-- Name: COLUMN ana_results.splidx08; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN ana_results.splidx08 IS 'historique_amc_2008_08_sampl_index';
--
-- Name: COLUMN ana_results.numauto08; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN ana_results.numauto08 IS
'historique_amc_2008_08_dh_ana_numauto';
--
-- Name: dh_collars; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE dh_collars (
operation character varying(4),
id character varying(20) NOT NULL,
shid character varying(10),
location character varying(20),
profile character varying(10),
srid integer,
x numeric(10,2),
y numeric(10,2),
z numeric(10,2),
azim_ng numeric(10,2),
azim_nm numeric(10,2),
dip_hz numeric(10,2),
dh_type character varying(10),
date_start date,
driller character varying(20),
geologist character varying(50),
length numeric(10,2),
len_destr numeric(10,2),
len_pq numeric(10,2),
len_hq numeric(10,2),
len_nq numeric(10,2),
len_bq numeric(10,2),
nb_samples numeric(10,2),
comments character varying(500),
completed boolean,
data_source integer,
numauto integer NOT NULL,
date_completed date
);
ALTER TABLE public.dh_collars OWNER TO pierre;
--
-- Name: TABLE dh_collars; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE dh_collars IS 'Drill holes collars or trenches starting
points';
--
-- Name: COLUMN dh_collars.id; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.id IS 'Full identifier for borehole or trench,
including zone code, type and sequential number';
--
-- Name: COLUMN dh_collars.shid; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.shid IS 'Short identifier: type _ sequential
number';
--
-- Name: COLUMN dh_collars.location; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN dh_collars.location IS 'Investigated area code, see
lex_location look-up table';
--
-- Name: COLUMN dh_collars.profile; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.profile IS 'Profile number';
--
-- Name: COLUMN dh_collars.srid; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.srid IS 'Spatial Reference Identifier, or
coordinate reference system: see spatial_ref_sys from postgis extension';
--
-- Name: COLUMN dh_collars.x; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.x IS 'X coordinate (Easting), in coordinate system
srid';
--
-- Name: COLUMN dh_collars.y; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.y IS 'Y coordinate (Northing), in coordinate
system srid';
--
-- Name: COLUMN dh_collars.z; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.z IS 'Z coordinate';
--
-- Name: COLUMN dh_collars.azim_ng; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.azim_ng IS 'Hole or trench azimuth (°) relative
to geographic North';
--
-- Name: COLUMN dh_collars.azim_nm; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.azim_nm IS 'Hole or trench azimuth (°) relative
to Magnetic North';
--
-- Name: COLUMN dh_collars.dip_hz; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.dip_hz IS 'Drill hole or trench dip relative to
horizontal (°)';
--
-- Name: COLUMN dh_collars.dh_type; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.dh_type IS 'Type: D for Diamond drill hole, R for
RC drill hole, T for Trench, A for Auger drill hole';
--
-- Name: COLUMN dh_collars.date_start; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN dh_collars.date_start IS 'Work start date';
--
-- Name: COLUMN dh_collars.driller; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.driller IS 'Drilling contractor';
--
-- Name: COLUMN dh_collars.geologist; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN dh_collars.geologist IS 'Geologist name';
--
-- Name: COLUMN dh_collars.length; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.length IS 'Total length (m)';
--
-- Name: COLUMN dh_collars.len_destr; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN dh_collars.len_destr IS 'Destructive (percussion or rotary
drilling) length (m)';
--
-- Name: COLUMN dh_collars.len_pq; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.len_pq IS 'Core PQ length (m)';
--
-- Name: COLUMN dh_collars.len_hq; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.len_hq IS 'Core HQ length (m)';
--
-- Name: COLUMN dh_collars.len_nq; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.len_nq IS 'Core NQ length (m)';
--
-- Name: COLUMN dh_collars.len_bq; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_collars.len_bq IS 'Core BQ length (m)';
--
-- Name: COLUMN dh_collars.nb_samples; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN dh_collars.nb_samples IS 'Number of samples';
--
-- Name: COLUMN dh_collars.comments; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN dh_collars.comments IS 'Comments';
--
-- Name: COLUMN dh_collars.completed; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN dh_collars.completed IS 'True: completed; false: planned';
--
-- Name: COLUMN dh_collars.data_source; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN dh_collars.data_source IS 'Data source: filename';
--
-- Name: collars; Type: VIEW; Schema: public; Owner: pierre
--
CREATE VIEW collars AS
SELECT dh_collars.operation, dh_collars.id, dh_collars.shid,
dh_collars.location, dh_collars.profile, dh_collars.srid, dh_collars.x,
dh_collars.y, dh_collars.z, dh_collars.azim_ng, dh_collars.azim_nm,
dh_collars.dip_hz, dh_collars.dh_type, dh_collars.date_start AS start_date,
dh_collars.driller, dh_collars.geologist, dh_collars.length,
dh_collars.len_destr, dh_collars.len_pq, dh_collars.len_hq, dh_collars.len_nq,
dh_collars.len_bq, dh_collars.nb_samples, dh_collars.comments,
dh_collars.completed, dh_collars.data_source, dh_collars.numauto FROM
dh_collars WHERE dh_collars.completed;
ALTER TABLE public.collars OWNER TO pierre;
--
-- Name: dh_collars_points_20136; Type: VIEW; Schema: public; Owner: pierre
--
CREATE VIEW dh_collars_points_20136 AS
SELECT dh_collars.operation, dh_collars.id, dh_collars.shid,
dh_collars.location, dh_collars.profile, dh_collars.srid, dh_collars.x,
dh_collars.y, dh_collars.z, dh_collars.azim_ng, dh_collars.azim_nm,
dh_collars.dip_hz, dh_collars.dh_type, dh_collars.date_start AS start_date,
dh_collars.driller, dh_collars.geologist, dh_collars.length,
dh_collars.len_destr, dh_collars.len_pq, dh_collars.len_hq, dh_collars.len_nq,
dh_collars.len_bq, dh_collars.nb_samples, dh_collars.comments,
dh_collars.completed, dh_collars.data_source, dh_collars.numauto,
geomfromewkt((((((((('SRID='::text || dh_collars.srid) || ';POINT('::text) ||
dh_collars.x) || ' '::text) || dh_collars.y) || ' '::text) || dh_collars.z) ||
')'::text)) AS geomfromewkt FROM dh_collars WHERE (dh_collars.srid = 20136);
ALTER TABLE public.dh_collars_points_20136 OWNER TO pierre;
--
-- Name: collars_selection; Type: VIEW; Schema: public; Owner: pierre
--
CREATE VIEW collars_selection AS
SELECT dh_collars_points_20136.operation, dh_collars_points_20136.id,
dh_collars_points_20136.shid, dh_collars_points_20136.location,
dh_collars_points_20136.profile, dh_collars_points_20136.srid,
dh_collars_points_20136.x, dh_collars_points_20136.y,
dh_collars_points_20136.z, dh_collars_points_20136.azim_ng,
dh_collars_points_20136.azim_nm, dh_collars_points_20136.dip_hz,
dh_collars_points_20136.dh_type, dh_collars_points_20136.start_date,
dh_collars_points_20136.driller, dh_collars_points_20136.geologist,
dh_collars_points_20136.length, dh_collars_points_20136.len_destr,
dh_collars_points_20136.len_pq, dh_collars_points_20136.len_hq,
dh_collars_points_20136.len_nq, dh_collars_points_20136.len_bq,
dh_collars_points_20136.nb_samples, dh_collars_points_20136.comments,
dh_collars_points_20136.completed, dh_collars_points_20136.data_source,
dh_collars_points_20136.numauto, dh_collars_points_20136.geomfromewkt FROM
dh_collars_points_20136 WHERE ((((dh_collars_points_20136.id)::text ~~*
'UMA_PDH%'::text) OR ((dh_collars_points_20136.dh_type)::text = 'P'::text)) AND
((dh_collars_points_20136.id)::text ~~* 'UMA%01'::text)) ORDER BY
dh_collars_points_20136.id;
ALTER TABLE public.collars_selection OWNER TO pierre;
--
-- Name: dh_collars_points_20137; Type: VIEW; Schema: public; Owner: pierre
--
CREATE VIEW dh_collars_points_20137 AS
SELECT dh_collars.operation, dh_collars.id, dh_collars.shid,
dh_collars.location, dh_collars.profile, dh_collars.srid, dh_collars.x,
dh_collars.y, dh_collars.z, dh_collars.azim_ng, dh_collars.azim_nm,
dh_collars.dip_hz, dh_collars.dh_type, dh_collars.date_start AS start_date,
dh_collars.driller, dh_collars.geologist, dh_collars.length,
dh_collars.len_destr, dh_collars.len_pq, dh_collars.len_hq, dh_collars.len_nq,
dh_collars.len_bq, dh_collars.nb_samples, dh_collars.comments,
dh_collars.completed, dh_collars.data_source, dh_collars.numauto,
geomfromewkt((((((((('SRID='::text || dh_collars.srid) || ';POINT('::text) ||
dh_collars.x) || ' '::text) || dh_collars.y) || ' '::text) || dh_collars.z) ||
')'::text)) AS geomfromewkt FROM dh_collars WHERE (dh_collars.srid = 20137);
ALTER TABLE public.dh_collars_points_20137 OWNER TO pierre;
--
-- Name: dh_collars_program; Type: TABLE; Schema: public; Owner: pierre;
Tablespace:
--
CREATE TABLE dh_collars_program (
id character varying(20),
location character varying(20),
srid integer,
x numeric(10,2),
y numeric(10,2),
z numeric(10,2),
azim_ng numeric(10,2),
dip_hz numeric(10,2),
dh_type character varying(10),
length numeric(10,2),
comments character varying(500),
completed boolean
);
ALTER TABLE public.dh_collars_program OWNER TO pierre;
--
-- Name: dh_devia; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE dh_devia (
id character varying(20),
depto numeric(10,2),
azim_nm numeric(10,2),
dip_hz numeric(10,2),
temperature numeric(10,2),
magnetic numeric(10,2),
dip_vert numeric(10,2),
azim_mag numeric(10,2),
numauto integer NOT NULL,
date date,
roll numeric(10,2),
"time" integer,
comments character varying(254),
directory_index integer
);
ALTER TABLE public.dh_devia OWNER TO pierre;
--
-- Name: TABLE dh_devia; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE dh_devia IS 'Drill holes deviation measurements';
--
-- Name: COLUMN dh_devia.id; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_devia.id IS 'Drill hole identification related to the
collars table';
--
-- Name: COLUMN dh_devia.depto; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_devia.depto IS 'depth';
--
-- Name: COLUMN dh_devia.azim_nm; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_devia.azim_nm IS 'Hole azimuth (°) relative to magnetic
North (?)';
--
-- Name: COLUMN dh_devia.dip_hz; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_devia.dip_hz IS 'Drill hole dip relative to horizontal
(°)';
--
-- Name: COLUMN dh_devia.temperature; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN dh_devia.temperature IS 'temperature';
--
-- Name: COLUMN dh_devia.magnetic; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_devia.magnetic IS 'if there is magnetical changes';
--
-- Name: COLUMN dh_devia.dip_vert; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_devia.dip_vert IS 'Drill holedip relative to vertical
(°)';
--
-- Name: COLUMN dh_devia.azim_mag; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_devia.azim_mag IS 'Hole or trench azimuth (°) relative to
magnetic North (?)';
--
-- Name: COLUMN dh_devia.numauto; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_devia.numauto IS 'Auto increment integer';
--
-- Name: dh_litho; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE dh_litho (
id character varying(20),
depfrom numeric(10,2),
depto numeric(10,2),
description character varying,
code1 character varying(4),
code2 character varying(4),
code3 character varying(4),
code4 character varying(4),
value1 integer,
value2 integer,
value3 integer,
value4 integer
);
ALTER TABLE public.dh_litho OWNER TO pierre;
--
-- Name: TABLE dh_litho; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE dh_litho IS 'Drill holes or trenches geological descriptions';
--
-- Name: COLUMN dh_litho.id; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_litho.id IS 'Identifier, refers to dh_collars';
--
-- Name: COLUMN dh_litho.depfrom; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_litho.depfrom IS 'Interval beginning depth';
--
-- Name: COLUMN dh_litho.depto; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_litho.depto IS 'Interval ending depth';
--
-- Name: COLUMN dh_litho.description; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN dh_litho.description IS 'Geological description, naturalist
style';
--
-- Name: COLUMN dh_litho.code1; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_litho.code1 IS 'Lithology code, 4 characters, uppercase';
--
-- Name: COLUMN dh_litho.code2; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_litho.code2 IS 'Supergene oxidation';
--
-- Name: COLUMN dh_litho.code3; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_litho.code3 IS 'Stratigraphy code, 4 characters,
uppercase';
--
-- Name: COLUMN dh_litho.value1; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_litho.value1 IS 'Sermine code';
--
-- Name: COLUMN dh_litho.value2; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_litho.value2 IS 'Water presence in drill hole';
--
-- Name: COLUMN dh_litho.value3; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_litho.value3 IS 'Alteration intensity, semi-quantitative,
0 to 4';
--
-- Name: COLUMN dh_litho.value4; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_litho.value4 IS 'Moisture, as seen from RC chips';
--
-- Name: dh_litho_custom; Type: VIEW; Schema: public; Owner: pierre
--
CREATE VIEW dh_litho_custom AS
SELECT dh_litho.id, dh_litho.depfrom, dh_litho.depto, dh_litho.code1 AS
codelitho, dh_litho.code2 AS codestrati, dh_litho.description, dh_litho.code3
AS oxidation, dh_litho.value1 AS deformation, dh_litho.value2 AS alteration,
dh_litho.code4 AS water FROM dh_litho;
ALTER TABLE public.dh_litho_custom OWNER TO pierre;
--
-- Name: dh_mine; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE dh_mine (
id character varying(20),
depfrom numeric(10,2),
depto numeric(10,2),
mine integer DEFAULT 1,
avau numeric(10,2),
stva character varying(150),
accu numeric(10,2),
recu numeric(10,2),
dens numeric(10,2),
directory_index character varying(500),
numauto integer NOT NULL,
comments character varying(100)
);
ALTER TABLE public.dh_mine OWNER TO pierre;
--
-- Name: TABLE dh_mine; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE dh_mine IS 'Mineralisation: stretch values over mineralised
intervals';
--
-- Name: COLUMN dh_mine.id; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_mine.id IS 'Full identifier for borehole or trench';
--
-- Name: COLUMN dh_mine.depfrom; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_mine.depfrom IS 'Mineralised interval starting depth';
--
-- Name: COLUMN dh_mine.depto; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_mine.depto IS 'Mineralised interval ending depth';
--
-- Name: COLUMN dh_mine.mine; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_mine.mine IS 'Take-out interval class: 1=normal interval,
2=high-grade interval ';
--
-- Name: COLUMN dh_mine.avau; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_mine.avau IS 'Average grade (g/t)';
--
-- Name: COLUMN dh_mine.stva; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_mine.stva IS 'Stretch value, X m at Y g/t';
--
-- Name: COLUMN dh_mine.accu; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_mine.accu IS 'Accumulation in m.g/t over mineralised
interval';
--
-- Name: COLUMN dh_mine.recu; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_mine.recu IS 'recovery';
--
-- Name: COLUMN dh_mine.dens; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_mine.dens IS 'density';
--
-- Name: COLUMN dh_mine.directory_index; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN dh_mine.directory_index IS 'original file directory';
--
-- Name: dh_sampling; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE dh_sampling (
id character varying(20),
depfrom numeric(10,2),
depto numeric(10,2),
core_loss_cm character varying(20),
weight_kg numeric,
density numeric,
sample_type character varying(8),
sample_id character varying(20),
batch_id character varying(20),
num08 character varying(50),
nb09 character varying(50),
splidx08 integer,
splidx09 integer,
directory_index integer,
datasource character varying,
comments character varying
);
ALTER TABLE public.dh_sampling OWNER TO pierre;
--
-- Name: TABLE dh_sampling; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE dh_sampling IS 'Samples along drill holes and trenches';
--
-- Name: dh_struct; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE dh_struct (
id character varying(20),
depto numeric(10,2),
sos1ac numeric(10,2),
numauto integer NOT NULL,
struct_type character varying(20),
strike character varying(20),
directory_index integer
);
ALTER TABLE public.dh_struct OWNER TO pierre;
--
-- Name: TABLE dh_struct; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE dh_struct IS 'Structures along drill holes and trenches';
--
-- Name: dh_tech; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE dh_tech (
id character varying(20),
depfrom numeric(10,2),
depto numeric(10,2),
drilled_len numeric(10,2),
reco_len numeric(10,2),
percent_reco numeric(5,2),
rqd_len numeric(10,2),
percent_rqd numeric(5,2),
diam character varying(10),
thick numeric(10,2),
numauto integer NOT NULL,
directory_index integer
);
ALTER TABLE public.dh_tech OWNER TO pierre;
--
-- Name: TABLE dh_tech; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE dh_tech IS 'technical drilling data';
--
-- Name: COLUMN dh_tech.id; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_tech.id IS 'Drill hole identification';
--
-- Name: COLUMN dh_tech.depfrom; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_tech.depfrom IS 'Interval begining depth';
--
-- Name: COLUMN dh_tech.depto; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_tech.depto IS 'Interval ending depth';
--
-- Name: COLUMN dh_tech.drilled_len; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN dh_tech.drilled_len IS 'Interval length';
--
-- Name: COLUMN dh_tech.reco_len; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_tech.reco_len IS 'Recovery length';
--
-- Name: COLUMN dh_tech.percent_reco; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN dh_tech.percent_reco IS 'Recovery (%)';
--
-- Name: COLUMN dh_tech.rqd_len; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_tech.rqd_len IS 'Rock Quality Designation "length"';
--
-- Name: COLUMN dh_tech.percent_rqd; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN dh_tech.percent_rqd IS 'RQD (%)';
--
-- Name: COLUMN dh_tech.diam; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_tech.diam IS 'core diameter';
--
-- Name: COLUMN dh_tech.thick; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN dh_tech.thick IS 'thickness';
--
-- Name: dh_traces_3d_20136; Type: VIEW; Schema: public; Owner: pierre
--
CREATE VIEW dh_traces_3d_20136 AS
SELECT tmp.operation, tmp.id, tmp.shid, tmp.location, tmp.profile,
tmp.srid, tmp.x, tmp.y, tmp.z, tmp.azim_ng, tmp.azim_nm, tmp.dip_hz,
tmp.dh_type, tmp.start_date, tmp.driller, tmp.geologist, tmp.length,
tmp.len_destr, tmp.len_pq, tmp.len_hq, tmp.len_nq, tmp.len_bq, tmp.nb_samples,
tmp.comments, tmp.completed, tmp.data_source, tmp.numauto, tmp.x1, tmp.y1,
tmp.z1, geomfromewkt((((((((((((((('SRID='::text || tmp.srid) || ';LINESTRING
('::text) || tmp.x) || ' '::text) || tmp.y) || ' '::text) || tmp.z) || ',
'::text) || tmp.x1) || ' '::text) || tmp.y1) || ' '::text) || tmp.z1) ||
')'::text)) AS geomfromewkt FROM (SELECT dh_collars.operation, dh_collars.id,
dh_collars.shid, dh_collars.location, dh_collars.profile, dh_collars.srid,
dh_collars.x, dh_collars.y, dh_collars.z, dh_collars.azim_ng,
dh_collars.azim_nm, dh_collars.dip_hz, dh_collars.dh_type,
dh_collars.date_start AS start_date, dh_collars.driller, dh_collars.geologist,
dh_collars.length, dh_collars.len_destr, dh_collars.len_pq, dh_collars.len_hq,
dh_collars.len_nq, dh_collars.len_bq, dh_collars.nb_samples,
dh_collars.comments, dh_collars.completed, dh_collars.data_source,
dh_collars.numauto, ((dh_collars.x)::double precision +
(((dh_collars.length)::double precision * cos((((dh_collars.dip_hz /
(180)::numeric))::double precision * pi()))) * sin((((dh_collars.azim_ng /
(180)::numeric))::double precision * pi())))) AS x1, ((dh_collars.y)::double
precision + (((dh_collars.length)::double precision * cos((((dh_collars.dip_hz
/ (180)::numeric))::double precision * pi()))) * cos((((dh_collars.azim_ng /
(180)::numeric))::double precision * pi())))) AS y1, ((dh_collars.z)::double
precision - ((dh_collars.length)::double precision * sin((((dh_collars.dip_hz /
(180)::numeric))::double precision * pi())))) AS z1 FROM dh_collars WHERE
(dh_collars.srid = 20136)) tmp ORDER BY tmp.id;
ALTER TABLE public.dh_traces_3d_20136 OWNER TO pierre;
--
-- Name: dh_traces_3d_20137; Type: VIEW; Schema: public; Owner: pierre
--
CREATE VIEW dh_traces_3d_20137 AS
SELECT tmp.operation, tmp.id, tmp.shid, tmp.location, tmp.profile,
tmp.srid, tmp.x, tmp.y, tmp.z, tmp.azim_ng, tmp.azim_nm, tmp.dip_hz,
tmp.dh_type, tmp.start_date, tmp.driller, tmp.geologist, tmp.length,
tmp.len_destr, tmp.len_pq, tmp.len_hq, tmp.len_nq, tmp.len_bq, tmp.nb_samples,
tmp.comments, tmp.completed, tmp.data_source, tmp.numauto, tmp.x1, tmp.y1,
tmp.z1, geomfromewkt((((((((((((((('SRID='::text || tmp.srid) || ';LINESTRING
('::text) || tmp.x) || ' '::text) || tmp.y) || ' '::text) || tmp.z) || ',
'::text) || tmp.x1) || ' '::text) || tmp.y1) || ' '::text) || tmp.z1) ||
')'::text)) AS geomfromewkt FROM (SELECT dh_collars.operation, dh_collars.id,
dh_collars.shid, dh_collars.location, dh_collars.profile, dh_collars.srid,
dh_collars.x, dh_collars.y, dh_collars.z, dh_collars.azim_ng,
dh_collars.azim_nm, dh_collars.dip_hz, dh_collars.dh_type,
dh_collars.date_start AS start_date, dh_collars.driller, dh_collars.geologist,
dh_collars.length, dh_collars.len_destr, dh_collars.len_pq, dh_collars.len_hq,
dh_collars.len_nq, dh_collars.len_bq, dh_collars.nb_samples,
dh_collars.comments, dh_collars.completed, dh_collars.data_source,
dh_collars.numauto, ((dh_collars.x)::double precision +
(((dh_collars.length)::double precision * cos((((dh_collars.dip_hz /
(180)::numeric))::double precision * pi()))) * sin((((dh_collars.azim_ng /
(180)::numeric))::double precision * pi())))) AS x1, ((dh_collars.y)::double
precision + (((dh_collars.length)::double precision * cos((((dh_collars.dip_hz
/ (180)::numeric))::double precision * pi()))) * cos((((dh_collars.azim_ng /
(180)::numeric))::double precision * pi())))) AS y1, ((dh_collars.z)::double
precision - ((dh_collars.length)::double precision * sin((((dh_collars.dip_hz /
(180)::numeric))::double precision * pi())))) AS z1 FROM dh_collars WHERE
(dh_collars.srid = 20137)) tmp ORDER BY tmp.id;
ALTER TABLE public.dh_traces_3d_20137 OWNER TO pierre;
--
-- Name: geoch_ana; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE geoch_ana (
sampl_index integer,
ana_type character varying(20),
unit character varying(10),
det_lim numeric(6,4),
scheme character varying(20),
comment character varying(20),
value numeric(10,3),
numauto integer NOT NULL
);
ALTER TABLE public.geoch_ana OWNER TO pierre;
--
-- Name: TABLE geoch_ana; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE geoch_ana IS 'analysis values of geoch_sampling table';
--
-- Name: COLUMN geoch_ana.sampl_index; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN geoch_ana.sampl_index IS 'Sample identification related to
the geoch_sampling table';
--
-- Name: COLUMN geoch_ana.ana_type; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN geoch_ana.ana_type IS 'Analysis type ';
--
-- Name: COLUMN geoch_ana.unit; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN geoch_ana.unit IS 'Unit of the analysis ';
--
-- Name: COLUMN geoch_ana.det_lim; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN geoch_ana.det_lim IS 'Analysis detection limit';
--
-- Name: COLUMN geoch_ana.scheme; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN geoch_ana.scheme IS 'Analysis method';
--
-- Name: COLUMN geoch_ana.comment; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN geoch_ana.comment IS 'Some comments';
--
-- Name: COLUMN geoch_ana.value; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN geoch_ana.value IS 'Analysis value';
--
-- Name: geoch_sampling; Type: TABLE; Schema: public; Owner: pierre;
Tablespace:
--
CREATE TABLE geoch_sampling (
id character varying(20),
labo character varying(50),
labo_ref character varying(20),
amc_ref character varying(20),
recep_date date,
type character varying(20),
sampl_index integer NOT NULL,
x numeric(15,4),
y numeric(15,4),
z numeric(10,4),
soil_color character varying(50),
type_sort character varying(20),
depth numeric(10,2),
reg_type character varying(20),
hill_interm_low character varying(20),
rock_type character varying(50),
comment character varying(200),
utm_zone character varying(3),
geologist character varying(20),
float_sampl character varying(20),
host_rock character varying(200),
prospect character varying(20),
spacing character varying(20),
horizon character varying(20),
hill character varying(20),
directory_index integer,
date date,
survey_type character varying(50)
);
ALTER TABLE public.geoch_sampling OWNER TO pierre;
--
-- Name: TABLE geoch_sampling; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE geoch_sampling IS 'location and description of the geochemical
samples';
--
-- Name: COLUMN geoch_sampling.id; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN geoch_sampling.id IS 'Identification';
--
-- Name: COLUMN geoch_sampling.labo; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN geoch_sampling.labo IS 'Analysis laboratory';
--
-- Name: COLUMN geoch_sampling.labo_ref; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN geoch_sampling.labo_ref IS 'Analysis laboratory report
reference';
--
-- Name: COLUMN geoch_sampling.amc_ref; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN geoch_sampling.amc_ref IS 'AMC analysis report reference';
--
-- Name: COLUMN geoch_sampling.recep_date; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN geoch_sampling.recep_date IS 'Report reception date by AMC';
--
-- Name: COLUMN geoch_sampling.type; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN geoch_sampling.type IS 'Analysis type';
--
-- Name: COLUMN geoch_sampling.sampl_index; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN geoch_sampling.sampl_index IS 'Auto increment integer';
--
-- Name: COLUMN geoch_sampling.x; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN geoch_sampling.x IS 'X coordinate, projected in UTM (m)';
--
-- Name: COLUMN geoch_sampling.y; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN geoch_sampling.y IS 'Y coordinate, projected in UTM (m)';
--
-- Name: COLUMN geoch_sampling.z; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN geoch_sampling.z IS 'Z coordinate, projected in UTM (m)';
--
-- Name: COLUMN geoch_sampling.soil_color; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN geoch_sampling.soil_color IS 'Soil color';
--
-- Name: COLUMN geoch_sampling.type_sort; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN geoch_sampling.type_sort IS 'Sort of type';
--
-- Name: COLUMN geoch_sampling.depth; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN geoch_sampling.depth IS 'Sample depth';
--
-- Name: COLUMN geoch_sampling.reg_type; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN geoch_sampling.reg_type IS 'Type of region';
--
-- Name: COLUMN geoch_sampling.hill_interm_low; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN geoch_sampling.hill_interm_low IS 'Some region description';
--
-- Name: COLUMN geoch_sampling.rock_type; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN geoch_sampling.rock_type IS 'Lithology';
--
-- Name: COLUMN geoch_sampling.comment; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN geoch_sampling.comment IS 'Some comments';
--
-- Name: COLUMN geoch_sampling.utm_zone; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN geoch_sampling.utm_zone IS 'UTM area';
--
-- Name: COLUMN geoch_sampling.geologist; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN geoch_sampling.geologist IS 'geologist';
--
-- Name: COLUMN geoch_sampling.float_sampl; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN geoch_sampling.float_sampl IS 'sample designation (?)';
--
-- Name: COLUMN geoch_sampling.host_rock; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN geoch_sampling.host_rock IS 'host rock';
--
-- Name: COLUMN geoch_sampling.date; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN geoch_sampling.date IS 'type of survey (ex : HHGPS)';
--
-- Name: grade_ctrl; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE grade_ctrl (
id character varying(4),
num character varying(10),
x numeric(10,2),
y numeric(10,2),
z numeric(10,2),
prof numeric(10,2),
aucy numeric(10,2),
autot numeric(10,2),
litho character varying(20),
old_id character varying(20),
numauto integer NOT NULL,
aucy2 numeric(10,2),
directory_index integer
);
ALTER TABLE public.grade_ctrl OWNER TO pierre;
--
-- Name: TABLE grade_ctrl; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE grade_ctrl IS 'sampling data made during mining exploitation';
--
-- Name: COLUMN grade_ctrl.id; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN grade_ctrl.id IS 'Quarry and block identification in 4
characters';
--
-- Name: COLUMN grade_ctrl.num; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN grade_ctrl.num IS 'sample number';
--
-- Name: COLUMN grade_ctrl.x; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN grade_ctrl.x IS 'X drill hole collar coordinate, projected in
UTM (m)';
--
-- Name: COLUMN grade_ctrl.y; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN grade_ctrl.y IS 'Y drill hole collar coordinate, projected in
UTM (m)';
--
-- Name: COLUMN grade_ctrl.z; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN grade_ctrl.z IS 'Z drill hole collar coordinate, projected in
UTM (m)';
--
-- Name: COLUMN grade_ctrl.prof; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN grade_ctrl.prof IS 'End of sample depth';
--
-- Name: COLUMN grade_ctrl.aucy; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN grade_ctrl.aucy IS 'Sample cyanidable gold grade (g/t)';
--
-- Name: COLUMN grade_ctrl.autot; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN grade_ctrl.autot IS 'Total gold grade (g/t)';
--
-- Name: COLUMN grade_ctrl.litho; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN grade_ctrl.litho IS 'Sample lithology in GDM or Sermine code';
--
-- Name: COLUMN grade_ctrl.old_id; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN grade_ctrl.old_id IS 'Quarry and block old identification ';
--
-- Name: rock_ana; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE rock_ana (
hammer_index integer,
value numeric(10,2),
numauto integer NOT NULL,
shipment date,
reception date,
amc_batch character varying(20),
labo_batch character varying(20),
comments character varying(20),
ticket_id character varying(25),
ana_type integer
);
ALTER TABLE public.rock_ana OWNER TO pierre;
--
-- Name: COLUMN rock_ana.hammer_index; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN rock_ana.hammer_index IS 'Sample identification related to
the hammer_sampling table';
--
-- Name: COLUMN rock_ana.value; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN rock_ana.value IS 'Analysis value';
--
-- Name: COLUMN rock_ana.numauto; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN rock_ana.numauto IS 'auto increment integer';
--
-- Name: lab_ana_results; Type: TABLE; Schema: public; Owner: pierre;
Tablespace:
--
CREATE TABLE lab_ana_results (
sample_id character varying(20),
batch_id character varying,
labname character varying(10),
lab_pjcsa_pro_job character varying(20),
lab_pj_orderno character varying(40),
lab_pjc_sampleident character varying(40),
lab_pjcsa_sch_code character varying(20),
lab_pjcsa_analytecode character varying(20),
lab_pjcsa_formattedvalue character varying(20),
db_update_timestamp timestamp without time zone DEFAULT now(),
value_num numeric
);
ALTER TABLE public.lab_ana_results OWNER TO pierre;
--
-- Name: TABLE lab_ana_results; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE lab_ana_results IS 'Laboratory results table, after laboratory
instructions, related to LIMS system';
--
-- Name: COLUMN lab_ana_results.batch_id; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN lab_ana_results.batch_id IS 'Batch number';
--
-- Name: COLUMN lab_ana_results.labname; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN lab_ana_results.labname IS 'Analytical laboratory';
--
-- Name: COLUMN lab_ana_results.lab_pjcsa_pro_job; Type: COMMENT; Schema:
public; Owner: pierre
--
COMMENT ON COLUMN lab_ana_results.lab_pjcsa_pro_job IS 'jcsa.pro_job,
--> Intertek JobNo (VarChar(20))';
--
-- Name: COLUMN lab_ana_results.lab_pj_orderno; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN lab_ana_results.lab_pj_orderno IS 'pj.orderno,
--> Client Order No (VarChar(40))';
--
-- Name: COLUMN lab_ana_results.lab_pjc_sampleident; Type: COMMENT; Schema:
public; Owner: pierre
--
COMMENT ON COLUMN lab_ana_results.lab_pjc_sampleident IS 'pjc.sampleident,
--> Client SampleID (VarChar(40))';
--
-- Name: COLUMN lab_ana_results.lab_pjcsa_sch_code; Type: COMMENT; Schema:
public; Owner: pierre
--
COMMENT ON COLUMN lab_ana_results.lab_pjcsa_sch_code IS 'pjcsa.sch_code,
--> Scheme Code (Intertek Internal Code - which probably reported to Client
as well) (VarChar(20))';
--
-- Name: COLUMN lab_ana_results.lab_pjcsa_analytecode; Type: COMMENT; Schema:
public; Owner: pierre
--
COMMENT ON COLUMN lab_ana_results.lab_pjcsa_analytecode IS 'pjcsa.analytecode,
--> Analyte Code (Intertek Internal Code - which probably reported to
Client as well) (VarChar(20))';
--
-- Name: COLUMN lab_ana_results.lab_pjcsa_formattedvalue; Type: COMMENT;
Schema: public; Owner: pierre
--
COMMENT ON COLUMN lab_ana_results.lab_pjcsa_formattedvalue IS
'pjcsa.formattedvalue --> Reported Value (VarChar(20))';
--
-- Name: COLUMN lab_ana_results.db_update_timestamp; Type: COMMENT; Schema:
public; Owner: pierre
--
COMMENT ON COLUMN lab_ana_results.db_update_timestamp IS 'Current date and time
stamp when data is loaded in table';
--
-- Name: COLUMN lab_ana_results.value_num; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN lab_ana_results.value_num IS 'Reported value, converted to
numeric. IS becomes -999, LNR -9999, < -, > nothing';
--
-- Name: lex_directory; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE lex_directory (
directory character varying(500),
directory_index integer NOT NULL
);
ALTER TABLE public.lex_directory OWNER TO pierre;
--
-- Name: TABLE lex_directory; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE lex_directory IS 'Look-up table of datasources, directories
and files';
--
-- Name: lex_drill_hole_type; Type: TABLE; Schema: public; Owner: pierre;
Tablespace:
--
CREATE TABLE lex_drill_hole_type (
type character varying(10),
description character varying(254)
);
ALTER TABLE public.lex_drill_hole_type OWNER TO pierre;
--
-- Name: TABLE lex_drill_hole_type; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE lex_drill_hole_type IS 'Drill hole type lexicon';
--
-- Name: lex_labo_analysis; Type: TABLE; Schema: public; Owner: pierre;
Tablespace:
--
CREATE TABLE lex_labo_analysis (
lab_id character varying(4),
description character varying
);
ALTER TABLE public.lex_labo_analysis OWNER TO pierre;
--
-- Name: TABLE lex_labo_analysis; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE lex_labo_analysis IS 'Look_up table, chemical analysis
laboratories';
--
-- Name: COLUMN lex_labo_analysis.lab_id; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN lex_labo_analysis.lab_id IS 'Laboratory identifier';
--
-- Name: COLUMN lex_labo_analysis.description; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN lex_labo_analysis.description IS 'Laboratory full title,
description, etc.';
--
-- Name: lex_laboratory; Type: TABLE; Schema: public; Owner: pierre;
Tablespace:
--
CREATE TABLE lex_laboratory (
labo character varying(4),
name character varying(50)
);
ALTER TABLE public.lex_laboratory OWNER TO pierre;
--
-- Name: lex_litho; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE lex_litho (
codegdm character varying(4),
codeser character varying(4),
description character varying(254)
);
ALTER TABLE public.lex_litho OWNER TO pierre;
--
-- Name: licences; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE licences (
opid integer,
id integer NOT NULL,
licence_name character varying(50),
operator character varying(20),
year integer,
lat_min numeric(10,5) NOT NULL,
lon_min numeric(10,5) NOT NULL,
lat_max numeric(10,5) NOT NULL,
lon_max numeric(10,5) NOT NULL,
comments character varying(500)
);
ALTER TABLE public.licences OWNER TO pierre;
--
-- Name: TABLE licences; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE licences IS 'Licences, tenements';
--
-- Name: licences_quadrangles; Type: VIEW; Schema: public; Owner: pierre
--
CREATE VIEW licences_quadrangles AS
SELECT licences.opid, licences.id, licences.licence_name,
licences.operator, licences.year, licences.lat_min, licences.lon_min,
licences.lat_max, licences.lon_max, licences.comments,
geomfromewkt((((((((((((((((((((('SRID=4326;POLYGON(('::text ||
licences.lon_min) || ' '::text) || licences.lat_max) || ','::text) ||
licences.lon_max) || ' '::text) || licences.lat_max) || ','::text) ||
licences.lon_max) || ' '::text) || licences.lat_min) || ','::text) ||
licences.lon_min) || ' '::text) || licences.lat_min) || ','::text) ||
licences.lon_min) || ' '::text) || licences.lat_max) || '))'::text)) AS
geomfromewkt FROM licences ORDER BY licences.licence_name;
ALTER TABLE public.licences_quadrangles OWNER TO pierre;
--
-- Name: locations; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE locations (
operation character varying(4) DEFAULT 'HASS'::character varying NOT NULL,
location character varying(20) NOT NULL,
full_name character varying(100),
lat_min numeric(10,5) NOT NULL,
lon_min numeric(10,5) NOT NULL,
lat_max numeric(10,5),
lon_max numeric(10,5)
);
ALTER TABLE public.locations OWNER TO pierre;
--
-- Name: TABLE locations; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE locations IS 'Zones, prospects code, rectangle';
--
-- Name: COLUMN locations.operation; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN locations.operation IS 'Operation id';
--
-- Name: COLUMN locations.location; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN locations.location IS 'Location code name, see
collars.location';
--
-- Name: COLUMN locations.full_name; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN locations.full_name IS 'Location full name';
--
-- Name: COLUMN locations.lat_min; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN locations.lat_min IS 'South latitude, decimal degrees, WGS84';
--
-- Name: COLUMN locations.lon_min; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN locations.lon_min IS 'West longitude, decimal degrees, WGS84';
--
-- Name: COLUMN locations.lat_max; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN locations.lat_max IS 'North latitude, decimal degrees, WGS84';
--
-- Name: COLUMN locations.lon_max; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN locations.lon_max IS 'East latitude, decimal degrees, WGS84';
--
-- Name: occurrences; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE occurrences (
numauto integer NOT NULL,
name character varying(50),
status character varying(10),
x double precision,
y double precision,
description character varying(254),
w_done character varying(254),
w_todo character varying(254),
geol_poten character varying(22),
grade character varying(6),
type character varying(23),
code_typ character varying(6),
size integer,
au character varying(4),
trenches character varying(9),
coredrill character varying(9),
pdrill character varying(6),
max_grade character varying(10),
length character varying(14),
thickness character varying(10),
code_indic character varying(10),
geom geometry,
num_code integer,
code character varying(20),
CONSTRAINT enforce_dims_geom CHECK ((ndims(geom) = 2)),
CONSTRAINT enforce_geotype_geom CHECK (((geometrytype(geom) =
'POINT'::text) OR (geom IS NULL))),
CONSTRAINT enforce_srid_geom CHECK ((srid(geom) = 4326))
);
ALTER TABLE public.occurrences OWNER TO pierre;
--
-- Name: TABLE occurrences; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE occurrences IS 'Occurences table: targets, mines, showings,
deposits, mines. Compiled from various tables, and updated.';
--
-- Name: COLUMN occurrences.name; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN occurrences.name IS 'Occurence name';
--
-- Name: COLUMN occurrences.status; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN occurrences.status IS 'Status: OCCUR = occurence ; OREB =
orebody ; MINE = active mine ; MINED = exploited, depleted mine';
--
-- Name: COLUMN occurrences.x; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN occurrences.x IS 'UTM coordinate; kept as reference; the
actual position is stored in the geom field';
--
-- Name: COLUMN occurrences.y; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN occurrences.y IS 'UTM coordinate; kept as reference; the
actual position is stored in the geom field';
--
-- Name: COLUMN occurrences.description; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN occurrences.description IS 'Occurence description: geological
context, significant figures at current stage of exploration or exploitation';
--
-- Name: COLUMN occurrences.w_done; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN occurrences.w_done IS 'Exploration work done, codified field:
PROSPection (rock sampling on surface), SOIL geochemistry, MAPping, DECAPage,
TRenches, Drill Holes';
--
-- Name: COLUMN occurrences.w_todo; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN occurrences.w_todo IS 'Exploration work to be done, codified
field: PROSPection (rock sampling on surface), SOIL geochemistry, MAPping,
DECAPage, TRenches, Drill Holes';
--
-- Name: COLUMN occurrences.geol_poten; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN occurrences.geol_poten IS 'Geological potential (quite
meaningless; field to be dropped)';
--
-- Name: operations; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE operations (
opid integer NOT NULL,
operation character varying(4),
full_name character varying(50),
operator character varying(20),
year integer,
confidentiality boolean DEFAULT true,
lat_min numeric(10,5) NOT NULL,
lon_min numeric(10,5) NOT NULL,
lat_max numeric(10,5),
lon_max numeric(10,5),
comments character varying(500)
);
ALTER TABLE public.operations OWNER TO pierre;
--
-- Name: TABLE operations; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE operations IS 'Operations, projects, operator or client name';
--
-- Name: COLUMN operations.opid; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN operations.opid IS 'Operation identifier, automatic sequence';
--
-- Name: COLUMN operations.operation; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN operations.operation IS 'Operation code';
--
-- Name: COLUMN operations.full_name; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN operations.full_name IS 'Complete operation name';
--
-- Name: COLUMN operations.operator; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN operations.operator IS 'Operator: mining operator,
exploration company, client name';
--
-- Name: COLUMN operations.year; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN operations.year IS 'Year of operation activity';
--
-- Name: COLUMN operations.confidentiality; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN operations.confidentiality IS 'Confidentiality flag, true or
false; default is true';
--
-- Name: COLUMN operations.lat_min; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN operations.lat_min IS 'South latitude, decimal degrees,
WGS84';
--
-- Name: COLUMN operations.lon_min; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN operations.lon_min IS 'West longitude, decimal degrees,
WGS84';
--
-- Name: COLUMN operations.lat_max; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN operations.lat_max IS 'North latitude, decimal degrees,
WGS84';
--
-- Name: COLUMN operations.lon_max; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN operations.lon_max IS 'East latitude, decimal degrees, WGS84';
--
-- Name: operations_quadrangles; Type: VIEW; Schema: public; Owner: pierre
--
CREATE VIEW operations_quadrangles AS
SELECT operations.opid, operations.operation, operations.full_name,
operations.operator, operations.year, operations.confidentiality,
operations.lat_min, operations.lon_min, operations.lat_max, operations.lon_max,
operations.comments,
geomfromewkt((((((((((((((((((((('SRID=4326;POLYGON(('::text ||
operations.lon_min) || ' '::text) || operations.lat_max) || ','::text) ||
operations.lon_max) || ' '::text) || operations.lat_max) || ','::text) ||
operations.lon_max) || ' '::text) || operations.lat_min) || ','::text) ||
operations.lon_min) || ' '::text) || operations.lat_min) || ','::text) ||
operations.lon_min) || ' '::text) || operations.lat_max) || '))'::text)) AS
geomfromewkt FROM operations ORDER BY operations.operation;
ALTER TABLE public.operations_quadrangles OWNER TO pierre;
--
-- Name: qc_sampling; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE qc_sampling (
sample_id character varying(20),
qc_type character varying,
duplicate_of character varying(20),
datasource character varying,
comments character varying,
batch_id character varying(20)
);
ALTER TABLE public.qc_sampling OWNER TO pierre;
--
-- Name: qc_standards; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE qc_standards (
qc_id character varying(20) NOT NULL,
labo character varying(50),
name character varying(50),
matrix character varying(50),
presentation character varying(50),
au_ppm numeric(10,3),
cu_ppm numeric(10,3),
zn_ppm numeric(10,3),
pb_ppm numeric(10,3),
ag_ppm numeric(10,3),
ni_ppm numeric(10,3),
au_ppm_95pc_conf_interval numeric,
cu_ppm_95pc_conf_interval numeric,
zn_ppm_95pc_conf_interval numeric,
pb_ppm_95pc_conf_interval numeric,
ag_ppm_95pc_conf_interval numeric,
ni_ppm_95pc_conf_interval numeric
);
ALTER TABLE public.qc_standards OWNER TO pierre;
--
-- Name: TABLE qc_standards; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE qc_standards IS 'samples description used for the quality
control';
--
-- Name: COLUMN qc_standards.qc_id; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN qc_standards.qc_id IS 'sample identification';
--
-- Name: COLUMN qc_standards.labo; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN qc_standards.labo IS 'sample laboratory';
--
-- Name: COLUMN qc_standards.name; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN qc_standards.name IS 'sample name';
--
-- Name: COLUMN qc_standards.matrix; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN qc_standards.matrix IS 'sample composition';
--
-- Name: COLUMN qc_standards.presentation; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN qc_standards.presentation IS 'sample presentation';
--
-- Name: COLUMN qc_standards.au_ppm; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN qc_standards.au_ppm IS 'sample analysis value';
--
-- Name: COLUMN qc_standards.cu_ppm; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN qc_standards.cu_ppm IS 'sample analysis value';
--
-- Name: COLUMN qc_standards.zn_ppm; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN qc_standards.zn_ppm IS 'sample analysis value';
--
-- Name: COLUMN qc_standards.pb_ppm; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN qc_standards.pb_ppm IS 'sample analysis value';
--
-- Name: COLUMN qc_standards.ag_ppm; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN qc_standards.ag_ppm IS 'sample analysis value';
--
-- Name: COLUMN qc_standards.ni_ppm; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN qc_standards.ni_ppm IS 'sample analysis value';
--
-- Name: rock_sampling; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE rock_sampling (
geologist character varying(20),
num character varying(20),
x numeric(10,2),
y numeric(10,2),
z numeric(10,2),
hammer_index integer NOT NULL,
directory_index integer,
descr character varying(250),
zone character varying(250)
);
ALTER TABLE public.rock_sampling OWNER TO pierre;
--
-- Name: TABLE rock_sampling; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON TABLE rock_sampling IS 'outcrop sampling (taken with geological
hammer)';
--
-- Name: COLUMN rock_sampling.geologist; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN rock_sampling.geologist IS 'geologist name';
--
-- Name: COLUMN rock_sampling.num; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN rock_sampling.num IS 'sample name or number';
--
-- Name: COLUMN rock_sampling.x; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN rock_sampling.x IS 'X coordinate';
--
-- Name: COLUMN rock_sampling.y; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN rock_sampling.y IS 'Y coordinate';
--
-- Name: COLUMN rock_sampling.z; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN rock_sampling.z IS 'Z coordinate';
--
-- Name: COLUMN rock_sampling.hammer_index; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN rock_sampling.hammer_index IS 'integer related to the
hammer_ana table';
--
-- Name: shift_reports; Type: TABLE; Schema: public; Owner: pierre; Tablespace:
--
CREATE TABLE shift_reports (
date date,
geologist character varying(50),
time_start time without time zone,
time_end time without time zone,
id character varying(20),
drilled_length_during_shift numeric(10,2),
drilled_length numeric(10,2),
planned_length numeric(10,2),
completed boolean,
x numeric(10,2),
y numeric(10,2),
z numeric(10,2),
azimut_ng numeric(10,2),
dip numeric(10,2),
samples_from integer,
samples_to integer,
nb_samples integer,
quartering integer,
comments character varying(254),
no_fichette integer NOT NULL,
rig character varying(50),
tool character varying(20),
shift character varying(1),
peg_number character varying(5),
profile character varying(10),
invoice_nr integer
);
ALTER TABLE public.shift_reports OWNER TO pierre;
--
-- Name: COLUMN shift_reports.date; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN shift_reports.date IS 'Date of drilling';
--
-- Name: COLUMN shift_reports.geologist; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN shift_reports.geologist IS 'Geologist(s) following the drill
hole on the rig site, doing the logging.';
--
-- Name: COLUMN shift_reports.time_start; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN shift_reports.time_start IS 'Drilling starting time';
--
-- Name: COLUMN shift_reports.time_end; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN shift_reports.time_end IS 'Drilling ending time';
--
-- Name: COLUMN shift_reports.id; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN shift_reports.id IS 'Drill hole identifier, must match
collars.id field, e.g. UMA_R086';
--
-- Name: COLUMN shift_reports.drilled_length_during_shift; Type: COMMENT;
Schema: public; Owner: pierre
--
COMMENT ON COLUMN shift_reports.drilled_length_during_shift IS 'Length of
borehole drilled during the shift';
--
-- Name: COLUMN shift_reports.drilled_length; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN shift_reports.drilled_length IS 'Total length of the borehole
drilled at the end of the shift';
--
-- Name: COLUMN shift_reports.planned_length; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN shift_reports.planned_length IS 'Length of the borehole, as
initially planned';
--
-- Name: COLUMN shift_reports.completed; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN shift_reports.completed IS 'Borehole finished or not';
--
-- Name: COLUMN shift_reports.x; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN shift_reports.x IS 'Borehole collar easting coordinate';
--
-- Name: COLUMN shift_reports.y; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN shift_reports.y IS 'Borehole collar northing coordinate';
--
-- Name: COLUMN shift_reports.z; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN shift_reports.z IS 'Borehole collar elevation';
--
-- Name: COLUMN shift_reports.azimut_ng; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN shift_reports.azimut_ng IS 'Borehole orientation, azimuth,
reference = True north';
--
-- Name: COLUMN shift_reports.dip; Type: COMMENT; Schema: public; Owner: pierre
--
COMMENT ON COLUMN shift_reports.dip IS 'Borehole orientation, dip, 0 =
horizontal, >0 = downwards, <0 = upwards';
--
-- Name: COLUMN shift_reports.samples_from; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN shift_reports.samples_from IS 'First sample collected during
shift';
--
-- Name: COLUMN shift_reports.samples_to; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN shift_reports.samples_to IS 'Last sample collected during
shift';
--
-- Name: COLUMN shift_reports.nb_samples; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN shift_reports.nb_samples IS 'Number of samples collected
during shift';
--
-- Name: COLUMN shift_reports.quartering; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN shift_reports.quartering IS 'Samples quartering done on site';
--
-- Name: COLUMN shift_reports.comments; Type: COMMENT; Schema: public; Owner:
pierre
--
COMMENT ON COLUMN shift_reports.comments IS 'Comments on drilling (events,
presence of water, difficulties, major facies, etc.)';
--
-- Name: COLUMN shift_reports.no_fichette; Type: COMMENT; Schema: public;
Owner: pierre
--
COMMENT ON COLUMN shift_reports.no_fichette IS 'Number of "fichette" = field
form filled on a daily and borehole basis';
--
-- Name: dh_collars_numauto_key; Type: CONSTRAINT; Schema: public; Owner:
pierre; Tablespace:
--
ALTER TABLE ONLY dh_collars
ADD CONSTRAINT dh_collars_numauto_key UNIQUE (numauto);
--
-- Name: dh_devia_pkey; Type: CONSTRAINT; Schema: public; Owner: pierre;
Tablespace:
--
ALTER TABLE ONLY dh_devia
ADD CONSTRAINT dh_devia_pkey PRIMARY KEY (numauto);
--
-- Name: dh_mine_pkey; Type: CONSTRAINT; Schema: public; Owner: pierre;
Tablespace:
--
ALTER TABLE ONLY dh_mine
ADD CONSTRAINT dh_mine_pkey PRIMARY KEY (numauto);
--
-- Name: dh_tech_pkey; Type: CONSTRAINT; Schema: public; Owner: pierre;
Tablespace:
--
ALTER TABLE ONLY dh_tech
ADD CONSTRAINT dh_tech_pkey PRIMARY KEY (numauto);
--
-- Name: fichette_pkey; Type: CONSTRAINT; Schema: public; Owner: pierre;
Tablespace:
--
ALTER TABLE ONLY shift_reports
ADD CONSTRAINT fichette_pkey PRIMARY KEY (no_fichette);
--
-- Name: geoch_ana_pkey; Type: CONSTRAINT; Schema: public; Owner: pierre;
Tablespace:
--
ALTER TABLE ONLY geoch_ana
ADD CONSTRAINT geoch_ana_pkey PRIMARY KEY (numauto);
--
-- Name: geoch_sampling_pkey; Type: CONSTRAINT; Schema: public; Owner: pierre;
Tablespace:
--
ALTER TABLE ONLY geoch_sampling
ADD CONSTRAINT geoch_sampling_pkey PRIMARY KEY (sampl_index);
--
-- Name: hammer_ana_pkey; Type: CONSTRAINT; Schema: public; Owner: pierre;
Tablespace:
--
ALTER TABLE ONLY rock_ana
ADD CONSTRAINT hammer_ana_pkey PRIMARY KEY (numauto);
--
-- Name: hammer_sampling_pkey; Type: CONSTRAINT; Schema: public; Owner: pierre;
Tablespace:
--
ALTER TABLE ONLY rock_sampling
ADD CONSTRAINT hammer_sampling_pkey PRIMARY KEY (hammer_index);
--
-- Name: id; Type: CONSTRAINT; Schema: public; Owner: pierre; Tablespace:
--
ALTER TABLE ONLY dh_collars
ADD CONSTRAINT id PRIMARY KEY (id);
--
-- Name: lex_directory_pkey; Type: CONSTRAINT; Schema: public; Owner: pierre;
Tablespace:
--
ALTER TABLE ONLY lex_directory
ADD CONSTRAINT lex_directory_pkey PRIMARY KEY (directory_index);
--
-- Name: lex_qc_qc_id_key; Type: CONSTRAINT; Schema: public; Owner: pierre;
Tablespace:
--
ALTER TABLE ONLY qc_standards
ADD CONSTRAINT lex_qc_qc_id_key UNIQUE (qc_id);
--
-- Name: licence_id; Type: CONSTRAINT; Schema: public; Owner: pierre;
Tablespace:
--
ALTER TABLE ONLY licences
ADD CONSTRAINT licence_id PRIMARY KEY (id);
--
-- Name: occurences_pkey; Type: CONSTRAINT; Schema: public; Owner: pierre;
Tablespace:
--
ALTER TABLE ONLY occurrences
ADD CONSTRAINT occurences_pkey PRIMARY KEY (numauto);
--
-- Name: opid; Type: CONSTRAINT; Schema: public; Owner: pierre; Tablespace:
--
ALTER TABLE ONLY operations
ADD CONSTRAINT opid PRIMARY KEY (opid);
--
-- Name: preex_sampling_pkey; Type: CONSTRAINT; Schema: public; Owner: pierre;
Tablespace:
--
ALTER TABLE ONLY grade_ctrl
ADD CONSTRAINT preex_sampling_pkey PRIMARY KEY (numauto);
--
-- Name: dh_litho_id_depto; Type: INDEX; Schema: public; Owner: pierre;
Tablespace:
--
CREATE INDEX dh_litho_id_depto ON dh_litho USING btree (id, depto);
--
-- Name: id_depto_dh_mine; Type: INDEX; Schema: public; Owner: pierre;
Tablespace:
--
CREATE INDEX id_depto_dh_mine ON dh_mine USING btree (id, depto);
--
-- Name: id_depto_dh_tech; Type: INDEX; Schema: public; Owner: pierre;
Tablespace:
--
CREATE INDEX id_depto_dh_tech ON dh_tech USING btree (id, depto);
--
-- Name: id_preex_sampling; Type: INDEX; Schema: public; Owner: pierre;
Tablespace:
--
CREATE INDEX id_preex_sampling ON grade_ctrl USING btree (id);
--
-- Name: sampl_index_geoch_ana; Type: INDEX; Schema: public; Owner: pierre;
Tablespace:
--
CREATE INDEX sampl_index_geoch_ana ON geoch_ana USING btree (sampl_index);
--
-- Name: sampl_index_geoch_sampling; Type: INDEX; Schema: public; Owner:
pierre; Tablespace:
--
CREATE INDEX sampl_index_geoch_sampling ON geoch_sampling USING btree
(sampl_index);
--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
--
-- Name: dh_devia; Type: ACL; Schema: public; Owner: pierre
--
REVOKE ALL ON TABLE dh_devia FROM PUBLIC;
REVOKE ALL ON TABLE dh_devia FROM pierre;
GRANT ALL ON TABLE dh_devia TO pierre;
GRANT ALL ON TABLE dh_devia TO postgres;
--
-- Name: dh_mine; Type: ACL; Schema: public; Owner: pierre
--
REVOKE ALL ON TABLE dh_mine FROM PUBLIC;
REVOKE ALL ON TABLE dh_mine FROM pierre;
GRANT ALL ON TABLE dh_mine TO pierre;
GRANT ALL ON TABLE dh_mine TO postgres;
--
-- Name: dh_tech; Type: ACL; Schema: public; Owner: pierre
--
REVOKE ALL ON TABLE dh_tech FROM PUBLIC;
REVOKE ALL ON TABLE dh_tech FROM pierre;
GRANT ALL ON TABLE dh_tech TO pierre;
GRANT ALL ON TABLE dh_tech TO postgres;
--
-- Name: geoch_ana; Type: ACL; Schema: public; Owner: pierre
--
REVOKE ALL ON TABLE geoch_ana FROM PUBLIC;
REVOKE ALL ON TABLE geoch_ana FROM pierre;
GRANT ALL ON TABLE geoch_ana TO pierre;
GRANT ALL ON TABLE geoch_ana TO postgres;
--
-- Name: geoch_sampling; Type: ACL; Schema: public; Owner: pierre
--
REVOKE ALL ON TABLE geoch_sampling FROM PUBLIC;
REVOKE ALL ON TABLE geoch_sampling FROM pierre;
GRANT ALL ON TABLE geoch_sampling TO pierre;
GRANT ALL ON TABLE geoch_sampling TO postgres;
--
-- Name: grade_ctrl; Type: ACL; Schema: public; Owner: pierre
--
REVOKE ALL ON TABLE grade_ctrl FROM PUBLIC;
REVOKE ALL ON TABLE grade_ctrl FROM pierre;
GRANT ALL ON TABLE grade_ctrl TO pierre;
GRANT ALL ON TABLE grade_ctrl TO postgres;
--
-- Name: rock_ana; Type: ACL; Schema: public; Owner: pierre
--
REVOKE ALL ON TABLE rock_ana FROM PUBLIC;
REVOKE ALL ON TABLE rock_ana FROM pierre;
GRANT ALL ON TABLE rock_ana TO pierre;
GRANT ALL ON TABLE rock_ana TO postgres;
--
-- Name: lex_drill_hole_type; Type: ACL; Schema: public; Owner: pierre
--
REVOKE ALL ON TABLE lex_drill_hole_type FROM PUBLIC;
REVOKE ALL ON TABLE lex_drill_hole_type FROM pierre;
GRANT ALL ON TABLE lex_drill_hole_type TO pierre;
GRANT ALL ON TABLE lex_drill_hole_type TO postgres;
--
-- Name: lex_litho; Type: ACL; Schema: public; Owner: pierre
--
REVOKE ALL ON TABLE lex_litho FROM PUBLIC;
REVOKE ALL ON TABLE lex_litho FROM pierre;
GRANT ALL ON TABLE lex_litho TO pierre;
GRANT ALL ON TABLE lex_litho TO postgres;
--
-- Name: rock_sampling; Type: ACL; Schema: public; Owner: pierre
--
REVOKE ALL ON TABLE rock_sampling FROM PUBLIC;
REVOKE ALL ON TABLE rock_sampling FROM pierre;
GRANT ALL ON TABLE rock_sampling TO pierre;
GRANT ALL ON TABLE rock_sampling TO postgres;
--
-- Name: shift_reports; Type: ACL; Schema: public; Owner: pierre
--
REVOKE ALL ON TABLE shift_reports FROM PUBLIC;
REVOKE ALL ON TABLE shift_reports FROM pierre;
GRANT ALL ON TABLE shift_reports TO pierre;
GRANT ALL ON TABLE shift_reports TO postgres;
--
-- PostgreSQL database dump complete
--
Other related posts:
