Item:
  columns:
    name: { type: string, notnull: true }
    price: { type: integer }

Order
  columns:
    status: { type: integer }

Client:
  columns:
    email: { type: string, notnull: true }
    password: { type: string, notnull: true }

OrderItem:
  columns:
    order_id: { type: integer, primary: true }
    item_id: { type: integer, primary: true }
  relations:
    Order: { onDelete: CASCADE, local: order_id, foreign: id }
    Item: { onDelete: CASCADE, local: item_id, foreign: id }

ClientOrder:
  columns:
    client_id: { type: integer, primary: true }
    order_id: { type: integer, primary: true }
  relations:
    Client: { onDelete: CASCADE, local: client_id, foreign: id }
    Order: { onDelete: CASCADE, local: order_id, foreign: id }