CREATE TABLE IF NOT EXISTS ls.production_order
(
    "Suchschluessel" text COLLATE pg_catalog."default" NOT NULL,
    "Grund_der_Ausloesung_Beschreibung" text COLLATE pg_catalog."default",
    "Produktionsplan_Name" text COLLATE pg_catalog."default",
    "Produktionsplan_Suchschluessel" text COLLATE pg_catalog."default",
    "Status" text COLLATE pg_catalog."default",
    "Freigabe" text COLLATE pg_catalog."default",
    "Startdatum" text COLLATE pg_catalog."default",
    "Enddatum" text COLLATE pg_catalog."default",
    "Arbeitsgang_Arbeitsanweisung" text COLLATE pg_catalog."default",
    "Arbeitsgang_Artikelname" text COLLATE pg_catalog."default",
    "Arbeitsgang_Artikelnummer" text COLLATE pg_catalog."default",
    "Arbeitsgang_Menge" text COLLATE pg_catalog."default",
    "Arbeitsgang_Rohmaterial" text COLLATE pg_catalog."default",
    ret_forms text COLLATE pg_catalog."default",
    ret_materials text COLLATE pg_catalog."default",
    ret_dim_1 integer,
    "Bestelldatum" text COLLATE pg_catalog."default",
    "Kunden_ID" text COLLATE pg_catalog."default",
    "Kundenprioritaet" integer,
    "order" integer,
    clusters integer,
    chunk_id integer,
    prio double precision,
    erfassungspunkt text COLLATE pg_catalog."default",
    CONSTRAINT production_order_pkey1 PRIMARY KEY ("Suchschluessel")
);