CREATE DATABASE  IF NOT EXISTS `db_gallerize` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `db_gallerize`;
--
-- Host: localhost    Database: db_gallerize
-- ------------------------------------------------------


--
-- Table structure for table `tbl_category_master`
--

CREATE TABLE `tbl_category_master` (
  `Category_Master_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Category_Master` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`Category_Master_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_category_master`
--

INSERT INTO `tbl_category_master` VALUES (1,'Diamond'),(2,'Women\'s Rings'),(3,'Men\'s Rings'),(4,'Earring'),(5,'Necklace'),(6,'Bracelet');

--
-- Table structure for table `tbl_product_master`
--

CREATE TABLE `tbl_product_master` (
  `Product_Master_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Category_Master_ID` int(11) DEFAULT NULL,
  `Product_Name` varchar(45) DEFAULT NULL,
  `Description` varchar(250) DEFAULT NULL,
  `Price` float DEFAULT NULL,
  `Is_Active` tinyint(4) DEFAULT NULL,
  `Is_Deleted` tinyint(4) DEFAULT NULL,
  `Entry_Date` datetime DEFAULT NULL,
  `Last_Modified_Date` datetime DEFAULT NULL,
  `CreatedBy` varchar(45) DEFAULT NULL,
  `ModifiedBy` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`Product_Master_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_product_master`
--

INSERT INTO `tbl_product_master` VALUES (1,3,'sgse','vh',100,1,0,'2024-10-01 14:40:03',NULL,'Admin',NULL),(2,3,'rfgv','jh',100,1,0,'2024-10-01 14:47:44',NULL,'Admin',NULL),(3,3,'rfgv','jhbh',100,1,0,'2024-10-01 14:52:49',NULL,'Admin',NULL),(4,2,'dgghf','fgtfcdt',10,1,0,'2024-10-01 15:05:07',NULL,'Admin',NULL),(5,2,'ffrhx','rghfrt',99,1,0,'2024-10-01 15:06:16',NULL,'Admin',NULL),(6,2,'sefdz','zxgfc',100,1,0,'2024-10-01 15:26:28',NULL,'Admin',NULL),(7,2,'drgdfgzd','ghdrg',5654560,1,0,'2024-10-01 16:20:53',NULL,'Admin',NULL),(8,2,'sdrga','zzzzzzz',0,1,0,'2024-10-01 16:21:57',NULL,'Admin',NULL),(9,2,'jhuk','fyu',54,1,0,'2024-10-01 16:27:56',NULL,'Admin',NULL),(10,2,'w4y','ws4y',321,1,0,'2024-10-01 16:28:50',NULL,'Admin',NULL);

--
-- Table structure for table `tbl_product_variants_relation`
--

CREATE TABLE `tbl_product_variants_relation` (
  `Product_Variants_Relation_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Product_Master_ID` int(11) DEFAULT NULL,
  `Variants_Item_ID` int(11) DEFAULT NULL,
  `Price_Difference` float DEFAULT NULL,
  `Is_Active` tinyint(4) DEFAULT NULL,
  `Is_Deleted` tinyint(4) DEFAULT NULL,
  `Entry_Date` datetime DEFAULT NULL,
  `Last_Modified_Date` datetime DEFAULT NULL,
  `CreatedBy` varchar(45) DEFAULT NULL,
  `ModifiedBy` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`Product_Variants_Relation_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_product_variants_relation`
--


--
-- Table structure for table `tbl_variants`
--

CREATE TABLE `tbl_variants` (
  `Variants_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Category_Master_ID` int(11) DEFAULT NULL,
  `Variant` varchar(45) DEFAULT NULL,
  `Is_Img_Required` tinyint(4) DEFAULT NULL,
  `Is_Active` tinyint(4) DEFAULT NULL,
  `Is_Deleted` tinyint(4) DEFAULT NULL,
  `Entry_Date` datetime DEFAULT NULL,
  `Last_Modified_Date` datetime DEFAULT NULL,
  `CreatedBy` varchar(45) DEFAULT NULL,
  `ModifiedBy` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`Variants_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_variants`
--

INSERT INTO `tbl_variants` VALUES (1,2,'Metal',1,1,0,'2024-09-30 11:10:17','2024-09-30 11:10:17','prayagpaneliya@gmail.com','prayagpaneliya@gmail.com'),(2,3,'Size',0,1,0,'2024-09-30 11:10:31','2024-09-30 11:10:31','prayagpaneliya@gmail.com','prayagpaneliya@gmail.com'),(3,2,'Type',1,1,0,'2024-09-30 11:10:40','2024-09-30 11:10:40','prayagpaneliya@gmail.com','prayagpaneliya@gmail.com');

--
-- Table structure for table `tbl_variants_item`
--

CREATE TABLE `tbl_variants_item` (
  `Variants_Item_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Variants_ID` int(11) DEFAULT NULL,
  `Item` varchar(45) DEFAULT NULL,
  `Item_Img` varchar(45) DEFAULT NULL,
  `Is_Active` tinyint(4) DEFAULT NULL,
  `Is_Deleted` tinyint(4) DEFAULT NULL,
  `Entry_Date` datetime DEFAULT NULL,
  `Last_Modified_Date` datetime DEFAULT NULL,
  `CreatedBy` varchar(45) DEFAULT NULL,
  `ModifiedBy` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`Variants_Item_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_variants_item`
--

INSERT INTO `tbl_variants_item` VALUES (1,1,'Gold','e307c48d-d0af-46bb-9a61-b8c59ff17084.jpg',1,0,'2024-09-30 11:10:57','2024-09-30 11:10:57','prayagpaneliya@gmail.com','prayagpaneliya@gmail.com'),(2,1,'Silver','9cc9ce11-1ea4-4464-8db8-6e8d4f59afa6.jpg',1,0,'2024-09-30 11:11:13','2024-09-30 11:11:13','prayagpaneliya@gmail.com','prayagpaneliya@gmail.com'),(3,2,'6',NULL,1,0,'2024-09-30 16:58:36','2024-09-30 16:58:36','prayagpaneliya@gmail.com','prayagpaneliya@gmail.com'),(4,2,'9',NULL,1,0,'2024-09-30 16:58:41','2024-09-30 16:58:41','prayagpaneliya@gmail.com','prayagpaneliya@gmail.com');


