Skip to main content

Skip to navigation

The access keys for this page are:

Ministry of Energy Mines and Responsible for Core Review

Appendix G: MINFILE/pc V. 4.5 Database Structure


 

A: Entity Files
B: Relationship Files
C: Comment Files
D: Entity/Relationship Models

 

This data structure is the previous version of MINFILE.  It acts as a guide to the current data structure of Version 5.0, which is similar, but has been modified to accommodate changes in the application.  View MINFILE/pc V. 5.0 Data Structure (PDF 145Kb).

 

A. ENTITY FILES:

File    Field          Size     Alias
E01     MINFILNO        9       MINFILE_NUMBER
LAT_DEG 2 LATITUDE_DEGREES
LAT_MIN 2 LATITUDE_MINUTES
LAT_SEC 2 LATITUDE_SECONDS
LAT_HEMI 1 LATITUDE_HEMISPHERE
LONG_DEG 3 LONGITUDE_DEGREES
LONG_MIN 2 LONGITUDE_MINUTES
LONG_SEC 2 LONGITUDE_SECONDS
LONG_HEMI 1 LONGITUDE_HEMISPHERE
N83_LATDEG 2 NAD83_LATITUDE_DEGREES
N83_LATMIN 2 NAD83_LATITUDE_MINUTES
N83_LATSEC 2 NAD83_LATITUDE_SECONDS
N83_LATHEM 1 NAD83_LATITUDE_HEMISPHERE
N83_LONDEG 3 NAD83_LONGITUDE_DEGREES
N83_LONMIN 2 NAD83_LONGITUDE_MINUTES
N83_LONSEC 2 NAD83_LONGITUDE_SECONDS
N83_LONHEM 1 NAD83_LONGITUDE_HEMISPHERE
UTM_ZONE 2 UTM_ZONE
UTM_EAST 6 UTM_EASTING
UTM_NORT 8 UTM_NORTHING
N83_ZONE 2 N83_UTM_ZONE
N83_EAST 6 N83_UTM_EASTING
N83_NORT 8 N83_UTM_NORTHING
ELEV 4 ELEVATION
LOC_ACC 1 DEPOSIT_LOCATION_ACCURACY
DEPSIZEL 4 DEP_SIZE_L
DEPSIZEB 4 DEP_SIZE_B
DEPSIZEW 4 DEP_SIZE_W
DIP 3 DEPOSIT_DIP
STRIKE 3 DEPOSIT_STRIKE
PLUNGE 6 DEPOSIT_TREND_PLUNGE
NATMINNO 18 NAT_MIN_INV_NO
CANMINNO 6 CANMINDEX_NUMBER
CODED 8 DATE_CODED
REVISED 8 DATE_REVISED
GREVISED 4 GEOLOGIST_REVISE
FREVISED 1 FIELD_REVISED
FCHECKED 1 FIELD_CHECKED
GNAME 4 GEOLOGIST_NAME
OPENPIT 1 OPEN_PIT
UGROUND 1 UNDER_GROUND
E02 STATUS_C 4 STATUS_TYPE_CODE
STATUS_D 20 STATUS_TYPE_DESCRIPTION
QMAPSYM 15 MAP_SYMBOL
SYM_LN_TYP 2 SYMBOL_LINE_TYPE
HATCH_PATT 2 HATCH_PATTERN
SIZE_THICK 3 SYMBOL_SIZE
LBL_SIZE 3 LABEL_SIZE
E03 DOMHRK_C 1 DOMINANT_HOST_ROCK_CODE
DOMHRK_D 15 DOMINANT_HOST_ROCK_DESCRIPTION
E04 DEPMOD_C 1 DEPOSIT_MODIFIER_CODE
DEPMOD_D 15 DEPOSIT_MODIFIER_DESCRIPTION
E05 DEPCHR_C 2 DEPOSIT_CHARACTER_CODE
DEPCHR_D 20 DEPOSIT_CHARACTER_DESCRIPTION
E06 DEPSHA_C 2 DEPOSIT_SHAPE_TYPE_CODE
DEPSHA_D 12 DEPOSIT_SHAPE_TYPE_DESCRIPTION
E07 DEPCLA_C 2 DEPOSIT_CLASSIFICATION_CODE
DEPCLA_D 15 DEPOSIT_CLASSIFICATION_DESC.
E09 MINDIV_C 4 MINING_DIVISION_CODE
MINDIV_D 15 MINING_DIVISION_DESCRIPTION
E10 NTSMAP_C 7 NTS_MAPSHEET
E11 BCMAP_C 7 BC_MAPSHEET
E12 TECBLT_C 2 TECTONIC_BELT_CODE
TECBLT_D 18 TECTONIC_BELT_DESCRIPTION
E13 TERRAN_C 3 TERRANE_CODE
TERRAN_D 30 TERRANE_DESCRIPTION
E14 PHYSIO_C 4 PHYSIOGRAPHIC_AREA_CODE
PHYSIO_D 30 PHYSIOGRAPHIC_AREA_DESCRIPTION
E15 META_T_C 1 METAMORPHIC_TYPE_CODE
META_T_D 10 METAMORPHIC_TYPE_DESCRIPTION
E16 META_G_C 2 METAMORPHIC_GRADE_CODE
META_G_D 15 METAMORPHIC_GRADE_DESCRIPTION
E17 META_R_C 1 METAMORPHIC_RELATIONSHIP_CODE
META_R_D 20 METAMORPHIC_RELATIONSHIP_DESC.
E18 YEAR 4 YEAR
E19 COMMOD_C 2 COMMODITY_CODE
COMMOD_D 30 COMMODITY_DESCRIPTION
E20a MINCLA_C 1 MINERALOGY_CLASS_CODE
MINCLA_D 15 MINERALOGY_CLASS_DESCRIPTION
E20b MINERL_C 4 MINERAL_CODE
MINERL_D 20 MINERAL_DESCRIPTION
E21 ALTER_C 4 ALTERATION_CODE
ALTER_D 12 ALTERATION_DESCRIPTION
E22 DATMET_C 2 DATING_METHOD_CODE
DATMET_D 30 DATING_METHOD_DESCRIPTION
E23 STNAME_C 6 STRATIGRAPHIC_NAME_CODE
STNAME_D 30 STRATIGRAPHIC_NAME_DESCRIPTION
STINFORM 1 STRATIGRAPHIC_NAME_INFORMAL
STIGMETA 1 STRATIGRAPHIC_NAME_IG_META
STGROUP 1 STRATIGRAPHIC_NAME_GROUP
STFORM 1 STRATIGRAPHIC_NAME_FORMATION
E24 ST_AGE_C 3 STRATIGRAPHIC_AGE_CODE
ST_AGE_D 20 STRATIGRAPHIC_AGE_DESCRIPTION
E25 ROCK_T_C 4 ROCK_TYPE_CODE
ROCK_T_D 30 ROCK_TYPE_DESCRIPTION
E26 ROCK_M_C 4 ROCK_MODIFIER_CODE
ROCK_M_D 30 ROCK_MODIFIER_DESCRIPTION
E27 OREZON_C 5 ORE_ZONE_CODE
OREZON_D 30 ORE_ZONE_DESCRIPTION
E28 SAMPLE_C 4 SAMPLE_TYPE_CODE
SAMPLE_D 30 SAMPLE_TYPE_DESCRIPTION
E29 RESCAT_C 2 RESERVE_CATEGORY_CODE
RESCAT_D 30 RESERVE_CATEGORY_DESCRIPTION
E30 DEPTYP_C 5 DEPOSIT_TYPE_CODE
DEPTYP_D 50 DEPOSIT_TYPE_DESCRIPTION
SYNONYM 50 SYNONYM
USGS 10 USGS_TYPE
OTH_SOURCE 20 OTHER_SOURCE
REFERENCE 30 REFERENCE
GLOBAL_EX 90 GLOBAL_EXAMPLE
BC_EX 50 BC_EXAMPLE
AUTHOR 20 AUTHOR
E31 PROJ_NO 7 PROJECT_NUMBER
PROPERTY 30 PROPERTY_NAME
PROPERTY_2 30 PROPERTY_NAME2
OWNER 30 OWNER_NAME
OWNER_2 30 OWNER_NAME2
OPERATOR 30 OPERATOR_NAME
DIST_SEQNO 3 DISTRICT_SEQUENCE_NUMBER
DIST_MAPNO 3 DISTRICT_MAP_NUMBER
LAT_DEG 2 LATITUDE_DEGREE
LAT_MIN 2 LATITUDE_MINUTE
LAT_SEC 2 LATITUDE_SECOND
LAT_HEMI 1 LATITUDE_HEMISPHERE
LON_DEG 3 LONGITUDE_DEGREES
LON_MIN 2 LONGITUDE_MINUTES
LON_SEC 2 LONGITUDE_SECONDS
LON_HEMI 1 LONGITUDE_HEMISPHERE
N83_LATDEG 2 NAD83_LATITUDE_DEGREES
N83_LATMIN 2 NAD83_LATITUDE_MINUTES
N83_LATSEC 2 NAD83_LATITUDE_SECONDS
N83_LATHEM 1 NAD83_LATITUDE_HEMISPHERE
N83_LONDEG 3 NAD83_LONGITUDE_DEGREES
N83_LONMIN 2 NAD83_LONGITUDE_MINUTES
N83_LONSEC 2 NAD83_LONGITUDE_SECONDS
N83_LONHEM 1 NAD83_LONGITUDE_HEMISPHERE
LOC_ACC 1 LOCATION_ACCURACY_CODE
CR_DATE 8 CREATED_DATE
RV_DATE 8 REVISED_DATE
CHECKED_BY 5 CHECKED_BY
E32 NOTIC_TYP 1 NOTICE_TYPE_CODE
NOTIC_DESC 20 NOTICE_TYPE_DESCRIPTION
E33 PRJTYP_C 1 PROJECT_TYPE_CODE
PRJTYP_D 20 PROJECT_TYPE_DESCRIPTION
QMAPSYM 15 MAP_SYMBOL
SYM_LN_TYP 2 SYMBOL_LINE_TYPE
HATCH_PATT 2 HATCH_PATTERN
SIZE_THICK 3 SYMBOL_SIZE
LBL_SIZE 3 LABEL_SIZE
E34 STAGE_C 1 MDAP_STAGE_CODE
STAGE_D 15 MDAP_STAGE_DESCRIPTION
E40 REGION_C 5 REGION_CODE
REGION_D 50 REGION_DESCRIPTION
COMMENTS 70 COMMENTS
WML_DEG 4 WESTERN_LONGITUDE_DEGREES
WML_MIN 2 WESTERN_LONGITUDE_MINUTES
WML_SEC 2 WESTERN_LONGITUDE_SECONDS
EML_DEG 4 EASTERN_LONGITUDE_DEGREES
EML_MIN 2 EASTERN_LONGITUDE_MINUTES
EML_SEC 2 EASTERN_LONGITUDE_SECONDS
NML_DEG 3 NORTHERN_LATITUDE_DEGREES
NML_MIN 2 NORTHERN_LATITUDE_MINUTES
NML_SEC 2 NORTHERN_LATITUDE_SECONDS
SML_DEG 3 SOUTHERN_LATITUDE_DEGREES
SML_MIN 2 SOUTHERN_LATITUDE_MINUTES
SML_SEC 2 SOUTHERN_LATITUDE_SECONDS
E41 LABEL_C 3 SCREEN_LABEL_CODE
LABEL_DESC 80 SCREEN_LABEL_DESCRIPTION

B. RELATIONSHIP FILES:

File    Field          Size     Alias
R02     MINFILNO        9       MINFILE_NUMBER
STATUS_C 4 STATUS_TYPE_CODE
R03 MINFILNO 9 MINFILE_NUMBER
DOMHRK_C 1 DOMINANT_HOST_ROCK_CODE
R04 MINFILNO 9 MINFILE_NUMBER
DEPMOD_C 1 DEPOSIT_MODIFIER_CODE
R05 MINFILNO 9 MINFILE_NUMBER
DEPCHR_C 2 DEPOSIT_CHARACTER_CODE
R06 MINFILNO 9 MINFILE_NUMBER
DEPSHA_C 2 DEPOSIT_SHAPE_TYPE_CODE
R07 MINFILNO 9 MINFILE_NUMBER
DEPCLA_C 2 DEPOSIT_CLASSIFICATION_CODE
R08 MINFILNO 9 MINFILE_NUMBER
NAME 30 NAMER09
MINFILNO 9 MINFILE_NUMBER
MINDIV_C 4 MINING_DIVISION_CODE
R10 MINFILNO 9 MINFILE_NUMBER
NTSMAP_C 7 NTS_MAPSHEET
R11 MINFILNO 9 MINFILE_NUMBER
BCMAP_C 7 BC_MAPSHEET
R12 MINFILNO 9 MINFILE_NUMBER
TECBLT_C 2 TECTONIC_BELT_CODE
R13 MINFILNO 9 MINFILE_NUMBER
TERRAN_C 3 TERRANE_CODE
R14 MINFILNO 9 MINFILE_NUMBER
PHYSIO_C 4 PHYSIOGRAPHIC_AREA_CODE
R15 MINFILNO 9 MINFILE_NUMBER
META_T_C 1 METAMORPHIC_TYPE_CODE
R16 MINFILNO 9 MINFILE_NUMBER
META_G_C 2 METAMORPHIC_GRADE_CODE
R17 MINFILNO 9 MINFILE_NUMBER
META_R_C 9 METAMORPHIC_RELATIONSHIP_CODE
R18a MINFILNO 9 MINFILE_NUMBER
YEAR 4 YEAR
MINED 12 ORE_MINED
MILLED 12 ORE_MILLED
R18b MINFILNO 9 MINFILE_NUMBER
YEAR 4 YEAR
COMMOD_C 2 COMMODITY_CODE
QUANTITY 12 QUANTITY
R19 MINFILNO 9 MINFILE_NUMBER
COMMOD_C 2 COMMODITY_CODE
R20 MINFILNO 9 MINFILE_NUMBER
MINCLA_C 1 MINERALOGY_CLASS_CODE
MINERL_C 4 MINERAL_CODE
R21 MINFILNO 9 MINFILE_NUMBER
ALTER_C 4 ALTERATION_CODE
R22 MINFILNO 9 MINFILE_NUMBER
DATMET_C 2 DATING_METHOD_CODE
ISOAGE 20 ISOTOPIC_AGE_MINERALIZATION
MATERIAL 30 MATERIAL_DATED_MINERALIZATION
R23 MINFILNO 9 MINFILE_NUMBER
ST_AGE_C 3 STRATIGRAPHIC_AGE_CODE
STNAME_C 6 STRATIGRAPHIC_NAME_CODE
DATMET_C 2 DATING_METHOD_CODE
ISOAGE 20 ISOTOPIC_AGE_HOST
MATERIAL 30 MATERIAL_DATED_HOST
R24 MINFILNO 9 MINFILE_NUMBER
ST_AGE_C 3 MINERALIZATION_AGE_CODE
R25 MINFILNO 9 MINFILE_NUMBER
ROCK_T_C 4 ROCK_TYPE_CODE
ROCK_M_C 4 ROCK_MODIFIER_CODE
LITHUNIT 11 LITHOLOGICAL_UNIT
R26 MINFILNO 9 MINFILE_NUMBER
OREZON_C 5 ORE_ZONE_CODE
RESCAT_C 2 RESERVE_CATEGORY_CODE
A_OR_B 1 A_OR_B
YEAR 4 YEAR
QUANTITY 12 QUANTITY
REPORT_ON 1 REPORT_ON
R27 MINFILNO 9 MINFILE_NUMBER
OREZON_C 5 ORE_ZONE_CODE
A_OR_B 1 A_OR_B
YEAR 4 YEAR
SAMPLE_C 4 SAMPLE_TYPE_CODE
R28 MINFILNO 9 MINFILE_NUMBER
OREZON_C 5 ORE_ZONE_CODE
RESCAT_C 2 RESERVE_CATEGORY_CODE
A_OR_B 1 A_OR_B
COMMOD_C 2 COMMODITY_CODE
GRADE 9 GRADER30
MINFILNO 9 MINFILE_NUMBER
DEPTYP_C 5 DEPOSIT_TYPE_CODE
R31 PROJ_NO 7 PROJECT_NUMBER
MINFILNO 9 MINFILE_NUMBER
R32a PROJ_NO 7 PROJECT_NUMBER
NOW_NO 9 NOTICE_NUMBER
NOTIC_TYP 1 NOTICE_TYPE_CODE
RECVD_DATE 8 RECEIVED_DATE
APRV_DATE 8 APPROVED_DATE
OPERATOR 30 OPERATOR
MANAGER 30 MANAGER
MGR_TEL 14 MANAGER_TELEPHONE
WK_START 8 WORK_STARTED
WK_END 8 WORK_ENDED
EXP_BUD 13 EXPLORATION_BUDGET
PROD_BUD 13 PRODUCTION_BUDGET
COMPLETED 1 COMPLETED
DISCUSSED 1 DISCUSSED
MDSCREV 1 MDSC_REVIEW
DEP_TARGET 60 DEPOSIT_TARGET
R32b PROJ_NO 7 PROJECT_NUMBER
NOW_NO 9 NOTICE_NUMBER
WK_TODO 70 WORK_TO_DO
WK_DONE 70 WORK_DONE
R33 PROJ_NO 7 PROJECT_NUMBER
PRJTYP_C 1 PROJECT_TYPE_CODE
R34 PROJ_NO 7 PROJECT_NUMBER
NOW_NO 9 NOTICE_NUMBER
STAGE_C 1 MDAP_STAGE_CODE
R35 PROJ_NO 7 PROJECT_NUMBER
MINDIV_C 4 MINING_DIVISION
R36 PROJ_NO 7 PROJECT_NUMBER
NTSMAP_C 7 NTS_MAP
R39 PROJ_NO 7 PROJECT_NUMBER
REGION_C 4 REGION_CODE
R40 MINFILNO 9 MINFILE_NUMBER
REGION_C 4 REGION_CODE

C. COMMENT FILES:

File    Field          Size     Alias
C01     MINFILNO        9       MINFILE_NUMBER
IDENT_T 70 IDENTIFICATION_COMMENTS
C02 MINFILNO 9 MINFILE_NUMBER
SIGMIN_T 70 SIGNIFICANT_MINERALS_COMMENTS
C03 MINFILNO 9 MINFILE_NUMBER
ASSMIN_T 70 ASSOCIATED_MINERALS_COMMENTS
C04 MINFILNO 9 MINFILE_NUMBER
ALTMIN_T 70 ALTERATION_MINERALS_COMMENTS
C05 MINFILNO 9 MINFILE_NUMBER
STRUCT_T 70 STRUCTURAL_COMMENTS
C06 MINFILNO 9 MINFILE_NUMBER
HSTRCK_T 70 HOST_ROCK_COMMENTS
C07 MINFILNO 9 MINFILE_NUMBER
META_T 70 METAMORPHISM_COMMENT
C08 MINFILNO 9 MINFILE_NUMBER
CAPSUL_T 70 CAPSULE_GEOLOGY_COMMENTS
C09 MINFILNO 9 MINFILE_NUMBER
BIBLIO_T 70 BIBLIOGRAPHY_COMMENTS
C10 MINFILNO 9 MINFILE_NUMBER
YEAR 4 YEAR
PROD_T 66 PRODUCTION_COMMENT
C11 MINFILNO 9 MINFILE_NUMBER
OREZON_C 5 ORE_ZONE_CODE
RESCAT_C 2 RESERVE_CATEGORY_CODE
A_OR_B 1 A_OR_B
RESERV_T 70 RESERVES_COMMENTS
C12 MINFILNO 9 MINFILE_NUMBER
OREZON_C 5 ORE_ZONE_CODE
RESCAT_C 2 RESERVE_CATEGORY_CODE
A_OR_B 1 A_OR_B
RESREF_T 70 RESERVES_REFERENCE
C13 MINFILNO 9 MINFILE_NUMBER
CONF_NOTE 70 CONFIDENTIAL_NOTES
C14 PROJ_NO 7 PROJECT_NUMBER
EXPL_T 70 EXPLORATION_COMMENTS
NOTE:   All fields are character.        New to Version 5.0.

D. ENTITY/RELATIONSHIP MODELS:

MINFILE Entity/Relationship Data Model
Exploration Entity/Relationship Data Model
Inventory Entity/Relationship Data Model
Textual Relations Data Model

If printing data models, set printer orientation to Landscape.