|
# 设备台账
|
create table `product-inventory-management`.device_repair
|
(
|
id bigint auto_increment
|
primary key,
|
device_ledger_id varchar(255) not null comment '设备台账id',
|
repair_time timestamp null comment '报修日期',
|
repair_name varchar(255) not null comment '报修人',
|
remark varchar(255) not null comment '故障现象',
|
maintenance_name varchar not null comment '维修人',
|
maintenance_time timestamp null comment '维修时间',
|
maintenance_result varchar(255) null comment '维修结果',
|
status int default 0 comment '状态',
|
create_time datetime null comment '录入时间',
|
update_time datetime null comment '更新时间',
|
create_user varchar(255) not null comment '录入人',
|
update_user varchar(255) not null comment '更新人',
|
tenant_id bigint not null comment '租户id'
|
);
|
|
# 设备维修
|
create table `product-inventory-management`.device_ledger
|
(
|
id bigint auto_increment
|
primary key,
|
device_name varchar(255) not null comment '设备名称',
|
device_model varchar(255) not null comment '规格型号',
|
supplier_name varchar(255) not null comment '供应商',
|
unit varchar(255) not null comment '单位',
|
number decimal not null comment '数量',
|
tax_including_price_unit decimal not null comment '含税单价',
|
tax_including_price_total decimal not null comment '含税总价',
|
tax_rate decimal not null comment '税率',
|
un_tax_including_price_total decimal not null comment '不含税总价',
|
create_time timestamp null comment '录入时间',
|
update_time timestamp null comment '更新时间',
|
create_user varchar(255) not null comment '录入人',
|
update_user varchar(255) not null comment '更新人',
|
tenant_id bigint not null comment '租户id'
|
);
|
|
create table `product-inventory-management`.device_maintenance
|
(
|
id bigint auto_increment
|
primary key,
|
device_ledger_id varchar(255) not null comment '设备台账id',
|
maintenance__plan_time timestamp null comment '计划保养日期',
|
maintenance_actually_name varchar(255) not null comment '实际保养人',
|
maintenance_actually_time timestamp null comment '实际保养日期',
|
maintenance_result int not null default 0 comment '保养结果 0 维修 1 完好',
|
status int not null default 0 comment '状态 0 待保养 1 完结',
|
create_time datetime null comment '录入时间',
|
update_time datetime null comment '更新时间',
|
create_user varchar(255) not null comment '录入人',
|
update_user varchar(255) not null comment '更新人',
|
tenant_id bigint not null comment '租户id'
|
);
|
|
|
alter table purchase_ledger
|
add payment_method varchar(255) null;
|
alter table sales_ledger
|
add payment_method varchar(255) null;
|
|
|
alter table payment_registration
|
modify sale_ledger_id bigint default 0 null comment '销售台账id';
|
|
|
alter table ticket_registration
|
add enter_date timestamp null;
|
|
alter table product_record
|
add 列_name int null comment 'sale_ledger_projectI_id';
|
|
# 添加设备名称和规格型号
|
ALTER TABLE `product-inventory-management`.`device_repair`
|
ADD COLUMN `device_name` varchar(255) NULL AFTER `tenant_id`,
|
ADD COLUMN `device_model` varchar(255) NULL AFTER `device_name`;
|
|
ALTER TABLE `product-inventory-management`.`device_maintenance`
|
ADD COLUMN `device_name` varchar(255) NULL AFTER `tenant_id`,
|
ADD COLUMN `device_model` varchar(255) NULL AFTER `device_name`;
|
|
|
|
DROP TABLE IF EXISTS storage_attachment;
|
CREATE TABLE storage_attachment (
|
id BIGINT AUTO_INCREMENT PRIMARY KEY,
|
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
update_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
deleted BIGINT DEFAULT 0 NOT NULL,
|
record_type SMALLINT DEFAULT 0 NOT NULL,
|
record_id BIGINT DEFAULT 0 NOT NULL,
|
name VARCHAR(100) DEFAULT '' NOT NULL,
|
storage_blob_id BIGINT DEFAULT 0 NOT NULL
|
) COMMENT='通用文件上传的附件信息';
|
|
ALTER TABLE storage_attachment
|
COMMENT '通用文件上传的附件信息';
|
|
ALTER TABLE storage_attachment MODIFY record_type SMALLINT COMMENT '关联的记录类型';
|
ALTER TABLE storage_attachment MODIFY record_id BIGINT COMMENT '关联的记录id';
|
ALTER TABLE storage_attachment MODIFY name VARCHAR(100) COMMENT '名称, 如: file, avatar (区分同一条记录不同类型的附件)';
|
ALTER TABLE storage_attachment MODIFY storage_blob_id BIGINT COMMENT '关联storage_blob记录id';
|
|
CREATE INDEX idx_storage_attachment_on_record
|
ON storage_attachment (record_type, record_id);
|
|
|
CREATE TABLE storage_blob (
|
id BIGINT AUTO_INCREMENT PRIMARY KEY,
|
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
key_name VARCHAR(150) DEFAULT '' NOT NULL,
|
content_type VARCHAR(100) DEFAULT '' NOT NULL,
|
original_filename VARCHAR(255) DEFAULT '' NOT NULL,
|
bucket_filename VARCHAR(255) DEFAULT '' NOT NULL,
|
bucket_name VARCHAR(255) DEFAULT '' NOT NULL,
|
byte_size BIGINT DEFAULT 0 NOT NULL,
|
UNIQUE (key_name)
|
) COMMENT='通用文件上传的附件信息';
|
|
ALTER TABLE storage_blob
|
COMMENT '通用文件上传的附件信息';
|
|
ALTER TABLE storage_blob MODIFY key_name VARCHAR(150) COMMENT '资源id';
|
ALTER TABLE storage_blob MODIFY content_type VARCHAR(100) COMMENT '资源类型，例如JPG图片的资源类型为image/jpg';
|
ALTER TABLE storage_blob MODIFY original_filename VARCHAR(255) COMMENT '原文件名称';
|
ALTER TABLE storage_blob MODIFY bucket_filename VARCHAR(255) COMMENT '存储桶中文件名';
|
ALTER TABLE storage_blob MODIFY bucket_name VARCHAR(255) COMMENT '存储桶名';
|
ALTER TABLE storage_blob MODIFY byte_size BIGINT COMMENT '资源尺寸(字节)';
|
DROP TABLE IF EXISTS bid_winning_ledger;
|
CREATE TABLE bid_winning_ledger
|
(
|
id BIGINT AUTO_INCREMENT PRIMARY KEY,
|
status VARCHAR(100) NULL COMMENT '状态',
|
province VARCHAR(100) NULL COMMENT '省份',
|
city VARCHAR(100) NULL COMMENT '城市',
|
customer_name VARCHAR(255) NOT NULL COMMENT '客户名称',
|
contract_amount DECIMAL(18, 2) NULL COMMENT '合同金额',
|
bid_bond DECIMAL(18, 2) NULL COMMENT '投标保证金',
|
winning_service_fee DECIMAL(18, 2) NULL COMMENT '中标服务费',
|
industry VARCHAR(100) NULL COMMENT '行业',
|
business_source VARCHAR(100) NULL COMMENT '商机来源',
|
remark VARCHAR(1000) NULL COMMENT '备注',
|
entry_person VARCHAR(100) NULL COMMENT '录入人',
|
entry_date DATETIME NULL COMMENT '录入日期',
|
create_time DATETIME NULL COMMENT '创建时间',
|
create_user INT NULL COMMENT '创建用户',
|
update_time DATETIME NULL COMMENT '更新时间',
|
update_user INT NULL COMMENT '更新用户',
|
tenant_id BIGINT NULL COMMENT '租户id'
|
) COMMENT = '中标台账';
|
|
DROP TABLE IF EXISTS bid_winning_ledger_record;
|
CREATE TABLE bid_winning_ledger_record
|
(
|
id BIGINT AUTO_INCREMENT PRIMARY KEY,
|
bid_winning_ledger_id BIGINT NOT NULL COMMENT '中标台账id',
|
status VARCHAR(100) NULL COMMENT '状态',
|
description VARCHAR(2000) NULL COMMENT '记录内容',
|
entry_person VARCHAR(100) NULL COMMENT '录入人',
|
entry_date DATETIME NULL COMMENT '录入日期',
|
create_time DATETIME NULL COMMENT '创建时间',
|
create_user INT NULL COMMENT '创建用户',
|
update_time DATETIME NULL COMMENT '更新时间',
|
update_user INT NULL COMMENT '更新用户',
|
tenant_id BIGINT NULL COMMENT '租户id'
|
) COMMENT = '中标台账记录';
|
