Skip to main content

Skip to navigation

The access keys for this page are:

Ministry of Energy Mines and Responsible for Core Review

Appendix I: Database Structure


 

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


 

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_GROUNDE02
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_DESCRIPTIONE04
DEPMOD_C 1 DEPOSIT_MODIFIER_CODE
DEPMOD_D 15 DEPOSIT_MODIFIER_DESCRIPTIONE05
DEPCHR_C 2 DEPOSIT_CHARACTER_CODE
DEPCHR_D 20 DEPOSIT_CHARACTER_DESCRIPTIONE06
DEPSHA_C 2 DEPOSIT_SHAPE_TYPE_CODE
DEPSHA_D 12 DEPOSIT_SHAPE_TYPE_DESCRIPTIONE07
DEPCLA_C 2 DEPOSIT_CLASSIFICATION_CODE
DEPCLA_D 15 DEPOSIT_CLASSIFICATION_DESC.E09
MINDIV_C 4 MINING_DIVISION_CODE
MINDIV_D 15 MINING_DIVISION_DESCRIPTIONE10
NTSMAP_C 7 NTS_MAPSHEETE11
BCMAP_C 7 BC_MAPSHEETE12
TECBLT_C 2 TECTONIC_BELT_CODE
TECBLT_D 18 TECTONIC_BELT_DESCRIPTIONE13
TERRAN_C 3 TERRANE_CODE
TERRAN_D 30 TERRANE_DESCRIPTIONE14
PHYSIO_C 4 PHYSIOGRAPHIC_AREA_CODE
PHYSIO_D 30 PHYSIOGRAPHIC_AREA_DESCRIPTIONE15
META_T_C 1 METAMORPHIC_TYPE_CODE
META_T_D 10 METAMORPHIC_TYPE_DESCRIPTIONE16
META_G_C 2 METAMORPHIC_GRADE_CODE
META_G_D 15 METAMORPHIC_GRADE_DESCRIPTIONE17
META_R_C 1 METAMORPHIC_RELATIONSHIP_CODE
META_R_D 20 METAMORPHIC_RELATIONSHIP_DESC.E18
YEAR 4 YEARE19
COMMOD_C 2 COMMODITY_CODE
COMMOD_D 30 COMMODITY_DESCRIPTIONE20a
MINCLA_C 1 MINERALOGY_CLASS_CODE
MINCLA_D 15 MINERALOGY_CLASS_DESCRIPTIONE20b
MINERL_C 4 MINERAL_CODE
MINERL_D 20 MINERAL_DESCRIPTIONE21
ALTER_C 4 ALTERATION_CODE
ALTER_D 12 ALTERATION_DESCRIPTIONE22
DATMET_C 2 DATING_METHOD_CODE
DATMET_D 30 DATING_METHOD_DESCRIPTIONE23
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_FORMATIONE24
ST_AGE_C 3 STRATIGRAPHIC_AGE_CODE
ST_AGE_D 20 STRATIGRAPHIC_AGE_DESCRIPTIONE25
ROCK_T_C 4 ROCK_TYPE_CODE
ROCK_T_D 30 ROCK_TYPE_DESCRIPTIONE26
ROCK_M_C 4 ROCK_MODIFIER_CODE
ROCK_M_D 30 ROCK_MODIFIER_DESCRIPTIONE27
OREZON_C 5 ORE_ZONE_CODE
OREZON_D 30 ORE_ZONE_DESCRIPTIONE28
SAMPLE_C 4 SAMPLE_TYPE_CODE
SAMPLE_D 30 SAMPLE_TYPE_DESCRIPTIONE29
RESCAT_C 2 RESERVE_CATEGORY_CODE
RESCAT_D 30 RESERVE_CATEGORY_DESCRIPTIONE30
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 AUTHORE31
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_BYE32
NOTIC_TYP 1 NOTICE_TYPE_CODE
NOTIC_DESC 20 NOTICE_TYPE_DESCRIPTIONE33
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_DESCRIPTIONE40
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_SECONDSE41
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_CODER03
MINFILNO 9 MINFILE_NUMBER
DOMHRK_C 1 DOMINANT_HOST_ROCK_CODER04
MINFILNO 9 MINFILE_NUMBER
DEPMOD_C 1 DEPOSIT_MODIFIER_CODER05
MINFILNO 9 MINFILE_NUMBER
DEPCHR_C 2 DEPOSIT_CHARACTER_CODER06
MINFILNO 9 MINFILE_NUMBER
DEPSHA_C 2 DEPOSIT_SHAPE_TYPE_CODER07
MINFILNO 9 MINFILE_NUMBER
DEPCLA_C 2 DEPOSIT_CLASSIFICATION_CODER08
MINFILNO 9 MINFILE_NUMBER
NAME 30 NAMER09
MINFILNO 9 MINFILE_NUMBER
MINDIV_C 4 MINING_DIVISION_CODER10
MINFILNO 9 MINFILE_NUMBER
NTSMAP_C 7 NTS_MAPSHEETR11
MINFILNO 9 MINFILE_NUMBER
BCMAP_C 7 BC_MAPSHEETR12
MINFILNO 9 MINFILE_NUMBER
TECBLT_C 2 TECTONIC_BELT_CODER13
MINFILNO 9 MINFILE_NUMBER
TERRAN_C 3 TERRANE_CODER14
MINFILNO 9 MINFILE_NUMBER
PHYSIO_C 4 PHYSIOGRAPHIC_AREA_CODER15
MINFILNO 9 MINFILE_NUMBER
META_T_C 1 METAMORPHIC_TYPE_CODER16
MINFILNO 9 MINFILE_NUMBER
META_G_C 2 METAMORPHIC_GRADE_CODER17
MINFILNO 9 MINFILE_NUMBER
META_R_C 9 METAMORPHIC_RELATIONSHIP_CODER18a
MINFILNO 9 MINFILE_NUMBER
YEAR 4 YEAR
MINED 12 ORE_MINED
MILLED 12 ORE_MILLEDR18b
MINFILNO 9 MINFILE_NUMBER
YEAR 4 YEAR
COMMOD_C 2 COMMODITY_CODE
QUANTITY 12 QUANTITYR19
MINFILNO 9 MINFILE_NUMBER
COMMOD_C 2 COMMODITY_CODER20
MINFILNO 9 MINFILE_NUMBER
MINCLA_C 1 MINERALOGY_CLASS_CODE
MINERL_C 4 MINERAL_CODER21
MINFILNO 9 MINFILE_NUMBER
ALTER_C 4 ALTERATION_CODER22
MINFILNO 9 MINFILE_NUMBER
DATMET_C 2 DATING_METHOD_CODE
ISOAGE 20 ISOTOPIC_AGE_MINERALIZATION
MATERIAL 30 MATERIAL_DATED_MINERALIZATIONR23
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_HOSTR24
MINFILNO 9 MINFILE_NUMBER
ST_AGE_C 3 MINERALIZATION_AGE_CODER25
MINFILNO 9 MINFILE_NUMBER
ROCK_T_C 4 ROCK_TYPE_CODE
ROCK_M_C 4 ROCK_MODIFIER_CODE
LITHUNIT 11 LITHOLOGICAL_UNITR26
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_ONR27
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_CODER28
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_CODER31
PROJ_NO 7 PROJECT_NUMBER
MINFILNO 9 MINFILE_NUMBERR32a
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_TARGETR32b
PROJ_NO 7 PROJECT_NUMBER
NOW_NO 9 NOTICE_NUMBER
WK_TODO 70 WORK_TO_DO
WK_DONE 70 WORK_DONER33
PROJ_NO 7 PROJECT_NUMBER
PRJTYP_C 1 PROJECT_TYPE_CODER34
PROJ_NO 7 PROJECT_NUMBER
NOW_NO 9 NOTICE_NUMBER
STAGE_C 1 MDAP_STAGE_CODER35
PROJ_NO 7 PROJECT_NUMBER
MINDIV_C 4 MINING_DIVISIONR36
PROJ_NO 7 PROJECT_NUMBER
NTSMAP_C 7 NTS_MAPR39
PROJ_NO 7 PROJECT_NUMBER
REGION_C 4 REGION_CODER40
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_COMMENTSC02
MINFILNO 9 MINFILE_NUMBER
SIGMIN_T 70 SIGNIFICANT_MINERALS_COMMENTSC03
MINFILNO 9 MINFILE_NUMBER
ASSMIN_T 70 ASSOCIATED_MINERALS_COMMENTSC04
MINFILNO 9 MINFILE_NUMBER
ALTMIN_T 70 ALTERATION_MINERALS_COMMENTSC05
MINFILNO 9 MINFILE_NUMBER
STRUCT_T 70 STRUCTURAL_COMMENTSC06
MINFILNO 9 MINFILE_NUMBER
HSTRCK_T 70 HOST_ROCK_COMMENTSC07
MINFILNO 9 MINFILE_NUMBER
META_T 70 METAMORPHISM_COMMENTC08
MINFILNO 9 MINFILE_NUMBER
CAPSUL_T 70 CAPSULE_GEOLOGY_COMMENTSC09
MINFILNO 9 MINFILE_NUMBER
BIBLIO_T 70 BIBLIOGRAPHY_COMMENTSC10
MINFILNO 9 MINFILE_NUMBER
YEAR 4 YEAR
PROD_T 66 PRODUCTION_COMMENTC11
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_COMMENTSC12
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_REFERENCEC13
MINFILNO 9 MINFILE_NUMBER
CONF_NOTE 70 CONFIDENTIAL_NOTESC14
PROJ_NO 7 PROJECT_NUMBER
EXPL_T 70 EXPLORATION_COMMENTS
NOTE:   All fields are character.         New to Version 4.5

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.