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