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+ );
0 commit comments