Skip to content

Commit b1ac131

Browse files
add lingjian's case of create view (apache#139)
# Checklist * 内部Jira: http://39.106.86.136:8090/browse/CIR-1792 http://39.106.86.136:8090/browse/CIR-1746 * 修复PR: * master: apache#17815 * 1.2-lts: * 1.1-lts: * Doris-master: * [x] 已修复 * [ ] 未修复 * [ ] 无问题 * Doris-1.2-lts: * [ ] 已修复 * [x] 未修复 * [ ] 无问题 * Doris-1.1-lts: * [ ] 已修复 * [x] 未修复 * [ ] 无问题 Co-authored-by: smallhibiscus <844981280>
1 parent 72958f7 commit b1ac131

22 files changed

Lines changed: 4710 additions & 2 deletions
Lines changed: 94 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,94 @@
1+
CREATE TABLE `LCM_tradeapp_member_order` (
2+
`id` varchar(100) NOT NULL COMMENT "",
3+
`payment_amount` varchar(100) REPLACE NULL COMMENT "",
4+
`payment_freight` varchar(100) REPLACE NULL COMMENT "",
5+
`actual_freight` varchar(100) REPLACE NULL COMMENT "",
6+
`order_amount` varchar(100) REPLACE NULL COMMENT "",
7+
`sn` varchar(200) REPLACE NULL COMMENT "",
8+
`address_id` varchar(100) REPLACE NULL COMMENT "",
9+
`ground_discount` varchar(100) REPLACE NULL COMMENT "",
10+
`ground_freight` varchar(100) REPLACE NULL COMMENT "",
11+
`remark` varchar(2000) REPLACE NULL COMMENT "",
12+
`order_status` varchar(100) REPLACE NULL COMMENT "",
13+
`point` varchar(100) REPLACE NULL COMMENT "",
14+
`point_discount` varchar(100) REPLACE NULL COMMENT "",
15+
`point_discount_goods` varchar(100) REPLACE NULL COMMENT "",
16+
`customer_get_time` varchar(100) REPLACE NULL COMMENT "",
17+
`create_date` varchar(100) REPLACE NULL COMMENT "",
18+
`complete_date` varchar(100) REPLACE NULL COMMENT "",
19+
`send_date` varchar(100) REPLACE NULL COMMENT "",
20+
`first_order` varchar(100) REPLACE NULL COMMENT "",
21+
`discount_amount` varchar(100) REPLACE NULL COMMENT "",
22+
`store_id` varchar(100) REPLACE NULL COMMENT "",
23+
`member` varchar(2000) REPLACE NULL COMMENT "",
24+
`payment_id` varchar(100) REPLACE NULL COMMENT "",
25+
`office_id` varchar(400) REPLACE NULL COMMENT "",
26+
`is_register` varchar(100) REPLACE NULL COMMENT "",
27+
`address_detail` varchar(4000) REPLACE NULL COMMENT "",
28+
`operation_note` varchar(2000) REPLACE NULL COMMENT "",
29+
`order_type` varchar(100) REPLACE NULL COMMENT "",
30+
`settlement_status` varchar(100) REPLACE NULL COMMENT "",
31+
`member_name` varchar(800) REPLACE NULL COMMENT "",
32+
`coupon_discount` varchar(100) REPLACE NULL COMMENT "",
33+
`shopping_type` varchar(100) REPLACE NULL COMMENT "",
34+
`item_detail` varchar(10000) REPLACE NULL COMMENT "",
35+
`push_state` varchar(100) REPLACE NULL COMMENT "",
36+
`audit_status` varchar(100) REPLACE NULL COMMENT "",
37+
`cancel_date` varchar(100) REPLACE NULL COMMENT "",
38+
`cancel_source` varchar(100) REPLACE NULL COMMENT "",
39+
`settlement_date` varchar(100) REPLACE NULL COMMENT "",
40+
`label` varchar(100) REPLACE NULL COMMENT "",
41+
`customer_id` varchar(2000) REPLACE NULL COMMENT "",
42+
`coupon_name` varchar(2000) REPLACE NULL COMMENT "",
43+
`coupon_id` varchar(100) REPLACE NULL COMMENT "",
44+
`is_store_coupon` varchar(100) REPLACE NULL COMMENT "",
45+
`freight_coupon_id` varchar(100) REPLACE NULL COMMENT "",
46+
`freight_coupon_name` varchar(2000) REPLACE NULL COMMENT "",
47+
`freight_coupon_amount` varchar(100) REPLACE NULL COMMENT "",
48+
`logistic_company_id` varchar(100) REPLACE NULL COMMENT "",
49+
`is_trusteeship` varchar(100) REPLACE NULL COMMENT "",
50+
`parent_order_sn` varchar(200) REPLACE NULL COMMENT "",
51+
`check_status` varchar(100) REPLACE NULL COMMENT "",
52+
`voucher_coupon_amount` varchar(100) REPLACE NULL COMMENT "",
53+
`voucher_coupon_amount_goods` varchar(100) REPLACE NULL COMMENT "",
54+
`is_history` varchar(100) REPLACE NULL COMMENT "",
55+
`effective_date` varchar(100) REPLACE NULL COMMENT "",
56+
`updated_time` varchar(100) REPLACE NULL COMMENT "",
57+
`feed` varchar(50) REPLACE NULL COMMENT "",
58+
`systemdbname` varchar(20) REPLACE NULL COMMENT "",
59+
`systemkey` varchar(20) REPLACE NULL COMMENT "",
60+
`isdeleted` varchar(20) REPLACE NULL COMMENT "",
61+
`maximporteddt` varchar(30) REPLACE NULL COMMENT "",
62+
`firstinserteddt` varchar(30) MIN NULL COMMENT "",
63+
`lastupdateddt` varchar(30) REPLACE NULL COMMENT "",
64+
`tenant_id` varchar(1000) REPLACE NULL COMMENT "",
65+
`exclusive_point_amount` varchar(100) REPLACE NULL COMMENT "",
66+
`invoice_with_goods_kind` varchar(100) REPLACE NULL COMMENT "",
67+
`customer_ip` varchar(1000) REPLACE NULL COMMENT "",
68+
`point_switch` varchar(100) REPLACE NULL COMMENT "",
69+
`updated_by_name` varchar(1000) REPLACE NULL COMMENT "",
70+
`app_user_id` varchar(1000) REPLACE NULL COMMENT "",
71+
`updated_by` varchar(100) REPLACE NULL COMMENT "",
72+
`created_by_name` varchar(1000) REPLACE NULL COMMENT "",
73+
`created_by` varchar(100) REPLACE NULL COMMENT "",
74+
`source_type` varchar(100) REPLACE NULL COMMENT "",
75+
`client_type` varchar(100) REPLACE NULL COMMENT "",
76+
`cancel_reason` varchar(50) REPLACE NULL DEFAULT "NULL" COMMENT "",
77+
`purchase_no` varchar(800) REPLACE NULL DEFAULT "" COMMENT "",
78+
`wallet_freight_amount` varchar(50) REPLACE NULL DEFAULT "0.00" COMMENT "",
79+
`wallet_product_amount` varchar(50) REPLACE NULL DEFAULT "0.00" COMMENT "",
80+
`wallet_total_amount` varchar(50) REPLACE NULL DEFAULT "0.00" COMMENT "",
81+
`is_member_freight_coupon` varchar(50) REPLACE NULL DEFAULT "0" COMMENT "",
82+
`real_customer_id` varchar(200) REPLACE NULL DEFAULT "" COMMENT "",
83+
`identity_number` varchar(200) REPLACE NULL DEFAULT "" COMMENT "",
84+
`is_send_appoint_point` varchar(50) REPLACE NULL DEFAULT "0" COMMENT "",
85+
`contain_need_auth_sku` varchar(50) REPLACE NULL DEFAULT "0" COMMENT ""
86+
) ENGINE=OLAP
87+
AGGREGATE KEY(`id`)
88+
COMMENT "OLAP"
89+
DISTRIBUTED BY HASH(`id`) BUCKETS 10
90+
PROPERTIES (
91+
"replication_allocation" = "tag.location.default: 1",
92+
"in_memory" = "false",
93+
"storage_format" = "V2"
94+
);
Lines changed: 52 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,52 @@
1+
CREATE TABLE `LCM_tradeapp_order_distribute_item` (
2+
`id` varchar(100) NOT NULL COMMENT "",
3+
`order_sn` varchar(200) REPLACE NULL COMMENT "",
4+
`order_item_id` varchar(100) REPLACE NULL COMMENT "",
5+
`sku_id` varchar(100) REPLACE NULL COMMENT "",
6+
`sku_type` varchar(100) REPLACE NULL COMMENT "",
7+
`price` varchar(100) REPLACE NULL COMMENT "",
8+
`number` varchar(100) REPLACE NULL COMMENT "",
9+
`subtotal` varchar(100) REPLACE NULL COMMENT "",
10+
`lc_sku_code` varchar(200) REPLACE NULL COMMENT "",
11+
`name` varchar(400) REPLACE NULL COMMENT "",
12+
`specification` varchar(8000) REPLACE NULL COMMENT "",
13+
`unit` varchar(80) REPLACE NULL COMMENT "",
14+
`promotion_amount` varchar(100) REPLACE NULL COMMENT "",
15+
`coupon_amount` varchar(100) REPLACE NULL COMMENT "",
16+
`other_amount` varchar(100) REPLACE NULL COMMENT "",
17+
`point_amount` varchar(100) REPLACE NULL COMMENT "",
18+
`voucher_coupon_amount` varchar(100) REPLACE NULL COMMENT "",
19+
`package_tail_amount` varchar(100) REPLACE NULL COMMENT "",
20+
`current_agree_price` varchar(100) REPLACE NULL COMMENT "",
21+
`combination_sku` varchar(100) REPLACE NULL COMMENT "",
22+
`category3st_id` varchar(100) REPLACE NULL COMMENT "",
23+
`purchase_property` varchar(100) REPLACE NULL COMMENT "",
24+
`gifts_type` varchar(100) REPLACE NULL COMMENT "",
25+
`out_sku_num` varchar(100) REPLACE NULL COMMENT "",
26+
`refund_sku_num` varchar(100) REPLACE NULL COMMENT "",
27+
`return_sku_num` varchar(100) REPLACE NULL COMMENT "",
28+
`agree_price_type` varchar(100) REPLACE NULL COMMENT "",
29+
`promotion_id` varchar(100) REPLACE NULL COMMENT "",
30+
`large_sku_id` varchar(100) REPLACE NULL COMMENT "",
31+
`promotion_rule_id` varchar(100) REPLACE NULL COMMENT "",
32+
`customer_refund_sku_num` varchar(100) REPLACE NULL COMMENT "",
33+
`feed` varchar(50) REPLACE NULL COMMENT "",
34+
`systemdbname` varchar(20) REPLACE NULL COMMENT "",
35+
`systemkey` varchar(20) REPLACE NULL COMMENT "",
36+
`isdeleted` varchar(20) REPLACE NULL COMMENT "",
37+
`maximporteddt` varchar(30) REPLACE NULL COMMENT "",
38+
`firstinserteddt` varchar(30) MIN NULL COMMENT "",
39+
`lastupdateddt` varchar(30) REPLACE NULL COMMENT "",
40+
`exclusive_point_amount` varchar(100) REPLACE NULL COMMENT "",
41+
`member_discount_amount` varchar(50) REPLACE NULL DEFAULT "0.00" COMMENT "",
42+
`wallet_product_amount` varchar(50) REPLACE NULL DEFAULT "0.00" COMMENT "",
43+
`is_member_point_product` varchar(50) REPLACE NULL DEFAULT "0" COMMENT ""
44+
) ENGINE=OLAP
45+
AGGREGATE KEY(`id`)
46+
COMMENT "OLAP"
47+
DISTRIBUTED BY HASH(`id`) BUCKETS 10
48+
PROPERTIES (
49+
"replication_allocation" = "tag.location.default: 1",
50+
"in_memory" = "false",
51+
"storage_format" = "V2"
52+
);
Lines changed: 75 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,75 @@
1+
CREATE TABLE `LCM_tradeapp_order_item` (
2+
`id` varchar(100) NOT NULL COMMENT "",
3+
`sku_id` varchar(100) REPLACE NULL COMMENT "",
4+
`name` varchar(400) REPLACE NULL COMMENT "",
5+
`price` varchar(100) REPLACE NULL COMMENT "",
6+
`number` varchar(100) REPLACE NULL COMMENT "",
7+
`payment_amount` varchar(100) REPLACE NULL COMMENT "",
8+
`item_status` varchar(100) REPLACE NULL COMMENT "",
9+
`member_order_id` varchar(100) REPLACE NULL COMMENT "",
10+
`send_time` varchar(100) REPLACE NULL COMMENT "",
11+
`point_discount` varchar(100) REPLACE NULL COMMENT "",
12+
`category_1st_id` varchar(100) REPLACE NULL COMMENT "",
13+
`category_2st_id` varchar(100) REPLACE NULL COMMENT "",
14+
`category_3st_id` varchar(100) REPLACE NULL COMMENT "",
15+
`brand_id` varchar(100) REPLACE NULL COMMENT "",
16+
`code` varchar(200) REPLACE NULL COMMENT "",
17+
`lc_core` varchar(400) REPLACE NULL COMMENT "",
18+
`agree_price` varchar(100) REPLACE NULL COMMENT "",
19+
`agree_price_type` varchar(100) REPLACE NULL COMMENT "",
20+
`storage_condition` varchar(200) REPLACE NULL COMMENT "",
21+
`production_number` varchar(200) REPLACE NULL COMMENT "",
22+
`expiration_date` varchar(100) REPLACE NULL COMMENT "",
23+
`delivery_time` varchar(100) REPLACE NULL COMMENT "",
24+
`remark` varchar(1020) REPLACE NULL COMMENT "",
25+
`apply_after_sales` varchar(100) REPLACE NULL COMMENT "",
26+
`purchase_property` varchar(100) REPLACE NULL COMMENT "",
27+
`contrasting_relations` varchar(10000) REPLACE NULL COMMENT "",
28+
`coupon_name` varchar(2000) REPLACE NULL COMMENT "",
29+
`coupon_id` varchar(100) REPLACE NULL COMMENT "",
30+
`promotion_name` varchar(2000) REPLACE NULL COMMENT "",
31+
`promotion_id` varchar(100) REPLACE NULL COMMENT "",
32+
`coupon_amount` varchar(100) REPLACE NULL COMMENT "",
33+
`promotion_amount` varchar(100) REPLACE NULL COMMENT "",
34+
`other_amount` varchar(100) REPLACE NULL COMMENT "",
35+
`refund_number` varchar(100) REPLACE NULL COMMENT "",
36+
`subtotal` varchar(100) REPLACE NULL COMMENT "",
37+
`platform_price` varchar(100) REPLACE NULL COMMENT "",
38+
`bottom_price` varchar(100) REPLACE NULL COMMENT "",
39+
`gifts_type` varchar(100) REPLACE NULL COMMENT "",
40+
`settle_price` varchar(100) REPLACE NULL COMMENT "",
41+
`limit_sale_id` varchar(100) REPLACE NULL COMMENT "",
42+
`factory_limited_type` varchar(100) REPLACE NULL COMMENT "",
43+
`apportionment_amount` varchar(100) REPLACE NULL COMMENT "",
44+
`point_num` varchar(100) REPLACE NULL COMMENT "",
45+
`promotion_rule_id` varchar(100) REPLACE NULL COMMENT "",
46+
`updated_time` varchar(1000) REPLACE NULL COMMENT "",
47+
`created_time` varchar(1000) REPLACE NULL COMMENT "",
48+
`feed` varchar(50) REPLACE NULL COMMENT "",
49+
`systemdbname` varchar(20) REPLACE NULL COMMENT "",
50+
`systemkey` varchar(20) REPLACE NULL COMMENT "",
51+
`isdeleted` varchar(20) REPLACE NULL COMMENT "",
52+
`maximporteddt` varchar(30) REPLACE NULL COMMENT "",
53+
`firstinserteddt` varchar(30) MIN NULL COMMENT "",
54+
`lastupdateddt` varchar(30) REPLACE NULL COMMENT "",
55+
`exclusive_point_amount` varchar(100) REPLACE NULL COMMENT "",
56+
`negotiated_price_type` varchar(100) REPLACE NULL COMMENT "",
57+
`transaction_price` varchar(100) REPLACE NULL COMMENT "",
58+
`limited_time_price_id` varchar(100) REPLACE NULL COMMENT "",
59+
`member_discount_amount` varchar(50) REPLACE NULL DEFAULT "0.00" COMMENT "",
60+
`is_member_point_product` varchar(50) REPLACE NULL DEFAULT "0" COMMENT "",
61+
`trial_activity_id` varchar(50) REPLACE NULL DEFAULT "0" COMMENT "",
62+
`marketing_id` varchar(50) REPLACE NULL DEFAULT "0" COMMENT "",
63+
`marketing_type` varchar(50) REPLACE NULL DEFAULT "0" COMMENT "",
64+
`is_can_apply_ground_discount` varchar(50) REPLACE NULL DEFAULT "1" COMMENT "",
65+
`promotion_version` varchar(50) REPLACE NULL DEFAULT "0" COMMENT "",
66+
`order_sn` varchar(200) REPLACE NULL DEFAULT "" COMMENT ""
67+
) ENGINE=OLAP
68+
AGGREGATE KEY(`id`)
69+
COMMENT "OLAP"
70+
DISTRIBUTED BY HASH(`id`) BUCKETS 10
71+
PROPERTIES (
72+
"replication_allocation" = "tag.location.default: 1",
73+
"in_memory" = "false",
74+
"storage_format" = "V2"
75+
);

0 commit comments

Comments
 (0)