polls_item_category_master

Description

Table Definition

CREATE TABLE `polls_item_category_master` (
  `id` int NOT NULL AUTO_INCREMENT,
  `firsthierarchy` varchar(100) NOT NULL,
  `secondhierarchy` varchar(100) NOT NULL,
  `thirdhierarchy` varchar(100) NOT NULL,
  `fourthhierarchy` varchar(100) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `created_by` varchar(100) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  `updated_by` varchar(100) NOT NULL,
  `deleted_flag` varchar(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

Columns

Name	Type	Default	Nullable	Extra Definition	Children	Parents	Comment
id	int		false	auto_increment
firsthierarchy	varchar(100)		false
secondhierarchy	varchar(100)		false
thirdhierarchy	varchar(100)		false
fourthhierarchy	varchar(100)		false
created_at	datetime(6)		false
created_by	varchar(100)		false
updated_at	datetime(6)		false
updated_by	varchar(100)		false
deleted_flag	varchar(1)		false

Constraints

Name	Type	Definition
PRIMARY	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
PRIMARY	PRIMARY KEY (id) USING BTREE

Relations

Generated by tbls