create_tables.sql

-- Tables for User Details
CREATE TABLE user_details (
    user_id serial PRIMARY KEY, 
    username VARCHAR ( 255 ) UNIQUE NOT NULL, 
    name VARCHAR(255) , 
    gitToken VARCHAR ( 255 ) NOT NULL, 
    key VARCHAR(255) UNIQUE, 
    email VARCHAR ( 255 ) UNIQUE, 
    created_at TIMESTAMP NOT NULL DEFAULT now(), 
    recent_login_at TIMESTAMP NOT NULL
);

-- Table for Deployment Details
CREATE TABLE deployment_details (
    id serial PRIMARY KEY, 
	name VARCHAR ( 255 ) UNIQUE NOT NULL,
	recent_update_at TIMESTAMP NOT NULL
);

-- Table for Kit Details
CREATE TABLE kit_details(
    id serial PRIMARY KEY,
	name VARCHAR( 255 ) NOT NULL,
	version VARCHAR( 255 ) NOT NULL,
	deployment_id int NOT NULL,
	deployed_by VARCHAR( 255 ),
	deployed_at VARCHAR( 255 ) NOT NULL,
	features VARCHAR( 255 ),
	is_dev INT,
	sync_with_github BOOLEAN,
	recent_update_at TIMESTAMP NOT NULL,
	UNIQUE (name, deployment_id),
	CONSTRAINT fk_kit_deployment
		FOREIGN KEY ( deployment_id )
		REFERENCES deployment_details ( id )
);

-- Table for Quickviews
CREATE TABLE quickviews(
	id serial PRIMARY KEY,
	user_name VARCHAR ( 255 ) NOT NULL,
	name VARCHAR( 255 ) NOT NULL,
	created_at TIMESTAMP NOT NULL DEFAULT now(),
	UNIQUE(name,user_name),
	CONSTRAINT fk_quickviews
		FOREIGN KEY ( user_name )
		REFERENCES user_details ( username )

);

-- Table for Quickviews Values
CREATE TABLE quickviews_values(
	id serial PRIMARY KEY,
	quickview_id INT NOT NULL,
	qv_value VARCHAR( 255 ) NOT NULL,
	qv_value_type VARCHAR( 255 ) NOT NULL,
	created_at TIMESTAMP NOT NULL DEFAULT now(),
	CONSTRAINT fk_quickview_values
		FOREIGN KEY ( quickview_id )
		REFERENCES quickviews ( id ) 
);
------Table for Deployment deatils from the GitHub Repo -------
CREATE TABLE deployment_details_github(
	id serial PRIMARY KEY,
	deployment_name VARCHAR ( 255 ) NOT NULL,
	kit_name VARCHAR(255) NOT NULL,
	deployment_id int NOT NULL,
	version VARCHAR( 255 ) NOT NULL,
	deployed_by VARCHAR( 255 ),
	deployed_at VARCHAR( 255 ) NOT NULL,
	features VARCHAR( 255 ),
	is_dev INT,
	recent_update_at TIMESTAMP NOT NULL,
    UNIQUE (kit_name, deployment_id),
	CONSTRAINT fk_kit_deployment
		FOREIGN KEY ( deployment_id )
		REFERENCES deployment_details ( id )

)