table.sql

CREATE SCHEMA IF NOT EXISTS nse_query_builder;

CREATE TABLE nse_query_builder.saved_queries (
    id INT AUTO_INCREMENT PRIMARY KEY,
    query_name VARCHAR(100),
    sql_text TEXT,
    canvas_json JSON,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    created_by INT, 
    query_status VARCHAR(100)
);


CREATE TABLE nse_query_builder.dwh_table_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    columns JSON,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    access_codes VARCHAR(100)
);



CREATE TABLE nse_query_builder.dwh_rbac_users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    emp_id VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
-- Add access id based on role based controls 
    access_id VARCHAR(100),
    hashed_password VARCHAR(100)
);



CREATE TABLE nse_query_builder.query_queue (
    id INT AUTO_INCREMENT PRIMARY KEY,
    query_id INT FOREIGN KEY, 

);