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