Quality App Developer aa9882c3b1 feat: Add order_for_labels table to database initialization ...

- Added order_for_labels table to initialize_db.py with columns:
  * comanda_productie: Production order code (indexed)
  * cod_articol: Article code
  * descr_com_prod: Production order description
  * cantitate: Quantity
  * com_achiz_client: Client purchase order
  * nr_linie_com_client: Client order line number
  * customer_name: Customer name
  * customer_article_number: Customer's article reference
  * open_for_order: Open for order flag
  * line_number: Line number reference
  * printed_labels: Print status (indexed, default 0)
  * data_livrara: Delivery date
  * dimensiune: Dimensions
  * Indexes on: comanda_productie, printed_labels, created_at
- Added order_for_labels schema verification to db_schema_verifier.py
- Table supports labels printing module with proper indexing for queries
- Timestamps: created_at, updated_at for audit trail

2026-02-02 01:24:38 +02:00

17 KiB

Raw Permalink Blame History

View Raw