222

-- test.people definition

CREATE TABLE `people` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`name` varchar(60) DEFAULT NULL,
`age` int DEFAULT NULL,
`metrics_id` bigint unsigned DEFAULT NULL COMMENT '指标ID',
`address` varchar(100) DEFAULT NULL,
`gender` tinyint DEFAULT NULL,
`create_date` date NOT NULL DEFAULT (curdate()),
PRIMARY KEY (`id`),
UNIQUE KEY `uk_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

’