github.com/easysoft/zendata@v0.0.0-20240513203326-705bd5a7fd67/test/tmp/1.yaml (about) 1 title: table op_report_sales_detail_day 2 desc: "" 3 fields: 4 - field: id 5 from: keys.yaml 6 use: op_report_sales_detail_day_id 7 - field: report_date 8 range: 20230421 000000-20230511 000000:24h 9 format: YY/MM/DD hh:mm:ss 10 type: timestamp 11 - field: media_platform 12 note: INI [0,2^32-1] 13 range: 1-5:R 14 - field: first_dept_id 15 note: INI [0,2^32-1] 16 range: 0-100000 17 - field: first_dept_name 18 range: VARCHAR 19 loop: "3" 20 loopfix: _ 21 - field: dept_id 22 note: INI [0,2^32-1] 23 range: 0-100000 24 - field: dept_name 25 range: VARCHAR 26 loop: "3" 27 loopfix: _ 28 - field: sales_id 29 note: INI [0,2^32-1] 30 range: 0-100000 31 - field: sales_user 32 range: VARCHAR 33 loop: "3" 34 loopfix: _ 35 - field: agent_company_name 36 range: VARCHAR 37 loop: "3" 38 loopfix: _ 39 - field: first_industry_id 40 range: VARCHAR 41 loop: "3" 42 loopfix: _ 43 - field: first_industry_name 44 range: VARCHAR 45 loop: "3" 46 loopfix: _ 47 - field: second_industry_id 48 range: VARCHAR 49 loop: "3" 50 loopfix: _ 51 - field: second_industry_name 52 range: VARCHAR 53 loop: "3" 54 loopfix: _ 55 - field: total_income_amount 56 note: DECIMAL 57 range: "123.45" 58 - field: total_profit_amount 59 note: DECIMAL 60 range: "123.45" 61 - field: tf_ad_income_amount 62 note: DECIMAL 63 range: "123.45" 64 - field: tf_ad_profit_amount 65 note: DECIMAL 66 range: "123.45" 67 - field: tf_qc_income_amount 68 note: DECIMAL 69 range: "123.45" 70 - field: tf_qc_profit_amount 71 note: DECIMAL 72 range: "123.45" 73 - field: tf_tx_income_amount 74 note: DECIMAL 75 range: "123.45" 76 - field: tf_tx_profit_amount 77 note: DECIMAL 78 range: "123.45" 79 - field: pp_ad_income_amount 80 note: DECIMAL 81 range: "123.45" 82 - field: pp_ad_profit_amount 83 note: DECIMAL 84 range: "123.45" 85 - field: pp_qc_income_amount 86 note: DECIMAL 87 range: 500.00-800.00:R 88 - field: pp_qc_profit_amount 89 note: DECIMAL 90 range: "123.45" 91 - field: dr_star_income_amount 92 note: DECIMAL 93 range: "123.45" 94 - field: dr_star_profit_amount 95 note: DECIMAL 96 range: "123.45" 97 - field: tf_bdt_income_amount 98 note: DECIMAL 99 range: "123.45" 100 - field: tf_bdt_profit_amount 101 note: DECIMAL 102 range: "123.45" 103 - field: tf_jc_income_amount 104 note: DECIMAL 105 range: "123.45" 106 - field: tf_jc_profit_amount 107 note: DECIMAL 108 range: "123.45" 109 - field: cost 110 note: DECIMAL 111 range: "123.45" 112 - field: cash_cost 113 note: DECIMAL 114 range: "123.45" 115 - field: grants_cost 116 note: DECIMAL 117 range: "123.45" 118 - field: create_time 119 range: 20210821 000000:60 120 format: YY/MM/DD hh:mm:ss 121 type: timestamp