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.
82 lines
3.2 KiB
82 lines
3.2 KiB
create table supplier_diff_allow
|
|
(
|
|
id int,
|
|
org_id int not null,
|
|
cor_type_id int not null,
|
|
diff_allow boolean default true not null
|
|
)
|
|
comment '差异配置';
|
|
|
|
create unique index supplier_diff_allow_id_uindex
|
|
on supplier_diff_allow (id);
|
|
|
|
alter table supplier_diff_allow
|
|
add constraint supplier_diff_allow_pk
|
|
primary key (id);
|
|
|
|
alter table supplier_diff_allow
|
|
modify id int auto_increment;
|
|
|
|
alter table supplier_matching_log
|
|
add REASON VARCHAR(255) null;
|
|
|
|
create table concur_event_log
|
|
(
|
|
id bigint,
|
|
entry_id varchar(50) null,
|
|
filepath varchar(255) null,
|
|
original_path varchar(255) null,
|
|
create_time datetime null
|
|
)
|
|
comment 'concur event log';
|
|
|
|
create unique index concur_event_log_id_uindex
|
|
on concur_event_log (id);
|
|
|
|
alter table concur_event_log
|
|
add constraint concur_event_log_pk
|
|
primary key (id);
|
|
|
|
alter table concur_event_log
|
|
modify id bigint auto_increment;
|
|
|
|
CREATE TABLE `mileage`
|
|
(
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
|
`name` varchar(255) DEFAULT NULL,
|
|
`money` double DEFAULT NULL COMMENT '金额',
|
|
`currency` varchar(50) DEFAULT NULL COMMENT '币种',
|
|
`mileage_sum` double NOT NULL DEFAULT '0' COMMENT '总里程',
|
|
`mileage_date` datetime DEFAULT NULL COMMENT '里程日期',
|
|
`mileage_date_sum` varchar(255) DEFAULT NULL COMMENT '耗时总计',
|
|
`location_start` varchar(255) DEFAULT NULL COMMENT '起点',
|
|
`location_end` varchar(255) DEFAULT NULL COMMENT '终点',
|
|
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0/未完成 1/已完成',
|
|
`used_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0/未使用 1/已使用',
|
|
`user_id` int(11) NOT NULL,
|
|
`create_time` datetime DEFAULT NULL,
|
|
`update_time` datetime DEFAULT NULL,
|
|
`mileage_sum_affirm` double NOT NULL DEFAULT '0' COMMENT '确认里程数',
|
|
`remark` varchar(255) DEFAULT NULL,
|
|
`image` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB
|
|
AUTO_INCREMENT = 1669
|
|
DEFAULT CHARSET = utf8;
|
|
|
|
CREATE TABLE `mileage_detail`
|
|
(
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
|
`mileage_id` bigint(20) NOT NULL COMMENT '里程ID',
|
|
`sort` int NOT NULL DEFAULT '0' COMMENT '里程顺序 0为起点',
|
|
`title` varchar(255) DEFAULT NULL COMMENT '地点名称',
|
|
`longitude` double DEFAULT NULL COMMENT '经度',
|
|
`latitude` double DEFAULT NULL COMMENT '纬度',
|
|
`distance` double NOT NULL DEFAULT '0' COMMENT '与上一个地点的距离',
|
|
`arrive_time` datetime DEFAULT NULL COMMENT '到达该地点时间',
|
|
`create_time` datetime DEFAULT NULL,
|
|
`update_time` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB
|
|
AUTO_INCREMENT = 1669
|
|
DEFAULT CHARSET = utf8 COMMENT ='里程途径地点细节';
|