CREATE TABLE IF NOT EXISTS `p_vehicle_info` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`plate_number` varchar(50) NOT NULL COMMENT '车牌号',
|
`dept_id` bigint(20) DEFAULT NULL COMMENT '所属销售团队（部门ID）',
|
`user_id` bigint(20) DEFAULT NULL COMMENT '责任人ID（用户ID）',
|
`vehicle_status` varchar(20) DEFAULT 'NORMAL' COMMENT '车辆状态(NORMAL:在用, IDLE:闲置, REPAIR:维修)',
|
`property_ownership` varchar(50) DEFAULT NULL COMMENT '产权所有',
|
`inspection_expire_date` date DEFAULT NULL COMMENT '年检到期日期',
|
`insurance_expire_date` date DEFAULT NULL COMMENT '保险到期日期',
|
`remark` varchar(500) DEFAULT NULL COMMENT '备注',
|
`create_user` bigint(20) DEFAULT NULL COMMENT '创建人',
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
`update_user` bigint(20) DEFAULT NULL COMMENT '更新人',
|
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
`tenant_id` varchar(20) DEFAULT NULL COMMENT '租户ID',
|
`del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
|
PRIMARY KEY (`id`),
|
UNIQUE KEY `idx_plate_number` (`plate_number`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='车辆档案表';
|
|
CREATE TABLE IF NOT EXISTS `p_vehicle_cost` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`vehicle_id` bigint(20) NOT NULL COMMENT '车辆ID',
|
`cost_type` varchar(20) NOT NULL COMMENT '费用类型(MAINTENANCE:保养, INSPECTION:年检, INSURANCE:保险, REPAIR:维修)',
|
`amount` decimal(10,2) NOT NULL COMMENT '费用金额',
|
`cost_date` date NOT NULL COMMENT '发生日期',
|
`remark` varchar(500) DEFAULT NULL COMMENT '备注/详情',
|
`create_user` bigint(20) DEFAULT NULL,
|
`create_time` datetime DEFAULT NULL,
|
`update_user` bigint(20) DEFAULT NULL,
|
`update_time` datetime DEFAULT NULL,
|
`tenant_id` varchar(20) DEFAULT NULL,
|
`del_flag` char(1) DEFAULT '0',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='车辆费用记录表';
|
|
CREATE TABLE IF NOT EXISTS `p_fuel_card` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`card_number` varchar(100) NOT NULL COMMENT '加油卡号',
|
`dept_id` bigint(20) DEFAULT NULL COMMENT '所属团队(部门ID)',
|
`issuer` varchar(100) DEFAULT NULL COMMENT '发卡单位',
|
`initial_balance` decimal(10,2) DEFAULT '0.00' COMMENT '期初余额',
|
`current_balance` decimal(10,2) DEFAULT '0.00' COMMENT '当前剩余余额',
|
`status` varchar(20) DEFAULT 'ACTIVE' COMMENT '状态(ACTIVE:正常, CANCELLED:注销)',
|
`remark` varchar(500) DEFAULT NULL COMMENT '备注',
|
`create_user` bigint(20) DEFAULT NULL,
|
`create_time` datetime DEFAULT NULL,
|
`update_user` bigint(20) DEFAULT NULL,
|
`update_time` datetime DEFAULT NULL,
|
`tenant_id` varchar(20) DEFAULT NULL,
|
`del_flag` char(1) DEFAULT '0',
|
PRIMARY KEY (`id`),
|
UNIQUE KEY `idx_card_number` (`card_number`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='加油卡管理表';
|
|
CREATE TABLE IF NOT EXISTS `p_fuel_record` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`fuel_date` date NOT NULL COMMENT '加油日期',
|
`amount` decimal(10,2) NOT NULL COMMENT '加油金额',
|
`liters` decimal(10,2) NOT NULL COMMENT '加油升数',
|
`vehicle_id` bigint(20) NOT NULL COMMENT '加油车辆ID',
|
`fuel_card_id` bigint(20) NOT NULL COMMENT '加油卡ID',
|
`start_mileage` decimal(12,2) DEFAULT NULL COMMENT '起始公里数',
|
`end_mileage` decimal(12,2) DEFAULT NULL COMMENT '结束公里数',
|
`invoice_no` varchar(100) DEFAULT NULL COMMENT '发票号码',
|
`remark` varchar(500) DEFAULT NULL COMMENT '备注',
|
`create_user` bigint(20) DEFAULT NULL,
|
`create_time` datetime DEFAULT NULL,
|
`update_user` bigint(20) DEFAULT NULL,
|
`update_time` datetime DEFAULT NULL,
|
`tenant_id` varchar(20) DEFAULT NULL,
|
`del_flag` char(1) DEFAULT '0',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='加油记录表';
|
