polls_judge_history_detail

Description

Table Definition

CREATE TABLE `polls_judge_history_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ng_flag` varchar(1) NOT NULL,
  `judge_history_id` varchar(100) NOT NULL,
  `judge_result` varchar(15000) NOT NULL,
  `text` longtext NOT NULL,
  `file_path` varchar(100) NOT NULL,
  `judged_file_path` varchar(100) NOT NULL,
  `item_category_id` varchar(500) 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,
  `MarkingPosition` longtext,
  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
ng_flag	varchar(1)		false
judge_history_id	varchar(100)		false
judge_result	varchar(15000)		false
text	longtext		false
file_path	varchar(100)		false
judged_file_path	varchar(100)		false
item_category_id	varchar(500)		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
MarkingPosition	longtext		true

Constraints

Name	Type	Definition
PRIMARY	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
PRIMARY	PRIMARY KEY (id) USING BTREE

Relations

Generated by tbls