| | |
|---|
| | | -- ---------------------------- |
|---|
| | | -- 系统上传文件表 |
|---|
| | | -- ---------------------------- |
|---|
| | | drop table if exists `smart_assess`.`sys_attach`; |
|---|
| | | CREATE TABLE `smart_assess`.`sys_attach` ( |
|---|
| | | `id` bigint NOT NULL AUTO_INCREMENT, |
|---|
| | | `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件名称', |
|---|
| | | `path` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件存放路径', |
|---|
| | | `type` tinyint NOT NULL COMMENT '文件所属类型(1社保，2医保，3工资单)', |
|---|
| | | `user_id` bigint NOT NULL COMMENT '用户id', |
|---|
| | | `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建人', |
|---|
| | | `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人', |
|---|
| | | `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, |
|---|
| | | `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新人', |
|---|
| | | `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '更新人', |
|---|
| | | `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
|---|
| | | PRIMARY KEY (`id`) USING BTREE, |
|---|
| | | UNIQUE INDEX `index_name`(`name`) USING BTREE |
|---|
