{ "table_id": 46425209, "partition_id": 46516999, "tablet_id": 46517018, "schema_hash": 288104777, "shard_id": 992, "creation_time": 1761183815, "cumulative_layer_point": -1, "tablet_state": "PB_RUNNING", "schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "card_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "telephone", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 22, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "user_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "channel_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "sex", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 12, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "nation", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 22, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "city_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "name": "zone_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 12, "name": "zone_name_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "name": "zone_id_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "address", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 15, "name": "origin_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 16, "name": "origin_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 17, "name": "age", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 18, "name": "birthday", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 19, "name": "telephone_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 20, "name": "remark_mobiles", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 12, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 21, "name": "machine_factory", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 22, "name": "machine_device", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 23, "name": "wework_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 12, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 24, "name": "wework_add_account", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 25, "name": "wework_follower_name", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 26, "name": "wework_follower_count", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 27, "name": "service_user_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 28, "name": "service_user_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 29, "name": "service_user_position", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 30, "name": "service_user_group", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 31, "name": "service_user_dept", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 32, "name": "service_user_dept_id_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 33, "name": "service_user_follow_wework_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 34, "name": "last_service_user_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 35, "name": "last_service_user_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "customer_life_cycle", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "default_value": "正常", "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 37, "name": "customer_lost_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 38, "name": "customer_lost_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 12, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 39, "name": "customer_pool", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "default_value": "[]", "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 40, "name": "assign_status", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "default_value": "0", "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 41, "name": "return_reason", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 42, "name": "plan_retrieve_date", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 43, "name": "plan_retrieve_reason", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 44, "name": "plan_retrieve_reason_text", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 45, "name": "is_eligible_for_retention", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 46, "name": "last_assigned_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 47, "name": "last_return_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 48, "name": "last_lock_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 49, "name": "last_unlock_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 50, "name": "customer_lock_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "default_value": "未锁定", "precision": 0, "frac": 0, "length": 12, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 51, "name": "customer_transfer_count", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 52, "name": "ins_last_order_duration", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 53, "name": "ins_last_order_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 54, "name": "ins_last_order_machine_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 55, "name": "ins_last_order_is_renew", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 56, "name": "ins_last_order_factory", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 57, "name": "ins_last_order_premium", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 58, "name": "ins_last_order_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 59, "name": "ins_last_order_start_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 60, "name": "ins_last_year_corn_machine_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 61, "name": "ins_last_year_corn_machine_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 62, "name": "ins_last_year_corn_machine_status_renewable", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 63, "name": "ins_last_year_wheat_machine_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 64, "name": "ins_last_year_wheat_machine_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 65, "name": "ins_last_year_wheat_machine_status_renewable", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 66, "name": "ins_last_year_tractor_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 67, "name": "ins_last_year_tractor_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 68, "name": "ins_last_year_tractor_status_renewable", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 69, "name": "ins_last_year_rice_machine_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 70, "name": "ins_last_year_rice_machine_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 71, "name": "ins_last_year_rice_machine_status_renewable", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 72, "name": "ins_last_year_silage_machine_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 73, "name": "ins_last_year_silage_machine_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 74, "name": "ins_last_year_silage_machine_status_renewable", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 75, "name": "ins_last_year_bander_machine_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 76, "name": "ins_last_year_bander_machine_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 77, "name": "ins_last_year_bander_machine_status_renewable", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 78, "name": "ins_last_year_other_machine_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 79, "name": "ins_last_year_other_machine_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 80, "name": "ins_last_year_other_machine_status_renewable", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 81, "name": "ins_last_year_business_type", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 82, "name": "ins_order_placed_year", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 7, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 83, "name": "ins_order_placed_month", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 7, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 84, "name": "ins_order_placed_machine_type", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 85, "name": "ins_order_placed_factory", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 86, "name": "ins_order_placed_count", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 87, "name": "ins_order_placed_count_last_year", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 88, "name": "ins_order_placed_count_curr_year", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 89, "name": "ins_order_placed_premium", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 90, "name": "ins_order_placed_premium_last_year", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 91, "name": "ins_order_placed_premium_curr_year", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 92, "name": "ins_order_renew_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 93, "name": "ins_order_renew_premium", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 94, "name": "ins_order_business_type_level", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 95, "name": "ins_claim_last_report_date", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 96, "name": "ins_claim_last_item", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 97, "name": "ins_claim_last_business_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 98, "name": "ins_claim_last_survey_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 99, "name": "ins_claim_last_claim_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 100, "name": "ins_claim_last_insurer", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 101, "name": "ins_claim_last_pay_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 102, "name": "ins_claim_report_count", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 103, "name": "ins_claim_count", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 104, "name": "ins_claim_count_last_year", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 105, "name": "ins_claim_count_curr_year", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 106, "name": "ins_claim_close_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 107, "name": "ins_claim_close_money_last_year", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 108, "name": "ins_claim_close_money_curr_year", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 109, "name": "finance_order_loan_count", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 110, "name": "finance_order_loan_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 111, "name": "finance_order_placed_year", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 7, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 112, "name": "finance_order_placed_month", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 7, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 113, "name": "finance_order_placed_machine_type", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 114, "name": "finance_order_placed_factory", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 115, "name": "repayment_plan_next_date", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 116, "name": "repayment_overdue_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 117, "name": "overdue_loan_balance", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 118, "name": "overdue_remain_capital", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 119, "name": "overdue_days", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 120, "name": "overdue_amount", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 121, "name": "last_call_date", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 122, "name": "last_call_user", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 123, "name": "last_call_days", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 124, "name": "last_call_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 125, "name": "last_call_intention", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 126, "name": "call_time_last_year", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 127, "name": "call_count_last_year", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 128, "name": "call_time", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 129, "name": "call_count", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 130, "name": "customer_level", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 131, "name": "create_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 132, "name": "create_user_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 133, "name": "update_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 134, "name": "version_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "default_value": "1", "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 135, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 136, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false } ], "num_short_key_columns": 1, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 137, "is_in_memory": false, "delete_sign_idx": 135, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 1, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": -1, "store_row_column": false, "enable_single_replica_compaction": false, "skip_write_index_on_load": false, "inverted_index_storage_format": "V1" }, "rs_metas": [ { "rowset_id": 0, "partition_id": 46516999, "tablet_id": 46517018, "tablet_schema_hash": 288104777, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 0, "end_version": 958, "num_rows": 2672, "total_disk_size": 279625, "data_disk_size": 279625, "index_disk_size": 20177, "empty": false, "creation_time": 1778116967, "tablet_uid": { "hi": 742698503219748671, "lo": 7728204141998943637 }, "num_segments": 1, "rowset_id_v2": "0200000000da33973e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1778108413, "segments_key_bounds": [ { "min_key": "\u0002\u0000\u0000\t", "max_key": "\u0002\u000E!\u0016" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "card_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "telephone", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 22, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "user_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "channel_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "sex", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 12, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "nation", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 22, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "city_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "name": "zone_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 12, "name": "zone_name_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "name": "zone_id_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "address", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 15, "name": "origin_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 16, "name": "origin_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 17, "name": "age", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 18, "name": "birthday", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 19, "name": "telephone_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 20, "name": "remark_mobiles", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 12, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 21, "name": "machine_factory", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 22, "name": "machine_device", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 23, "name": "wework_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 12, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 24, "name": "wework_add_account", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 25, "name": "wework_follower_name", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 26, "name": "wework_follower_count", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 27, "name": "service_user_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 28, "name": "service_user_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 29, "name": "service_user_position", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 30, "name": "service_user_group", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 31, "name": "service_user_dept", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 32, "name": "service_user_dept_id_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 33, "name": "service_user_follow_wework_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 34, "name": "last_service_user_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 35, "name": "last_service_user_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "customer_life_cycle", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "default_value": "正常", "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 37, "name": "customer_lost_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 38, "name": "customer_lost_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 12, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 39, "name": "customer_pool", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "default_value": "[]", "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 40, "name": "assign_status", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "default_value": "0", "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 41, "name": "return_reason", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 42, "name": "plan_retrieve_date", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 43, "name": "plan_retrieve_reason", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 44, "name": "plan_retrieve_reason_text", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 45, "name": "is_eligible_for_retention", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 46, "name": "last_assigned_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 47, "name": "last_return_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 48, "name": "last_lock_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 49, "name": "last_unlock_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 50, "name": "customer_lock_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "default_value": "未锁定", "precision": 0, "frac": 0, "length": 12, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 51, "name": "customer_transfer_count", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 52, "name": "ins_last_order_duration", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 53, "name": "ins_last_order_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 54, "name": "ins_last_order_machine_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 55, "name": "ins_last_order_is_renew", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 56, "name": "ins_last_order_factory", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 57, "name": "ins_last_order_premium", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 58, "name": "ins_last_order_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 59, "name": "ins_last_order_start_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 60, "name": "ins_last_year_corn_machine_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 61, "name": "ins_last_year_corn_machine_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 62, "name": "ins_last_year_corn_machine_status_renewable", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 63, "name": "ins_last_year_wheat_machine_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 64, "name": "ins_last_year_wheat_machine_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 65, "name": "ins_last_year_wheat_machine_status_renewable", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 66, "name": "ins_last_year_tractor_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 67, "name": "ins_last_year_tractor_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 68, "name": "ins_last_year_tractor_status_renewable", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 69, "name": "ins_last_year_rice_machine_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 70, "name": "ins_last_year_rice_machine_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 71, "name": "ins_last_year_rice_machine_status_renewable", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 72, "name": "ins_last_year_silage_machine_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 73, "name": "ins_last_year_silage_machine_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 74, "name": "ins_last_year_silage_machine_status_renewable", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 75, "name": "ins_last_year_bander_machine_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 76, "name": "ins_last_year_bander_machine_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 77, "name": "ins_last_year_bander_machine_status_renewable", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 78, "name": "ins_last_year_other_machine_time", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 79, "name": "ins_last_year_other_machine_business_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 80, "name": "ins_last_year_other_machine_status_renewable", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 81, "name": "ins_last_year_business_type", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 82, "name": "ins_order_placed_year", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 7, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 83, "name": "ins_order_placed_month", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 7, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 84, "name": "ins_order_placed_machine_type", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 85, "name": "ins_order_placed_factory", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 86, "name": "ins_order_placed_count", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 87, "name": "ins_order_placed_count_last_year", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 88, "name": "ins_order_placed_count_curr_year", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 89, "name": "ins_order_placed_premium", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 90, "name": "ins_order_placed_premium_last_year", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 91, "name": "ins_order_placed_premium_curr_year", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 92, "name": "ins_order_renew_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 93, "name": "ins_order_renew_premium", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 94, "name": "ins_order_business_type_level", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 95, "name": "ins_claim_last_report_date", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 96, "name": "ins_claim_last_item", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 97, "name": "ins_claim_last_business_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 98, "name": "ins_claim_last_survey_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 99, "name": "ins_claim_last_claim_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 100, "name": "ins_claim_last_insurer", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 101, "name": "ins_claim_last_pay_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 102, "name": "ins_claim_report_count", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 103, "name": "ins_claim_count", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 104, "name": "ins_claim_count_last_year", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 105, "name": "ins_claim_count_curr_year", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 106, "name": "ins_claim_close_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 107, "name": "ins_claim_close_money_last_year", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 108, "name": "ins_claim_close_money_curr_year", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 109, "name": "finance_order_loan_count", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 110, "name": "finance_order_loan_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 111, "name": "finance_order_placed_year", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 7, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 112, "name": "finance_order_placed_month", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 7, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 113, "name": "finance_order_placed_machine_type", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 114, "name": "finance_order_placed_factory", "type": "ARRAY", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": -1, "frac": -1, "length": 65535, "index_length": 65535, "visible": true, "children_columns": [ { "unique_id": -1, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false } ], "result_is_nullable": false }, { "unique_id": 115, "name": "repayment_plan_next_date", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 116, "name": "repayment_overdue_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 117, "name": "overdue_loan_balance", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 118, "name": "overdue_remain_capital", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 119, "name": "overdue_days", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 120, "name": "overdue_amount", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 11, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 138, "name": "repayment_interest_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 139, "name": "repayment_interest_transfer_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 140, "name": "repayment_interest_confirm_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 137, "name": "repayment_interest_status ", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 121, "name": "last_call_date", "type": "DATEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 122, "name": "last_call_user", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 123, "name": "last_call_days", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 124, "name": "last_call_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 125, "name": "last_call_intention", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 126, "name": "call_time_last_year", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 127, "name": "call_count_last_year", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 128, "name": "call_time", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 129, "name": "call_count", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 130, "name": "customer_level", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 131, "name": "create_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 132, "name": "create_user_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 133, "name": "update_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 134, "name": "version_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "default_value": "1", "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 135, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 136, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false } ], "num_short_key_columns": 1, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 137, "is_in_memory": false, "delete_sign_idx": 139, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 1, "compression_type": "LZ4F", "schema_version": 4, "disable_auto_compaction": false, "version_col_idx": 140, "store_row_column": false, "enable_single_replica_compaction": false, "skip_write_index_on_load": false, "inverted_index_storage_format": "V1" }, "segments_overlap_pb": "NONOVERLAPPING" } ], "in_restore_mode": false, "tablet_uid": { "hi": 742698503219748671, "lo": 7728204141998943637 }, "preferred_rowset_type": "BETA_ROWSET", "tablet_type": "TABLET_TYPE_DISK", "replica_id": 46517019, "delete_bitmap": {}, "enable_unique_key_merge_on_write": true, "binlog_config": { "enable": false, "ttl_seconds": 86400, "max_bytes": 9223372036854775807, "max_history_nums": 9223372036854775807 }, "compaction_policy": "size_based", "time_series_compaction_goal_size_mbytes": 1024, "time_series_compaction_file_count_threshold": 2000, "time_series_compaction_time_threshold_seconds": 3600, "time_series_compaction_empty_rowsets_threshold": 5, "time_series_compaction_level_threshold": 1 }