infopdata - Githubissues

gilienv / EssOilDB

Restructuring of Essential Oil Database

Apache License 2.0

8 stars 6 forks source link

Open ambarishK opened 4 years ago

ambarishK commented 4 years ago

issue for table - infopdata.

It is main table for plant information.

column header -

ipid - [PK]. [INT] pid - [FK]. [INT] locid - [FK]. [INT] biblioid - [FK]. [INT] scid - [FK]. [INT] profilecode - VARCHAR

petermr commented 4 years ago

REFACTOR

TABLE profile

COLUMNS profile_id plant_id (FK) location_id (FK) biblio_id (FK) date_id (FK) => MOVE to VALUE legacy_profile_id (JEA*..)

percent (NUMBER) or maybe range plantPart_id (FK) => MOVE to PROFILE condition_id (FK) => MOVE to PROFILE method_id (FK) => MOVE to PROFILE

method VARCHAR not normalized