polls_ngword_master

Description

Table Definition
CREATE TABLE `polls_ngword_master` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ngword` varchar(100) NOT NULL,
  `reason` longtext NOT NULL,
  `item_category_id` varchar(1000) 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,
  `alternative` longtext NOT NULL,
  `firsthierarchy` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

Columns

NameTypeDefaultNullableExtra DefinitionChildrenParentsComment
idintfalseauto_increment
ngwordvarchar(100)false
reasonlongtextfalse
item_category_idvarchar(1000)false
created_atdatetime(6)false
created_byvarchar(100)false
updated_atdatetime(6)false
updated_byvarchar(100)false
deleted_flagvarchar(1)false
alternativelongtextfalse
firsthierarchyvarchar(100)false

Constraints

NameTypeDefinition
PRIMARYPRIMARY KEYPRIMARY KEY (id)

Indexes

NameDefinition
PRIMARYPRIMARY KEY (id) USING BTREE

Relations

er


Generated by tbls