.jeeves.yaml

Mygento:
  Kkm:
    TransactionAttempt:
      readonly: true
      comment: 'Table for kkm transaction attempts'
      columns:
        id:
          type: int
          pk: true
          identity: true
          unsigned: true
          comment: 'Attempt ID'
        order_id:
          type: int
          nullable: false
          unsigned: true
          comment: 'Order id'
        store_id:
            type: int
            nullable: false
            unsigned: true
            comment: 'Store id'
        txn_type:
          type: varchar
          length: 15
          nullable: true
          comment: 'Txn Type'
        operation:
          type: smallint
          nullable: false
          comment: 'Operation type. Sell or Refund.'
          length: 10
        sales_entity_id:
          type: int
          nullable: false
          unsigned: true
          comment: 'Invoice or Creditmemo id'
        sales_entity_increment_id:
          type: varchar
          length: 50
          nullable: false
          comment: 'Invoice or Creditmemo increment id'
        status:
          type: smallint
        message:
          type: text
          nullable: true
        number_of_trials:
          type: smallint
          nullable: false
          default: 0
          comment: 'Count of attempts to make KKM transaction'
        total_number_of_trials:
          type: smallint
          nullable: false
          default: 0
          comment: 'Total count of attempts to make KKM transaction'
        created_at:
          type: timestamp
          nullable: false
          default: 'CURRENT_TIMESTAMP'
          comment: 'Create time'
          on_update: false
        updated_at:
          type: timestamp
          nullable: false
          default: 'CURRENT_TIMESTAMP'
          comment: 'Modify time'
          on_update: true
        scheduled_at:
          type: timestamp
          nullable: false
          default: 'CURRENT_TIMESTAMP'
          comment: 'Scheduled At'
          on_update: false
        is_scheduled:
          type: boolean
          nullable: false
          default: 0
          comment: 'Is Scheduled'
        request_json:
          type: longtext
          nullable: true
          comment: 'Request Json'
        error_code:
          type: varchar
          length: 15
          nullable: true
          comment: 'Error Code'
        error_type:
          type: varchar
          length: 50
          nullable: true
          comment: 'Error Type'
          source: 'Mygento\Kkm\Model\Source\Atol\ErrorType'
      indexes:
        IX_STATUS:
          columns: ['status']
        IX_ORDER_ID:
          columns: ['order_id']
        IX_IS_SCHEDULED_SCHEDULED_AT:
          columns: ['is_scheduled', 'scheduled_at']
        IX_SALES_ENTITY_U:
          type: 'unique'
          columns: ['operation', 'sales_entity_increment_id', 'sales_entity_id']
      fk:
        FK_ATTMPT_ORDER_ID_SAL_ORDER_ENT_ID:
          column: 'order_id'
          referenceTable: 'sales_order'
          referenceColumn: 'entity_id'
          indexName: 'IX_ORDER_ID'
    UpdateRequest:
      gui: false
      columns:
        uuid:
          type: varchar
    MergedUpdateRequest:
      gui: false
      columns:
        requests:
          type: varchar