当前位置：网站首页>MySQL common table structure

MySQL common table structure

2022-04-21 07:41:00 【Sound God】

Tree structure common table

CREATE TABLE `exam_question_study_ability` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT ' name ',
  `add_time` datetime NOT NULL COMMENT ' Add the time ',
  `parent_id` int(11) NOT NULL COMMENT ' The superior id',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;