样本信息表:dl_sample ============================ **样本信息表** **字段** +-------------------+----------+------+--------+----------+--------+---------------+ | 列名 | 类型 | 长度 | 小数点 | 是否非空 | 默认值 | 备注 | +===================+==========+======+========+==========+========+===============+ | id | bigint | 20 | 0 | not null | | 主键,自增 ID | +-------------------+----------+------+--------+----------+--------+---------------+ | sample_library_id | bigint | 20 | 0 | not null | | 样本库 ID | +-------------------+----------+------+--------+----------+--------+---------------+ | name | varchar | 255 | 0 | not null | | 样本名称 | +-------------------+----------+------+--------+----------+--------+---------------+ | path | varchar | 1000 | 0 | not null | | 样本存储路径 | +-------------------+----------+------+--------+----------+--------+---------------+ | creator_id | varchar | 255 | 0 | not null | | 创建人 ID | +-------------------+----------+------+--------+----------+--------+---------------+ | create_time | bigint | 20 | 0 | not null | | 创建时间 | +-------------------+----------+------+--------+----------+--------+---------------+ | updator_id | varchar | 255 | 0 | not null | | 修改人 ID | +-------------------+----------+------+--------+----------+--------+---------------+ | update_time | bigint | 20 | 0 | not null | | 修改时间 | +-------------------+----------+------+--------+----------+--------+---------------+ | state | int | 11 | 0 | not null | | 样本状态 | +-------------------+----------+------+--------+----------+--------+---------------+ | is_problem | tinyint | 11 | 0 | | | 是否有问题 | +-------------------+----------+------+--------+----------+--------+---------------+ | sample_code | longtext | 0 | 0 | | | 唯一编码 | +-------------------+----------+------+--------+----------+--------+---------------+ **索引** +------+----------+------+ | 字段 | 索引类型 | 备注 | +======+==========+======+ | id | PRIMARY | | +------+----------+------+ **建表语句** :: CREATE TABLE `dl_sample` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `sample_library_id` bigint(20) NOT NULL, `name` varchar(255) NOT NULL, `path` varchar(1000) NOT NULL, `creator_id` varchar(255) NOT NULL, `create_time` bigint(20) NOT NULL, `updator_id` varchar(255) NOT NULL, `update_time` bigint(20) NOT NULL, `state` int(11) NOT NULL DEFAULT 0, `is_problem` tinyint(11) DEFAULT NULL, `sample_code` longtext DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;