Now-and-wow NPM

now-and-wow

go to the main folder

npm install

#To Run backend

npm run server

#To Run frontend

npm run client

#To Run the project

npm run dev

######### DATABASE ###########

CREATE TABLE users ( user_id int8 NOT NULL GENERATED ALWAYS AS IDENTITY( INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1 NO CYCLE), username varchar NOT NULL, "password" varchar NOT NULL, full_name varchar NOT NULL, email varchar NOT NULL, first_reg_date date NOT NULL, last_modified_date date NOT NULL, created_by varchar NOT NULL, delete_yn bool NOT NULL DEFAULT false, admin_yn bool NOT NULL, CONSTRAINT user_id_pk PRIMARY KEY (user_id) );

INSERT INTO users ( user_id , username , "password" , full_name , email , first_reg_date , last_modified_date , created_by , delete_yn , admin_yn ) VALUES( 18 , 'admin' , '$2a$10$0PzGTOo.Gujls1J4S4UWguEx/TUfOiJa2lw.m1jyhhUQb3ESfDe82' , 'admin' , 'admin@gmail.com' , '2024-01-04' , '2024-01-04' , 'SUPER_USER' , FALSE , TRUE );

CREATE TABLE exchange_rate ( exch_id int8 NOT NULL GENERATED ALWAYS AS IDENTITY( INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1 NO CYCLE), exch_currency varchar NOT NULL, exch_description varchar NULL, exch_base_xrt numeric NOT NULL, seq_no int8 NOT NULL, first_reg_date date NULL, last_modified_date date NULL, modified_by varchar NULL, created_by varchar NULL, CONSTRAINT exchange_rate_pk PRIMARY KEY (exch_currency, seq_no) );

CREATE TABLE main_category ( category_id int8 NOT NULL GENERATED ALWAYS AS IDENTITY( INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1 NO CYCLE), category_name varchar NOT NULL, isdeleted bool NOT NULL DEFAULT false, created_date date NULL, modified_date date NULL, created_by varchar NULL, modified_by varchar NULL, CONSTRAINT main_category_pk PRIMARY KEY (category_id) );

CREATE TABLE sub_category ( sub_category_id int8 NOT NULL GENERATED ALWAYS AS IDENTITY( INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1 NO CYCLE), sub_category_name varchar NOT NULL, isdeleted bool NOT NULL DEFAULT false, category_id int8 NOT NULL, created_date date NULL, modified_date date NULL, created_by varchar NULL, modified_by varchar NULL, CONSTRAINT sub_category_pk PRIMARY KEY (sub_category_id), CONSTRAINT sub_category_fk FOREIGN KEY (category_id) REFERENCES main_category(category_id) );

CREATE TABLE product_m ( product_id int8 NOT NULL GENERATED ALWAYS AS IDENTITY( INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1 NO CYCLE), sub_category_id int8 NOT NULL, product_name varchar NOT NULL, image_path varchar NULL, first_reg_date date NOT NULL, last_modified_date date NOT NULL, created_by varchar NOT NULL, modfied_by varchar NOT NULL, isdeleted_yn bool NULL DEFAULT false, CONSTRAINT product_m_pk PRIMARY KEY (product_id), CONSTRAINT product_m_fk FOREIGN KEY (sub_category_id) REFERENCES sub_category(sub_category_id) );