SQLite format 3@ .ùûû d Àߧ¢BB÷÷I ]7indexsqlite_autoindex_small_package_batches_1small_package_batches ƒ} 33‡!tablesmall_package_specssmall_package_specs CREATE TABLE small_package_specs ( id INTEGER PRIMARY KEY AUTOINCREMENT, spec_code TEXT NOT NULL DEFAULT '', spec_name TEXT NOT NULL, unit TEXT NOT NULL DEFAULT '袋', fg_qty_per_package REAL NOT NULL DEFAULT 0, fg_qty_per_package_unit TEXT NOT NULL DEFAULT '', note TEXT NOT NULL DEFAULT '', created_at TEXT NOT NULL DEFAULT (datetime('now')) )„b ))ˆtablesales_outboundsales_outbound CREATE TABLE sales_outbound ( id INTEGER PRIMARY KEY AUTOINCREMENT, outbound_order_no TEXT NOT NULL, finished_batch_no TEXT NOT NULL, customer TEXT NOT NULL, quantity REAL NOT NULL, unit TEXT NOT NULL DEFAULT 'kg', outbound_date TEXT NOT NULL, outbound_type TEXT NOT NULL DEFAULT '出库', created_at TEXT NOT NULL DEFAULT (datetime('now')), FOREIGN KEY (finished_batch_no) REFERENCES finished_goods(batch_no) ON DELETE RESTRICT )ƒx))‡+tablefinished_goodsfinished_goodsCREATE TABLE finished_goods ( id INTEGER PRIMARY KEY AUTOINCREMENT, batch_no TEXT NOT NULL UNIQUE, product_name TEXT NOT NULL, quantity REAL NOT NULL, unit TEXT NOT NULL DEFAULT 'kg', production_date TEXT NOT NULL, created_at TEXT NOT NULL DEFAULT (datetime('now')), FOREIGN KEY (batch_no) REFERENCES production_batches(batch_no) ON DELETE RESTRICT );O)indexsqlite_autoindex_finished_goods_1finished_goods …99‰tableproduction_consumptionproduction_consumptionCREATE TABLE production_consumption ( id INTEGER PRIMARY KEY AUTOINCREMENT, production_batch_no TEXT NOT NULL, material_name TEXT NOT NULL, raw_batch_no TEXT NOT NULL, quantity REAL NOT NULL, unit TEXT NOT NULL DEFAULT 'kg', created_at TEXT NOT NULL DEFAULT (datetime('now')), FOREIGN KEY (production_batch_no) REFERENCES production_batches(batch_no) ON DELETE CASCADE, FOREIGN KEY (raw_batch_no) REFERENCES raw_material_batches(batch_no) ON DELETE RESTRICT )‚Y11„]tableproduction_batchesproduction_batchesCREATE TABLE production_batches ( id INTEGER PRIMARY KEY AUTOINCREMENT, batch_no TEXT NOT NULL UNIQUE, line_type TEXT NOT NULL DEFAULT '', note TEXT NOT NULL DEFAULT '', created_at TEXT NOT NULL DEFAULT (datetime('now')) )CW1indexsqlite_autoindex_production_batches_1production_batchesP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)„U55ˆMtableraw_material_batchesraw_material_batchesCREATE TABLE raw_material_batches ( id INTEGER PRIMARY KEY AUTOINCREMENT, batch_no TEXT NOT NULL UNIQUE, supplier_code TEXT NOT NULL DEFAULT '', supplier_name TEXT NOT NULL DEFAULT '', material_name TEXT NOT NULL DEFAULT '', inbound_date TEXT NOT NULL, quantity REAL NOT NULL, unit TEXT NOT NULL DEFAULT 'kg', inbound_order_no TEXT NOT NULL DEFAULT '', created_at TEXT NOT NULL DEFAULT (datetime('now')) )G[5indexsqlite_autoindex_raw_material_batches_1raw_material_batches             ¢§ W¯  d Àߧ¢BB÷÷I ]7indexsqlite_autoindex_small_package_batches_1small_package_batches ƒ} 33‡!tablesmall_package_specssmall_package_specs CREATE TABLE small_package_specs ( id INTEGER PRIMARY KEY AUTOINCREMENT, spec_code TEXT NOT NULL DEFAULT '', spec_name TEXT NOT NULL, unit TEXT NOT NULL DEFAULT '袋', fg_qty_per_package REAL NOT NULL DEFAULT 0, fg_qty_per_package_unit TEXT NOT NULL DEFAULT '', note TEXT NOT NULL DEFAULT '', created_at TEXT NOT NULL DEFAULT (datetime('now')) )„b ))ˆtablesales_outboundsales_outbound CREATE TABLE sales_outbound ( id INTEGER PRIMARY KEY AUTOINCREMENT, outbound_order_no TEXT NOT NULL, finished_batch_no TEXT NOT NULL, customer TEXT NOT NULL, quantity REAL NOT NULL, unit TEXT NOT NULL DEFAULT 'kg', outbound_date TEXT NOT NULL, outbound_type TEXT NOT NULL DEFAULT '出库', created_at TEXT NOT NULL DEFAULT (datetime('now')), FOREIGN KEY (finished_batch_no) REFERENCES finished_goods(batch_no) ON DELETE RESTRICT )ƒx))‡+tablefinished_goodsfinished_goodsCREATE TABLE finished_goods ( id INTEGER PRIMARY KEY AUTOINCREMENT, batch_no TEXT NOT NULL UNIQUE, product_name TEXT NOT NULL, quantity REAL NOT NULL, unit TEXT NOT NULL DEFAULT 'kg', production_date TEXT NOT NULL, created_at TEXT NOT NULL DEFAULT (datetime('now')), FOREIGN KEY (batch_no) REFERENCES production_batches(batch_no) ON DELETE RESTRICT )ø=O)indexsqlite_autoindex_finished_goods_1finished_goods …99‰tableproduction_consumptionproduction_consumptionCREATE TABLE production_consumption ( id INTEGER PRIMARY KEY AUTOINCREMENT, production_batch_no TEXT NOT NULL, material_name TEXT NOT NULL, raw_batch_no TEXT NOT NULL, quantity REAL NOT NULL, unit TEXT NOT NULL DEFAULT 'kg', created_at TEXT NOT NULL DEFAULT (datetime('now')), FOREIGN KEY (production_batch_no) REFERENCES production_batches(batch_no) ON DELETE CASCADE, FOREIGN KEY (raw_batch_no) REFERENCES raw_material_batches(batch_no) ON DELETE RESTRICT )‚Y11„]tableproduction_batchesproduction_batchesCREATE TABLE production_batches ( id INTEGER PRIMARY KEY AUTOINCREMENT, batch_no TEXT NOT NULL UNIQUE, line_type TEXT NOT NULL DEFAULT '', note TEXT NOT NULL DEFAULT '', created_at TEXT NOT NULL DEFAULT (datetime('now')) )CW1indexsqlite_autoindex_production_batches_1production_batchesP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)„U55ˆMtableraw_material_batchesraw_material_batchesCREATE TABLE raw_material_batches ( id INTEGER PRIMARY KEY AUTOINCREMENT, batch_no TEXT NOT NULL UNIQUE, supplier_code TEXT NOT NULL DEFAULT '', supplier_name TEXT NOT NULL DEFAULT '', material_name TEXT NOT NULL DEFAULT '', inbound_date TEXT NOT NULL, quantity REAL NOT NULL, unit TEXT NOT NULL DEFAULT 'kg', inbound_order_no TEXT NOT NULL DEFAULT '', created_at TEXT NOT NULL DEFAULT (datetime('now')) )G[5indexsqlite_autoindex_raw_material_batches_1raw_material_batches ªà ^ ^¤Yˆ• ‰ªe%) indexidx_sales_fgsales_outboundCREATE INDEX idx_sales_fg ON sales_outbound(finished_batch_no)v+9indexidx_consume_rawproduction_consumptionCREATE INDEX idx_consume_raw ON production_consumption(raw_batch_no)-9%indexidx_consume_prodproduction_consumptionCREATE INDEX idx_consume_prod ON production_consumption(production_batch_no)373indexidx_sp_source_ordersmall_package_batchesCREATE INDEX idx_sp_source_order ON small_package_batches(source_outbound_order_no)|-9indexidx_sp_out_batchsmall_package_outboundCREATE INDEX idx_sp_out_batch ON small_package_outbound(package_batch_no)s/7 indexidx_sp_batch_specsmall_package_batchesCREATE INDEX idx_sp_batch_spec ON small_package_batches(spec_id)…N 99Š7tablesmall_package_outboundsmall_package_outboundCREATE TABLE small_package_outbound ( id INTEGER PRIMARY KEY AUTOINCREMENT, outbound_order_no TEXT NOT NULL, package_batch_no TEXT NOT NULL, spec_id INTEGER NOT NULL, quantity REAL NOT NULL, unit TEXT NOT NULL DEFAULT '袋', customer TEXT NOT NULL, outbound_date TEXT NOT NULL, created_at TEXT NOT NULL DEFAULT (datetime('now')), FOREIGN KEY (package_batch_no) REFERENCES small_package_batches(package_batch_no) ON DELETE RESTRICT, FOREIGN KEY (spec_id) REFERENCES small_package_specs(id) ON DELETE RESTRICT )I ]7indexsqlite_autoindex_small_package_batches_1small_package_batches …7 77Š tablesmall_package_batchessmall_package_batches CREATE TABLE small_package_batches ( id INTEGER PRIMARY KEY AUTOINCREMENT, package_batch_no TEXT NOT NULL UNIQUE, spec_id INTEGER NOT NULL, quantity REAL NOT NULL, unit TEXT NOT NULL DEFAULT '袋', inbound_date TEXT NOT NULL, inbound_type TEXT NOT NULL DEFAULT '采购入库', source_outbound_order_no TEXT NOT NULL DEFAULT '', note TEXT NOT NULL DEFAULT '', created_at TEXT NOT NULL DEFAULT (datetime('now')), FOREIGN KEY (spec_id) REFERENCES small_package_specs(id) ON DELETE RESTRICT )ƒ} 33‡!tablesmall_package_specssmall_package_specs CREATE TABLE small_package_specs ( id INTEGER PRIMARY KEY AUTOINCREMENT, spec_code TEXT NOT NULL DEFAULT '', spec_name TEXT NOT NULL, unit TEXT NOT NULL DEFAULT '袋', fg_qty_per_package REAL NOT NULL DEFAULT 0, fg_qty_per_package_unit TEXT NOT NULL DEFAULT '', note TEXT NOT NULL DEFAULT '', created_at TEXT NOT NULL DEFAULT (datetime('now')) )„b ))ˆtablesales_outboundsales_outbound CREATE TABLE sales_outbound ( id INTEGER PRIMARY KEY AUTOINCREMENT, outbound_order_no TEXT NOT NULL, finished_batch_no TEXT NOT NULL, customer TEXT NOT NULL, quantity REAL NOT NULL, unit TEXT NOT NULL DEFAULT 'kg', outbound_date TEXT NOT NULL, outbound_type TEXT NOT NULL DEFAULT '出库', created_at TEXT NOT NULL DEFAULT (datetime('now')), FOREIGN KEY (finished_batch_no) REFERENCES finished_goods(batch_no) ON DELETE RESTRICT );O)indexsqlite_autoindex_finished_goods_1finished_goods