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