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