Project

General

Profile

« Previous | Next » 

Revision 7793

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/FIA/*/postprocess.sql: UNIQUE constraint: Added UNITCD because although it may not be needed to scope PLOT, it is present in all the core tables and thus must be part of the joins' USING columns

View differences:

inputs/FIA/PLOT/postprocess.sql
1 
ALTER TABLE :table ADD UNIQUE ("STATECD", "COUNTYCD", "PLOT", "INVYR");
1 
ALTER TABLE :table ADD UNIQUE ("STATECD", "UNITCD", "COUNTYCD", "PLOT", "INVYR");
inputs/FIA/COND/postprocess.sql
1 
ALTER TABLE :table ADD UNIQUE ("STATECD", "COUNTYCD", "PLOT", "INVYR", "CONDID");
1 
ALTER TABLE :table ADD UNIQUE ("STATECD", "UNITCD", "COUNTYCD", "PLOT", "INVYR", "CONDID");
inputs/FIA/TREE/postprocess.sql
1 
-- ("STATECD", "COUNTYCD", "PLOT", "INVYR", "CONDID", "SUBP", "TREE", "STATUSCD") is not unique
1 
-- ("STATECD", "UNITCD", "COUNTYCD", "PLOT", "INVYR", "CONDID", "SUBP", "TREE", "STATUSCD") is not unique
2 2 
ALTER TABLE "FIA"."TREE" ADD UNIQUE ("CN");
inputs/FIA/SUBPLOT/postprocess.sql
1 
ALTER TABLE :table ADD UNIQUE ("STATECD", "COUNTYCD", "PLOT", "INVYR", "SUBP");
1 
ALTER TABLE :table ADD UNIQUE ("STATECD", "UNITCD", "COUNTYCD", "PLOT", "INVYR", "SUBP");

Also available in: Unified diff