CREATE TABLE bom_fabric_lines (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    bom_version_id BIGINT UNSIGNED NOT NULL,
    prefix_id BIGINT UNSIGNED NULL,
    item_code_id BIGINT UNSIGNED NULL,
    item_name VARCHAR(120) NULL,
    item_code VARCHAR(80) NULL,
    item_description VARCHAR(500) NULL,
    using_criteria VARCHAR(120) NULL,
    using_area VARCHAR(255) NULL,
    order_qty DECIMAL(18,4) NULL,
    cons DECIMAL(18,6) NULL,
    uom VARCHAR(30) NULL,
    pc_doz VARCHAR(30) NULL,
    wast_percent DECIMAL(9,4) NULL DEFAULT 0,
    req_qty DECIMAL(18,4) NULL,
    lo_use DECIMAL(18,4) NULL,
    adjust_qty DECIMAL(18,4) NULL,
    need_to_bk DECIMAL(18,4) NULL,
    booked_qty DECIMAL(18,4) NULL DEFAULT 0,
    booking_qty DECIMAL(18,4) NULL,
    balance DECIMAL(18,4) NULL,
    price DECIMAL(18,6) NULL,
    currency_code VARCHAR(10) NULL,
    line_value DECIMAL(18,4) NULL,
    usd_value DECIMAL(18,4) NULL,
    sort_order INT NOT NULL DEFAULT 0,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    deleted_at TIMESTAMP NULL,
    KEY idx_bom_fabric_version (bom_version_id, deleted_at),
    KEY idx_bom_fabric_prefix (prefix_id),
    CONSTRAINT fk_bom_fabric_version FOREIGN KEY (bom_version_id) REFERENCES bom_versions (id),
    CONSTRAINT fk_bom_fabric_prefix FOREIGN KEY (prefix_id) REFERENCES prefix_masters (id),
    CONSTRAINT fk_bom_fabric_item FOREIGN KEY (item_code_id) REFERENCES item_code (id)
) ENGINE=InnoDB;