guhada

Tables (15)

import_declaration_info

  • id — BIGINT
  • order_prod_id — BIGINT — NOT NULL
  • declaration_number — VARCHAR(30) — NOT NULL
  • declaration_date — DATE — NOT NULL
  • bl_number — VARCHAR(20)
  • total_customs_duty — BIGINT
  • total_vat — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

invoice

  • id — BIGINT
  • order_prod_id — BIGINT — NOT NULL
  • invoice_no — VARCHAR(50) — NOT NULL
  • invoice_date — DATE — NOT NULL
  • currency — VARCHAR(10) — NOT NULL
  • fx_pay_price — DECIMAL(12,4) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

mall_order

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • order_date — DATE — NOT NULL
  • status — VARCHAR(45) — NOT NULL
  • total_amount — DECIMAL(12,4) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

mall_order_history

  • id — BIGINT
  • mall_order_id — BIGINT — NOT NULL
  • status — VARCHAR(45) — NOT NULL
  • changed_at — DATETIME

order_prod

  • id — BIGINT
  • mall_order_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • price — DECIMAL(10,2) — NOT NULL
  • discount — DECIMAL(10,2)
  • status — VARCHAR(45) — NOT NULL
  • order_prod_group_id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

order_prod_cash_receipt

  • order_prod_id — BIGINT
  • receipt_no — VARCHAR(20) — NOT NULL
  • price — BIGINT — NOT NULL
  • vat — BIGINT — NOT NULL
  • created_at — DATETIME

order_prod_discount

  • order_prod_id — BIGINT — Primary key — NOT NULL
  • discount_type — ENUM('FIXED', 'PERCENTAGE') — Primary key — NOT NULL
  • discount_value — DECIMAL(10,2) — NOT NULL

order_prod_group

  • id — BIGINT
  • deal_id — BIGINT
  • seller_id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

order_ship

  • id — BIGINT
  • order_prod_id — BIGINT — NOT NULL
  • ship_status — VARCHAR(45) — NOT NULL
  • invoice_no — VARCHAR(45) — NOT NULL
  • courier_cd — VARCHAR(45) — NOT NULL
  • ship_schedule_date — DATETIME — NOT NULL
  • ship_complete_date — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

payment

  • id — BIGINT
  • order_id — BIGINT — NOT NULL
  • payment_method — VARCHAR(20) — NOT NULL
  • amount — DECIMAL(12,4) — NOT NULL
  • payment_date — DATETIME — NOT NULL
  • payment_status — VARCHAR(25) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

payment_cancel

  • id — BIGINT
  • order_prod_id — BIGINT — NOT NULL
  • withdraw_price — DECIMAL(10,2) — NOT NULL
  • withdraw_reason — VARCHAR(500)
  • cancel_date — DATETIME

product

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • brand — VARCHAR(50) — NOT NULL
  • price — DECIMAL(12,4) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

tax_verification

  • id — BIGINT
  • declaration_number — VARCHAR(30) — NOT NULL
  • order_prod_group_id — BIGINT — NOT NULL
  • vat_amount — BIGINT
  • total_tax_amount — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

user

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

warehouse_attribute

  • id — BIGINT
  • location — VARCHAR(100) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME