Create BigQuery table

SchemaSalesByHour.js

exports.SchemaSalesByHour = [
  {
    description: 'Date and hour of the transactions',
    name: 'date_hour',
    type: 'DATETIME',
    mode: 'REQUIRED'
  },
  {
    description: 'UTC timestamp of the transactions',
    name: 'timestamp',
    type: 'TIMESTAMP',
  },
  {
    description: 'Day of the transactions',
    name: 'day',
    type: 'STRING',
    mode: 'REQUIRED'
  },
  {
    description: 'Day of the transactions by numeric, 1=Mon...6=Sat, 0=Sun',
    name: 'day_num',
    type: 'INT64',
    mode: 'REQUIRED'
  },
  {
    description: 'Hour of the transactions',
    name: 'hour',
    type: 'STRING',
    mode: 'REQUIRED'
  },
  {
    description: 'Name of the shop',
    name: 'shop_name',
    type: 'STRING',
    mode: 'REQUIRED'
  },
  {
    description: 'Number of transactions',
    name: 'transactions',
    type: 'INT64',
    mode: 'NULLABLE'
  },
  {
    description: 'Number of customers',
    name: 'customers',
    type: 'INT64',
    mode: 'NULLABLE'
  },
  {
    description: 'Total amount which customers paid, including VAT and service charges',
    name: 'sales',
    type: 'FLOAT64',
    mode: 'NULLABLE'
  },
  {
    description: 'VAT Tax',
    name: 'tax',
    type: 'FLOAT64',
    mode: 'NULLABLE'
  },
  {
    description: 'Cost',
    name: 'cost',
    type: 'FLOAT64',
    mode: 'NULLABLE'
  },
  {
    description: 'Amout of discount to be adjusted',
    name: 'discount',
    type: 'FLOAT64',
    mode: 'NULLABLE'
  },
  {
    description: 'Net = Total - Tax, used by the daily sales report.',
    name: 'net',
    type: 'FLOAT64',
    mode: 'NULLABLE'
  }
];