new Coldroom
Tables (18)
Copy Of Untitled (sections)
- Key (id) — int — Primary key — NOT NULL
- Key (department_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (name) — string
- Field (code) — string
- Field (enabled) — bool
Copy Of Untitled2 (product_sub_categories)
- Key (id) — int — Primary key — NOT NULL
- Key (product_category_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (name) — string
- Field (code) — string
- Field (running_no) — number
Untitled (companies)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — string
- Field (code) — string
- Field
Untitled (barcodes)
- Key (id) — int — Primary key — NOT NULL
- Key (product_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (country_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (company_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (product_sub_category_id) — int — Foreign key → Copy Of Untitled2.Key — NOT NULL
- Key (product_state_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (packing_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (bar_code) — int
- Field (product_code) — int
- Field (tenc_code) — string
- Field (enabled) — bool
Untitled (barcode_customer)
- Key (customer_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (barcode_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (enabled) — bool
Untitled (customer_groups)
- Key (id) — Primary key — NOT NULL
- Field (name) — string
- Field (remark)
Untitled (packings)
- Key (id) — int — Primary key — NOT NULL
- Field (remark) — text
- Field2 (enabled) — boolean
- Field
Untitled (product_warehouse)
- Key (warehouse_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (product_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (tolerance_rate_max) — number
- Field2 (tolerance_rate_min) — number
- Field2 (tolerance_rate_avg) — number
Untitled (uom_combinations)
- Key (packing_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (packing_type_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (uom_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (level)
- Field (value) — number
Untitled (packing_types)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — string
- Field (remark) — text
- Field (enabled) — bool
- Field
Untitled (products)
- Key (id) — int — Primary key — NOT NULL
- Key (section_id) — int — Foreign key → Copy Of Untitled.Key — NOT NULL
- Field (name) — string
- Field (remark) — text
- Field (to_stock) — bool
- Field (to_order) — bool
Untitled (countries)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — string
- Field (code) — string
- Field
Untitled (product_states)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — string
- Field (code) — string
- Field (remark) — text
Untitled (departments)
- Key (id) — int — Primary key — NOT NULL
- Key (warehouse_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (name) — string
- Field (enabled) — bool
Untitled (product_categories)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — string
- Field (code) — string
- Field (remark) — text
- Field
Untitled (uoms)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — string
- Field (remark) — text
- Field (enabled) — bool
- Field
Untitled (warehouses)
- Key (id) — int — Primary key — NOT NULL
- Field (name)
- Field (enabled) — bool
- Field
Untitled (customers)
- Key (id) — int — Primary key — NOT NULL
- Key (customer_groups_id) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — string
- Field (address) — text
- Field (phone) — string
- Field (enabled) — bool
- Field