search

earthchem / EarthChemAdmin2

Admin tools for Earthchem database person, organization, affiliation, citation
Apache License 2.0
0 stars 0 forks source link

New dev environment for ecdbAdmin to support creating sampling feature entry for different curationEntity, like PetDB, tephra, etc. #7

Open sparkji opened 5 years ago

sparkji commented 5 years ago

New dev environment has been setup repository: working on new branch 'tephra'. database: jdbc:postgresql://dev-ecdb-vm.earthchem.org:5432/ecdb_tephra URL:http://dev-ecdb-vm.earthchem.org:8080/Tephra/faces/ECAdmin.xhtml

kelseymarkey commented 5 years ago

The fields necessary for Tephra are: VOLCANO_SOURCE, VOLCANO_NUMER, ERUPTION, FORMATION, MEMBER, TEPHRA_COMMENT, TEPHRA_DEPOSIT, TEPHRA_THICKNESS, TEPHRA_GRAIN_SIZE, TEPHRA_FRESH_COLOR, TEPHRA_ALTERED_COLOR

Perhaps we might also need a TEPHRA_THICKNESS UNIT column for the units related to field "TEPHRA_THICKNESS"?

I reached out to the investigators working on the project to find out if each of these fields will be free text or controlled.

sparkji commented 5 years ago

@bhchen8 tephra related annotation_type has been added. select ce.curation_entity_code,ag.annotation_group_description,at.annotation_type_name from annotation_type_group atg, annotation_type at,curation_entity ce,annotation_group ag where atg.annotation_group_num=ag.annotation_group_num and atg.annotation_type_num=at.annotation_type_num and atg.curation_entity_num=ce.curation_entity_num and ce.curation_entity_num=2

curation_entity_code annotation_group_description annotation_type_name
Tephra Specimen VocanoSource
Tephra Specimen VocanoNumber
Tephra Specimen Eruption
Tephra Specimen Formation
Tephra Specimen Member
Tephra Specimen TehpraUnit
Tephra Specimen TephraThickness
Tephra Specimen GrainSize
Tephra Specimen FreshColor
Tephra Specimen AlteredColor
sparkji commented 5 years ago

@kelseymarkey could you please provide some examples filled with real content for testing.