New Products n existing scanner

Tables (73)

Copy Of Copy Of Copy Of Copy Of Untitled6 (between_coldroom_transaction_properties)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_name_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_packing_category_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_printer_transaction_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (between_coldroom_history_id) — bigint — Foreign key → Copy Of Copy Of Untitled5.Key — NOT NULL

Copy Of Copy Of Copy Of Untitled6 (return_transaction_properties)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_name_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_packing_category_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_printer_transaction_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_return_history_id) — bigint — Foreign key → Copy Of Untitled5.Key — NOT NULL

Copy Of Copy Of Untitled5 (between_coldroom_histories_v2)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (counted) — int
  • Field (name_history) — string
  • Field (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (created_byc) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Copy Of Copy Of Untitled6 (rack_transaction_properties)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_name_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_packing_category_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_printer_transaction_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_rack_history_id) — bigint — Foreign key → Copy Of Untitled4.Key — NOT NULL

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

Copy Of Untitled3 (coldroom_stock_histories_v2)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_move_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (counted) — int
  • Field (name_history) — string
  • Field (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (created_byc) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Copy Of Untitled4 (coldroom_rack_histories_v2)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_rack_name_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (counted) — int
  • Field (name_history) — string
  • Field (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (created_byc) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Copy Of Untitled5 (coldroom_return_histories_v2)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (counted) — int
  • Field (name_history) — string
  • Field (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (created_byc) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Copy Of Untitled6 (stock_transaction_properties)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_name_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_packing_category_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_printer_transaction_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_stock_history_id) — bigint — Foreign key → Copy Of Untitled3.Key — NOT NULL

Copy Of Untitled7 (coldroom_product_shell_life_histories)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_product_shell_life_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (shell_life) — int
  • Field (level_1) — int
  • Field (level_2) — int
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Copy Of Untitled8 (coldroom_onhold_transaction_histories)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (counted) — int
  • Field (name_history) — string
  • Field (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (logistic_scan_properties)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (logistic_scan_history_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_printer_transaction_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — string
  • Field (created_by) — int
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (coldroom_scan_histories_v2)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (counted) — int
  • Field (name_history) — string
  • Field (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (created_byc) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_temp_tablet_production_scan_transactions)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (device_name) — string
  • Field (barcode) — int
  • Field (batch_code) — string
  • Field (manufacturing_date) — date
  • Field (expired_date) — date
  • Field (running_no) — int
  • Field (status) — string
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (logistic_product_transactions)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (logistic_invoice_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_printer_transaction_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — string
  • Field (by_group) — boolean
  • Field (created_by) — int
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (logistic_invoice_transactions)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (sales_transaction_id) — bigint
  • Field (delivery_vehicle_id) — bigint
  • Field (delivery_route_id) — bigint
  • Field (status) — string
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (logistic_scan_histories)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (logistic_invoice_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (name_history) — string
  • Field (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (logistic_return_histories)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (logistic_invoice_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (name_history) — string
  • Field2 (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (scan_transaction_properties)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_name_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_packing_category_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_printer_transaction_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_scan_history_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (dbo.SalesTransactions)

  • Key (SalesTransactionId) — bigint — Primary key — NOT NULL
  • Field (SalesTransactionDate) — datetime
  • Field (SalesTransactionHeader) — string
  • Field (SalesTransactionNo) — int
  • Field (SalesTypeId) — int
  • Field (CustomerId) — int
  • Field (CustomerPersonId) — int
  • Field (CustomerBillNo) — string
  • Field (CustomerRemark) — string
  • Field (TransactionAmount) — decimal
  • Field (SalesTaxAmount) — decimal
  • Field (SalesDiscountAmount) — decimal
  • Field (NetAmount) — decimal
  • Field (GPAmount) — decimal
  • Field (PaymentAmount) — decimal
  • Field (Completed) — bool
  • Field (SalesJournalNo) — int
  • Field (CreatedBy) — int
  • Field (DateCreated) — datetime
  • Field (timestamp) — timestamp
  • Field (DeliveryStatus) — string
  • Field (DeliveryDocument) — string
  • Field (DeliveryOut) — string
  • Field (Offday) — string
  • Field (LunchTime) — string
  • Field (SalesJournalNoOld) — int

Untitled (dbo.DeliveryDrivers)

  • Key (DeliveryDriverId) — bigint — Primary key — NOT NULL
  • Field (DriverName) — string
  • Field (Enabled) — bool
  • Field (CreatedBy) — int
  • Field (DateCreated) — datetime
  • Field (timestamp) — timestamp

Untitled (coldroom_invoice_histories)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_invoice_transaction_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (counted) — int
  • Field (name_history) — string
  • Field (status) — string
  • Field (icon) — string
  • Field2 (status_description) — string
  • Field (body_description) — string
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_return_histories)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (from_to_coldroom_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_packing_category_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (productid) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_group_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (counted) — int
  • Field (tenc_code) — string
  • Field (barcode) — int
  • Field (batch_code) — string
  • Field (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (properties) — json
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (logistic_return_properties)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (logistic_return_history_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_printer_transaction_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — string
  • Field (created_by) — int
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (logistic_product_no_transactions)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (logistic_invoice_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (logistic_remark_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (barcode) — string
  • Field (created_by) — int
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (logistic_remarks)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — string
  • Field (enabled) — bool
  • Field (created_by) — int
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (coldroom_printer_transaction_manual_histories)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name_history) — string
  • Field (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (remark) — string
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_printer_transaction_manual_properties)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_manual_history_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_printer_transaction_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — string
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_no_printer_transactions)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (productid) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (barcode) — string
  • Field (tenc_code) — string
  • Field (batch_code) — string
  • Field (manufacturing_date) — date
  • Field (expired_date) — date
  • Field (running_no) — string
  • Field (created_by) — int
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (logistic_product_error_transactions)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_no_printer_transactions) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (logistic_invoice_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (created_by) — bigint
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (coldroom_product_shell_lifes)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_product_tenc_real_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (barcode) — string — untuk reference if dia minta barcode ni ad berapa byk shell life. sbb product id each warehouse tk sama
  • Field (shell_life) — int
  • Field (level_1) — int
  • Field (level_2) — int
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_split_group_histories)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (counted) — int
  • Field (name_history) — string
  • Field (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (split_transaction_properties)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_split_group_history_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_printer_transaction_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (onhold_transaction_properties)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_onhold_transaction_history_id) — bigint — Foreign key → Copy Of Untitled8.Key — NOT NULL
  • Key (coldroom_printer_transaction_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_additional_remark_transactions)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_printer_transaction_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (remark) — string
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_product_slow_moves)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_product_tenc_real_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (barcode) — string
  • Field (transaction) — int
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_product_slow_move_histories)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_product_slow_move_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (transaction) — int
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (packing_types)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — string
  • Field (remark) — text
  • Field (enabled) — bool
  • Field

Untitled (coldroom_warehouse_universals)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (fullname) — string
  • Field (shortname) — string
  • Field (area_code) — string
  • Field (created_by) — int
  • Field (deleted_at) — timestamp
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_name_universals)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — string
  • Field (created_by) — int
  • Field (deleted_at) — timestamp
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (barcodes)

  • Key (id) — int — Primary key — NOT NULL
  • Key (country_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (product_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 (coldroom_name_controls)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_warehouse_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_name_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (enabled) — bool
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp
  • Field (permission_id) — bigint

Untitled (companies)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — string
  • Field (code) — string
  • Field

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

Untitled (coldroom_racks)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_name_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — string
  • Field (remark) — string
  • Field (enabled) — bool
  • Field (created_by) — int
  • Field (deleted_at) — timestamp
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

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 (coldroom_stock_histories)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_name_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_packing_category_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_move_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (from_to_warehouse_id) — bigint — Foreign key → Untitled.Key — NOT NULL — erd diagram cannot reference two different column with same table. so we combine this column name. actual got two column
  • Key (coldroom_group_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (productid) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (counted) — int
  • Field (tenc_code) — string
  • Field (barcode) — int
  • Field (batch_code) — string
  • Field (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (properties) — json
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_scan_histories)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (from_to_coldroom_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL — erd diagram cannot reference two different column with same table. so we combine this column name. actual got two column
  • Key (coldrom_packing_category_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_group_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (productid) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (counted) — int
  • Field (tenc_code) — string
  • Field (barcode) — int
  • Field (batch_code) — string
  • Field (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (properties) — json
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_rack_histories)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_packing_category_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_group_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (productid) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (from_to_coldroom_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL — erd diagram cannot reference two different column with same table. so we combine this column name. actual got two column
  • Key (from_to_rack_name_id) — bigint — Foreign key → Untitled.Key — NOT NULL — erd diagram cannot reference two different column with same table. so we combine this column name. actual got two column
  • Field (counted) — int
  • Field (tenc_code) — string
  • Field (barcode) — int
  • Field (batch_code) — string
  • Field (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (properties) — json
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_move_tenc_real)

  • Key (move_id) — bigint — Primary key — NOT NULL
  • Field (id) — int
  • Field (create_datetime) — timestamp
  • Field (create_date) — date
  • Field (create_time) — time
  • Field (write_date) — timestamp
  • Field (create_uid) — int
  • Field (category_id) — int
  • Field (product_id) — int
  • Field (product_name) — text
  • Field (code) — text
  • Field (packing_size) — text
  • Field (batch_code) — text
  • Field (expired_date) — date
  • Field (main_uom) — text
  • Field (sub_uom) — text
  • Field (main_opening) — float
  • Field (sub_opening) — float
  • Field (main_receive) — float
  • Field (sub_receive) — float
  • Field (main_issue) — float
  • Field (sub_issue) — float
  • Field (main_balance) — float
  • Field (sub_balance) — float
  • Field (sign_by) — text
  • Field (transfer_from) — text
  • Field (branch_from) — text
  • Field (branch_to) — text
  • Field (remark) — text
  • Field (trans_type) — text
  • Field (tenc_code) — text
  • Field (location_id) — int
  • Field (unit_cost) — float
  • Field (total_cost) — float
  • Field (pi_close_bal) — float
  • Field (b3_close_bal) — float
  • Field (prod_close) — text
  • Field (last_phy_main) — float
  • Field (last_phy_sub) — float
  • Field (customer) — int
  • Field (rej_main_open) — float
  • Field (rej_sub_open) — float
  • Field (rej_main_bal) — float
  • Field (rej_sub_bal) — float
  • Field (rej_pi_close_bal) — float
  • Field (rej_b3_close_bal) — float
  • Field (status_remark) — text
  • Field (unique_id) — text
  • Field (button_confirm_id) — int

Untitled (coldroom_rack_slots)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (rack_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (slot) — int

Untitled (coldroom_rack_levels)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (rack_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (level) — int

Untitled (coldroom_rack_names)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (rack_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (level_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (slot_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — string
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (between_coldroom_histories)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (from_to_coldroom_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_packing_category_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_group_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (productid) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (counted) — int
  • Field (tenc_code) — string
  • Field (barcode) — int
  • Field (batch_code) — string
  • Field (status) — string
  • Field (icon) — string
  • Field (status_description) — string
  • Field (body_description) — string
  • Field (properties) — json
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_invoice_transactions)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (sales_transaction_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (delivery_driver_id) — bigint — Foreign key → Untitled.Key — NOT NULL — just to indicate the column is actually FK from other table even different db.
  • Field (temp_id) — bigint — for temporary invoice which non tenc2 invoices, like MOD etc
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp
  • Field (assigned) — bool

Untitled (coldroom_product_tenc_real)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (create_date) — date
  • Field (write_date) — timestamp
  • Field (create_uid) — int
  • Field (category_id) — int
  • Field (dis2_name) — string
  • Field (dis2_code) — string
  • Field (erp_name) — string
  • Field (erp_code) — string
  • Field (display_name) — string
  • Field (tolerate_rate_min) — float
  • Field (tolerate_rate_max) — float
  • Field (remark) — string
  • Field (status) — string
  • Field (tenc_code) — string
  • Field (location_id) — int
  • Field (uom_type) — int
  • Field (unit_cost) — float
  • Field (second_cid) — int
  • Field (section_id) — int
  • Field (picker) — string
  • Field (to_stock) — string
  • Field (to_order) — string
  • Field (tolerance_rate) — float
  • Field (bar_code) — string
  • Field (is_active) — bool
  • Field (product_code) — string

Untitled (coldroom_merge_groups)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_printer_transactions)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (group) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (productid) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_name_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_packing_category_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (batch_code) — string
  • Field (manufacturing_date) — date
  • Field (expired_date) — date
  • Field (running_no) — string
  • Field (status) — string
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp
  • Field (tenc_code) — string
  • Field2 (barcode) — int
  • Field (coldroom_temp_id) — int — value from id - coldroom_move_tenc_real table
  • Field2 (is_return) — string
  • Field (is_tablet) — string

Untitled (coldroom_printer_transaction_groups)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_merge_group_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — string
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_packing_category_controls)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (coldroom_name_control_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (coldroom_packing_category_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (enabled) — bool
  • Field (created_by) — int
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

Untitled (coldroom_packing_category_universals)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — string
  • Field (created_by) — int
  • Field (deleted_at) — timestamp
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp