SELECT *
FROM "plotMetadata"
LEFT JOIN "lookup_MethodCode" USING ("MethodCode")
;

ALTER TABLE :table ADD PRIMARY KEY ("PlotID");