You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
44 lines
1.9 KiB
44 lines
1.9 KiB
4 weeks ago
|
create table asset_type(
|
||
|
|
id bigint primary key auto_increment comment '自增id',
|
||
|
|
name varchar(32) comment '资产类型',
|
||
|
|
create_time datetime default current_timestamp comment '创建时间',
|
||
|
|
del_flag char(1) default '0' comment '是否删除，0未删除，1已删除'
|
||
|
|
) comment '资产管理-资产类型';
|
||
|
|
|
||
|
|
create table asset_position(
|
||
|
|
id bigint primary key auto_increment comment '自增id',
|
||
|
|
name varchar(32) comment '位置名称',
|
||
|
|
create_time datetime default current_timestamp comment '创建时间',
|
||
|
|
del_flag char(1) default '0' comment '是否删除，0未删除，1已删除'
|
||
|
|
) comment '资产管理-资产位置信息';
|
||
|
|
|
||
|
|
create table asset_base_info(
|
||
|
|
id bigint primary key auto_increment comment '自增id',
|
||
|
|
type_id int comment '资产类型id',
|
||
|
|
name varchar(128) comment '资产名称',
|
||
|
|
position_id bigint comment '存放位置id',
|
||
|
|
total_num int comment '资产总数',
|
||
|
|
request_num int default 0 comment '领用记录',
|
||
|
|
create_time datetime default current_timestamp comment '创建日期',
|
||
|
|
del_flag char(1) default '0' comment '0未删除，1已删除'
|
||
|
|
) comment '资产管理-资产信息表';
|
||
|
|
|
||
|
|
create table asset_handle_record(
|
||
|
|
id bigint primary key auto_increment comment '自增id',
|
||
|
|
base_info_id bigint comment '资产信息id',
|
||
|
|
request_num int comment '领用数量',
|
||
|
|
request_person_name int comment '领用人id',
|
||
|
|
request_date date comment '领用日期',
|
||
|
|
create_time datetime default current_timestamp comment '创建日期',
|
||
|
|
del_flag char(1) default '0' comment '0未删除，1已删除'
|
||
|
|
) comment '资产管理-领用记录表';
|
||
|
|
|
||
|
|
/*
|
||
|
|
create table asset_person(
|
||
|
|
id bigint primary key auto_increment comment '自增id',
|
||
|
|
name varchar(64) comment '资产维护人员名称',
|
||
|
|
create_time datetime comment '创建时间',
|
||
|
|
del_flag char(1) comment '是否删除，0未删除，1已删除'
|
||
|
|
) comment '资产维护人员信息';
|
||
|
|
*/
|