view: contact {
  sql_table_name: art_relations.contact ;;

  measure: count {
    hidden: yes
    type: count
    drill_fields: [detail*]
  }

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

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

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

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

  dimension: contact_affiliation {
    hidden: yes
    type: string
    sql: ${TABLE}.contact_affiliation ;;
  }

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

  dimension: contact_comment {
    hidden: yes
    type: string
    sql: ${TABLE}.contact_comment ;;
  }

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

  dimension: contact_title {
    hidden: yes
    type: string
    sql: ${TABLE}.contact_title ;;
  }

  dimension: affiliation_id {
    hidden: yes
    type: yesno
    sql: ${TABLE}.affiliation_id ;;
  }

  dimension: address_street {
    hidden: yes
    type: string
    sql: ${TABLE}.address_street ;;
  }

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

  dimension: address_zip {
    hidden: yes
    type: string
    sql: ${TABLE}.address_zip ;;
  }

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

  dimension: contact_fax {
    hidden: yes
    type: string
    sql: ${TABLE}.contact_fax ;;
  }

  dimension: contact_cell {
    hidden: yes
    type: string
    sql: ${TABLE}.contact_cell ;;
  }

  dimension: contact_phone {
    hidden: yes
    type: string
    sql: ${TABLE}.contact_phone ;;
  }

  dimension: contact_phone_2 {
    hidden: yes
    type: string
    sql: ${TABLE}.contact_phone_2 ;;
  }

  dimension: checks_remove {
    hidden: yes
    type: string
    sql: ${TABLE}.checks_remove ;;
  }

  dimension: company {
    hidden: yes
    type: string
    sql: ${TABLE}.company ;;
  }

  dimension: instrument {
    hidden: yes
    type: string
    sql: ${TABLE}.instrument ;;
  }

  dimension: address2 {
    hidden: yes
    type: string
    sql: ${TABLE}.address2 ;;
  }

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

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

  dimension: address_other_state {
    hidden: yes
    type: string
    sql: ${TABLE}.address_other_state ;;
  }

  dimension: contact_type {
    hidden: yes
    type: string
    sql: ${TABLE}.contact_type ;;
  }

  dimension: send_option {
    hidden: yes
    type: string
    sql: ${TABLE}.send_option ;;
  }

  dimension_group: address_last_updated {
    hidden: yes
    type: time
    sql: ${TABLE}.address_last_updated ;;
  }

  set: detail {
    fields: [
      contact_first_name,
      contact_middle_name,
      contact_last_name,
      contact_email,
      contact_affiliation,
      alt_email,
      contact_comment,
      contact_id,
      contact_title,
      affiliation_id,
      address_street,
      address_city,
      address_zip,
      address_state,
      contact_fax,
      contact_cell,
      contact_phone,
      contact_phone_2,
      checks_remove,
      company,
      instrument,
      address2,
      country,
      orchard_country,
      address_other_state,
      contact_type,
      send_option,
      address_last_updated_time
    ]
  }
}