17 lines
780 B
SQL
17 lines
780 B
SQL
CREATE TABLE `supplier_file` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`fileId` varchar(191) NOT NULL,
|
|
`supplierId` varchar(191) DEFAULT NULL,
|
|
`fileName` varchar(191) NOT NULL,
|
|
`objectName` varchar(500) NOT NULL,
|
|
`bucketName` varchar(191) NOT NULL,
|
|
`contentType` varchar(100) DEFAULT NULL,
|
|
`fileSize` int DEFAULT NULL,
|
|
`createTime` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
|
`updateTime` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
|
|
`deleted` int NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `supplier_file_fileId_key` (`fileId`),
|
|
KEY `supplier_file_supplierId_deleted_idx` (`supplierId`,`deleted`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='供应商文件存储记录';
|