<commit_before>rtShopOrderToStock:
  columns:
    quantity:                 { type: integer, default: 5 }
    stock_id:
      type: integer
      primary: true
    order_id:
      type: integer
      primary: true
  relations:
    rtShopOrder:              { onDelete: CASCADE, local: order_id, foreign: id }
    rtShopStock:              { onDelete: CASCADE, local: stock_id, foreign: id }


rtShopOrder:
  actAs:
    Timestampable:
      created:
        name:                created_at
        type:                timestamp
        format:              Y-m-d H:i:s
      updated:
        name:                updated_at
        type:                timestamp
        format:              Y-m-d H:i:s
    rtSearchTemplate:
      fields:                [voucher_code, email, notes_admin, notes_user, reference, payment_transaction_id, extended_search_data]
  columns:
    reference:                { type: string(255) }
    status:                   { type: string(255) }

    voucher_code:             { type: string(100) }

    email:                    { type: string(255) }
    
    notes_user:               { type: string }
    notes_admin:              { type: string }

    user_id:                  { type: integer }

    is_wholesale:             { type: boolean, default: false }
    
    closed_shipping_rate:     { type: float, default: 0.00 }
    closed_taxes:             { type: float, default: 0.00 }
    closed_promotions:        { type: float, default: 0.00 }
    closed_products:          { type: array(10000) }
    closed_total:             { type: float, default: 0.00 }

    payment_transaction_id:   { type: string(255) }
    payment_type:             { type: string(255) }
    payment_charge:           { type: float, default: 0.00 }
    payment_approved:         { type: integer, default: 0 }
    payment_response:         { type: string }
    
  relations:<commit_msg>Updated the order table to include refined columns<commit_after>rtShopOrder:
  actAs:
    Timestampable:
      created:
        name:                created_at
        type:                timestamp
        format:              Y-m-d H:i:s
      updated:
        name:                updated_at
        type:                timestamp
        format:              Y-m-d H:i:s
    rtSearchTemplate:
      fields:                [voucher_code, email, notes_admin, notes_user, reference, payment_transaction_id, extended_search_data]
  columns:

    # base values
    reference:                string(50)
    status:                   string(50)
    is_wholesale:             boolean
    email_address:            string(255)

    # user
    user_id:                  integer

    # shipping
    shipping_charge:          float

    # tax
    tax_charge:               float
    tax_component:            float
    tax_mode:                 string(50)
    tax_rate:                 float

    # promotion
    promotion_reduction:      float
    promotion_id:             integer
    promotion_data:           array(10000)

    # voucher
    voucher_reduction:        float
    voucher_id:               integer
    voucher_code:             string(50)
    voucher_data:             array(10000)

    # products
    products_data:            array(10000)

    # totals
    items_charge:             float
    total_charge:             float

    # payment
    payment_transaction_id:   string(255)
    payment_type:             string(255)
    payment_charge:           float
    payment_data:             array(10000)

    # notes
    notes_user:               string
    notes_admin:              string

  relations:
{'fraction_non_alphanumeric': 0.0725560786485738, 'fraction_numerical': 0.021323733037939628, 'mean_word_length': 1.3952254641909814, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7358602', 'n_tokens_mistral': 1074, 'n_tokens_neox': 977, 'n_words': 229}