-- Table: dump2.meetwaarden

-- DROP TABLE dump2.meetwaarden;

CREATE TABLE IF NOT EXISTS dump2.meetwaarden
(
  "Meetobject.Namespace" character varying(6),
  "Meetobject.lokaalID" character varying(36),
  "GeoObject.lokaalID" character varying(15),
  namespace character varying(6),
  "Monstertype.id" character varying(15),
  "MonsterCompartiment.code" character varying(2),
  "Orgaan.code" character varying(2),
  "Organisme.naam" character varying(50),
  begindiepte_m double precision,
  einddiepte_m double precision,
  "Referentievlak.code" character varying(30),
  "Monsterbewerkingsmethode.code" character varying(30),
  "Monsterbewerkingsmethode.codespace" character varying(100),
  "Bemonsteringsmethode.code" character varying(255),
  "Bemonsteringsmethode.codespace" character varying(100),
  "Bemonsteringssoort.code" character varying(30),
  "Monstercriterium.code" character varying(30),
  "Bemonsteringsapparaat.code" character varying(30),
  "Bemonsteringsapparaat.codespace" character varying(30),
  monsterophaaldatum date,
  monsterophaaltijd time without time zone,
  tijd_utcoffset character varying(6),
  gerelateerdmonsterobject character varying(30),
  "GerelateerdMonsterobjectRol.id" character varying(15),
  "GeometriePunt.X" double precision,
  "GeometriePunt.Y" double precision,
  "Referentiehorizontaal.code" character varying(30),
  "Monster.Opmerking" character varying(124),
  "Meetwaarde.lokaalID" character varying(30),
  begindatum date NOT NULL,
  begintijd time without time zone,
  einddatum date,
  eindtijd time without time zone,
  resultaatdatum date NOT NULL,
  resultaattijd time without time zone,
  "Typering.code" character varying(30),
  "Grootheid.code" character varying(30),
  "Parameter.code" character varying(30),
  "Parameter.omschrijving" character varying (100),  
  "Biotaxon.naam" character varying(50),
  "Hoedanigheid.code" character varying(30),
  "AnalyseCompartiment.code" character varying(30),
  "Levensstadium.code" character varying(30),
  "Lengteklasse.code" character varying(30),
  "Geslacht.code" character varying(30),
  "Verschijningsvorm.code" character varying(30),
  "Levensvorm.code" character varying(30),
  "Gedrag.code" character varying(30),
  limietsymbool character varying(1),
  numeriekewaarde double precision,
  alfanumeriekewaarde character varying(30),
  "Eenheid.code" character varying(30) NOT NULL,
  "Waardebewerkingsmethode.code" character varying(30),
  "Waardebewerkingsmethode.codespace" character varying(30),
  "Waardebepalingsmethode.code" character varying(30),
  "Waardepalingsmethode.codespace" character varying(30),
  "Waardebepalingstechniek.code" character varying(30),
  "Kwaliteitsoordeel.code" character varying(30),
  gerelateerdobservatieobject character varying(30),
  "GerelateerdObservatieobjectRol.id" character varying(15),
  "Meetapparaat.omschrijving" character varying(90),
  "Meetapparaat.code" character varying(30),
  "Meetapparaat.codespace" character varying(30),
  "Meetinstantie.code" character varying(30),
  "Meetinstantie.codespace" character varying(30),
  "LocatieTypeWaardeBepaling.id" character varying(15),
  volgnummer character varying(30),
  meetwaardeopmerking character varying(500),
  recovery character varying(30),
  spread character varying(30),
  measurementuncertainty character varying(30),
  "Z-score" character varying(30),
  drift character varying(30),
  "AutomatedControl.code" character varying(30),
  "ExpertControl.code" character varying(30),
  "ValidationScore.code" character varying(30),
  "Dataset.naam" character varying(180)
)
WITH (
  OIDS=FALSE
);
