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