18 lines
960 B
SQL
18 lines
960 B
SQL
CREATE TABLE IF NOT EXISTS gxmu_wxxzx_archive_record (
|
||
id BIGINT AUTO_INCREMENT PRIMARY KEY COMMENT '主键ID',
|
||
project_id INT NOT NULL COMMENT '未来学术之星项目ID',
|
||
archive_order INT NULL COMMENT '排序号',
|
||
award_name VARCHAR(255) NULL COMMENT '获奖名称',
|
||
award_time VARCHAR(30) NULL COMMENT '获奖时间',
|
||
remark TEXT NULL COMMENT '备注说明',
|
||
proof_file VARCHAR(500) NULL COMMENT '上传凭证',
|
||
year INT NULL COMMENT '年度',
|
||
user_id BIGINT NULL COMMENT '用户ID',
|
||
tenant_id BIGINT NULL COMMENT '租户ID',
|
||
deleted INT DEFAULT 0 COMMENT '删除标记：0未删 1已删',
|
||
create_time DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
INDEX idx_wxxzx_archive_project_id (project_id),
|
||
INDEX idx_wxxzx_archive_year (year)
|
||
) COMMENT='未来学术之星成果归档记录';
|