NAV_WHERE - Retriever Where Table

Apr 26, 2024

CREATE OR REPLACE TABLE K3S_5WEB.NAV_WHERE (    
"WID" INT GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),
    "user_id" INTEGER NOT NULL,
    "table" VARCHAR(50) NOT NULL,
    "where_clause" VARCHAR(255) NOT NULL,
    "name" VARCHAR(50) UNIQUE NOT NULL,
    PRIMARY KEY ("user_id","name"));

---