不好意思,前两天请假了。DDL如下:
1、/* ApplicationName=DataGrip 2021.1 */ CREATE VIEW tPart
(base_id
, part_code
, part_name
, vppd
, partOwner
, partDept
, tpm_user_id
, major_code
,
sup_code
, sup_name
)
AS
SELECT base_id
,
part_code
,
part_name
,
vppd
,
dre_user_id
AS partOwner
,
duty_dept_id
AS partDept
,
tpm_user_id
,
major_code
,
sup_code
,
sup_name
FROM db1
.problem_part_info_bir
UNION ALL
SELECT base_id
,
part_code
,
part_name
,
vppd
,
dre_user_id
AS partOwner
,
duty_dept_id
AS partDept
,
tpm_user_id
,
major_code
,
sup_code
,
sup_name
FROM db1
.problem_part_info_brp
UNION ALL
SELECT base_id
,
part_code
,
part_name
,
vppd
,
dre_user_id
AS partOwner
,
duty_dept_id
AS partDept
,
tpm_user_id
,
major_code
,
sup_code
,
sup_name
FROM db1
.problem_part_info_fir
UNION ALL
SELECT base_id
,
part_code
,
part_name
,
vppd
,
dre_user_id
AS partOwner
,
duty_dept_id
AS partDept
,
tpm_user_id
,
major_code
,
sup_code
,
sup_name
FROM db1
.problem_part_info_pcr
UNION ALL
SELECT base_id
,
part_code
,
part_name
,
vppd
,
dre_user_id
AS partOwner
,
duty_dept_id
AS partDept
,
tpm_user_id
,
major_code
,
sup_code
,
sup_name
FROM db1
.problem_part_info_pir
UNION ALL
SELECT base_id
,
part_code
,
part_name
,
vppd
,
dre_user_id
AS partOwner
,
duty_dept_id
AS partDept
,
tpm_user_id
,
major_code
,
sup_code
,
sup_name
FROM db1
.problem_part_info_sir
UNION ALL
SELECT base_id
,
part_code
,
part_name
,
vppd
,
dre_user_id
AS partOwner
,
duty_dept_id
AS partDept
,
tpm_user_id
,
major_code
,
sup_code
,
sup_name
FROM db1
.problem_part_info_tir_con
UNION ALL
SELECT base_id
,
part_code
,
part_name
,
vppd
,
dre_user_id
AS partOwner
,
duty_dept_id
AS partDept
,
tpm_user_id
,
major_code
,
sup_code
,
sup_name
FROM db1
.problem_part_info_tir_veh
2、/* ApplicationName=DataGrip 2021.1 */ CREATE VIEW tCar
(base_id
, car_vin
, car_mileage
) AS
SELECT base_id
, car_vin
, car_mileage
FROM db1
.problem_car_info_bir
UNION ALL
SELECT base_id
, car_vin
, car_mileage
FROM db1
.problem_car_info_brp
UNION ALL
SELECT base_id
, car_vin
, trouble_mileage
AS car_mileage
FROM db1
.problem_car_info_fir
UNION ALL
SELECT base_id
, car_vin
, car_mileage
FROM db1
.problem_car_info_pcr
UNION ALL
SELECT base_id
, car_vin
, car_mileage
FROM db1
.problem_car_info_pir
UNION ALL
SELECT base_id
, car_vin
, car_mileage
FROM db1
.problem_car_info_sir
UNION ALL
SELECT base_id
, car_vin
, car_mileage
FROM db1
.problem_car_info_tir_veh
基础表就是普通的表和字段类型。