pos

Tables (4)

payments

  • payment_id — integer — Primary key — NOT NULL
  • sale_id — integer — Foreign key → sales.sale_id — NOT NULL
  • sale_item_id — integer — Foreign key → sale_items.sale_item_id — NOT NULL
  • products_id — Foreign key → sale_items.products_id — NOT NULL
  • payment_amount — integer
  • payment_date — integer

products (produtcs)

  • products_id — integer — Primary key — NOT NULL
  • product_name — integer
  • price — integer
  • stock_quantity — integer
  • sale_id — integer — Foreign key → sales.sale_id — NOT NULL

sale_items

  • sale_item_id — integer — Primary key — NOT NULL
  • products_id — Foreign key → products.products_id — NOT NULL
  • sale_id — integer — Foreign key → sales.sale_id — NOT NULL
  • quantity — integer
  • total_price — integer

sales

  • sale_id — integer — Primary key — NOT NULL
  • total_price — integer
  • payment_method — integer