---
hracicka:
  so_payments:
    payment_id: { type: integer, required: true, primaryKey: true, autoIncrement: true }
    orders_id:  { type: integer }
    payment_number: { type: varchar(32) }
    payment_name:   { type: varchar(40) }
    payment_amount: { type: decimal }
    payment_type:   { type: varchar(20) }
    date_posted:    { type: timestamp }
    last_modified:  { type: timestamp }
    purchase_order_id: { type: integer, default: 0 }

  orders:
    orders_id:  { type: integer, required: true, primaryKey: true, autoIncrement: true }
    orders_status: { type: integer, required: true }
    last_modified:  { type: timestamp }

  orders_status_history:
    orders_status_history_id: { type: integer, required: true, primaryKey: true, autoIncrement: true }
    orders_id: { type: integer, required: true }
    orders_status_id: { type: integer, required: true }
    date_added: { type: timestamp }
    customer_notified: { type: integer, default: 0 }
    comments: { type: longvarchar }

  products:
    products_id:   { type: integer, required: true, primaryKey: true, autoIncrement: true }
    products_quantity: { type: float }
    products_model: { type: varchar(32) }

  products_log: 
    id:
    products_id:   { type: integer, foreignTable: products, foreignReference: products_id }
    last_modified: { type: timestamp }
    diff: { type: float }
    action: {type: varchar(20) }

  products_description:
    products_id:   { type: integer, foreignTable: products, foreignReference: products_id, primaryKey: true }
    products_name: { type: varchar(64) }