90-database/tables/orders_master.md
orders_master
Generated from the live schema on 2026-09-06 by _tools/gen_data_dictionary.php. Do not hand-edit — regeneration overwrites this file. Put prose in the module page.
Exact row count (2026-09-06): 13
Columns
| Column | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
rowId | bigint(20) | NO | PRI | auto_increment | |
order_uid | varchar(100) | NO | MUL | ||
order_number | varchar(50) | NO | MUL | ||
buyer_id | bigint(20) | NO | MUL | ||
seller_id | bigint(20) | NO | MUL | ||
product_id | bigint(20) | NO | MUL | ||
inventory_id | bigint(20) unsigned | YES | |||
variant_json | text | YES | |||
quantity | int(11) | NO | MUL | 1 | |
unit_price | decimal(12,2) | NO | |||
subtotal | decimal(12,2) | NO | |||
gst_amount | decimal(12,2) | YES | 0.00 | ||
shipping_charges | decimal(10,2) | YES | 0.00 | ||
delivery_charges | decimal(10,2) | NO | 0.00 | ||
platform_fee | decimal(12,2) | NO | 0.00 | ||
discount_amount | decimal(12,2) | YES | 0.00 | ||
coupon_code | varchar(50) | YES | |||
total_amount | decimal(12,2) | NO | |||
payment_method | enum('cod','online','wallet','upi') | YES | cod | ||
payment_status | enum('pending','paid','failed','refunded') | YES | MUL | pending | |
payment_id | varchar(255) | YES | |||
kv_billing_uid | char(36) | YES | |||
order_status | varchar(64) | NO | MUL | pending | |
delivery_mode | enum('quick','regular') | NO | regular | ||
shipping_address | text | NO | |||
billing_address | text | YES | |||
tracking_number | varchar(100) | YES | |||
carrier_name | varchar(100) | YES | |||
estimated_delivery | date | YES | |||
estimated_delivery_at | datetime | YES | |||
delivered_at | datetime | YES | MUL | ||
cancelled_at | datetime | YES | |||
cancel_reason | text | YES | |||
cancelled_by | enum('buyer','seller','admin') | YES | |||
return_requested_at | datetime | YES | |||
return_approved_at | datetime | YES | |||
return_reason | text | YES | |||
refund_amount | decimal(12,2) | YES | 0.00 | ||
refund_status | enum('na','pending','processed','completed') | YES | na | ||
refunded_at | datetime | YES | |||
download_url | varchar(1000) | YES | |||
download_expiry | datetime | YES | |||
is_reviewed | tinyint(1) | YES | 0 | ||
activestatus | tinyint(1) | YES | MUL | 1 | |
datecreated | datetime | YES | MUL | current_timestamp() | |
createdIp | varchar(255) | YES | 127.0.0.1 | ||
createdby | bigint(20) | YES | 1 | ||
company_id | int(11) | YES | MUL | 1 | |
created_user_type | int(11) | YES | 0 | ||
datemodified | datetime | YES | MUL | on update current_timestamp() | |
modifiedIp | varchar(255) | YES | |||
cancellation_fee | decimal(12,2) | NO | 0.00 | ||
issue_window_start | datetime | YES | |||
issue_window_end | datetime | YES | |||
owner_unboxing_due_at | datetime | YES | |||
owner_unboxing_completed_at | datetime | YES | |||
cgst_amount | decimal(12,2) | YES | |||
customer_gstin | text | YES | |||
customer_legal_name | varchar(255) | YES | |||
igst_amount | decimal(12,2) | YES | |||
place_of_supply_state | text | YES | |||
place_of_supply_state_code | text | YES | |||
seller_gstin | text | YES | |||
seller_state | text | YES | |||
seller_state_code | text | YES | |||
sgst_amount | decimal(12,2) | YES | |||
shipping_amount | decimal(12,2) | YES |
Declared foreign keys
None declared. (This schema relies mostly on convention-based joins, not FK constraints. Relationships are documented in the relevant module data-model.md.)
Used by
To be filled from the module code map (reverse index): which pages, services and modules read/write this table.