view: product_physical_change_history {
  sql_table_name: art_relations.product_physical_change_history ;;

  dimension: id {
    primary_key: yes
    type: number
    sql: ${TABLE}.id ;;
  }

  dimension_group: date_changed {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.date_changed ;;
  }

  dimension: delivered {
    type: string
    sql: ${TABLE}.delivered ;;
  }

  dimension: field_name {
    type: string
    sql: ${TABLE}.field_name ;;
  }

  dimension: new_deletion_status {
    type: string
    sql: ${TABLE}.new_deletion_status ;;
  }

  dimension: new_price {
    type: number
    sql: ${TABLE}.new_price ;;
  }

  dimension_group: new_sale_start {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.new_sale_start_date ;;
  }

  dimension: old_deletion_status {
    type: string
    sql: ${TABLE}.old_deletion_status ;;
  }

  dimension: old_price {
    type: number
    sql: ${TABLE}.old_price ;;
  }

  dimension_group: old_sale_start {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.old_sale_start_date ;;
  }

  dimension: product_id {
    type: number
    sql: ${TABLE}.product_id ;;
  }

  measure: count {
    type: count
    drill_fields: [id, field_name]
  }
}