Ecommerce
Tables (13)
Cart
- CartID — INT — NOT NULL
- ExIdx — INT
- UserSeq — INT
- status — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
CartItem
- CartItemID — INT — NOT NULL
- CartID — INT
- ProductID — INT
- Options — JSON
- Quantity — INT
- Status — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Category
- CategoryID — INT — NOT NULL
- ExIdx — INT
- Name — VARCHAR(255)
- Description — TEXT
- ParentCategoryID — INT
- IsActive — BOOLEAN
- DisplayOrder — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Coupon
- CouponID — INT — NOT NULL
- ExIdx — INT
- CouponCode — VARCHAR(255)
- CouponName — VARCHAR(255)
- Description — TEXT
- DiscountType — VARCHAR(50)
- DiscountValueType — VARCHAR(50)
- DiscountValue — INT
- CanCombine — BOOLEAN
- MinimumPurchaseAmount — INT
- MemberLevelRestriction — JSON
- StartTime — DATETIME
- EndTime — DATETIME
- LimitPerUser — INT
- IsActive — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
CouponUsage
- UsageID — INT — NOT NULL
- OrderID — INT
- OrderDetailID — INT
- CouponID — INT
- UserSeq — INT
- SaleID — INT
- used_at — DATETIME
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Order
- OrderID — INT — NOT NULL
- ExIdx — INT
- CouponID — INT
- UserSeq — INT
- Status — VARCHAR(255)
- TotalAmount — INT
- FinalAmount — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
OrderDetail
- OrderDetailID — INT — NOT NULL
- OrderID — INT
- CouponID — INT
- ProductID — INT
- UserSeq — INT
- Options — JSON
- Quantity — INT
- PricePerItem — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
OrderLog
- OrderLogID — INT — NOT NULL
- OrderID — INT
- UserSeq — INT
- ActionType — VARCHAR(255)
- Amount — INT
- Description — TEXT
- TransactionID — VARCHAR(255)
- created_at — TIMESTAMP
Product
- ProductID — INT — NOT NULL
- ExIdx — INT
- CategoryID — INT
- InventoryID — INT
- Name — VARCHAR(255)
- Description — TEXT
- Price — INT
- Stock — INT
- Options — JSON
- StartDate — DATE
- EndDate — DATE
- IsActive — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
ProductInfo
- infoID — INT — NOT NULL
- ProductID — INT
- infoKey — VARCHAR(255)
- infoValue — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
ProductInventory
- InventoryID — INT — NOT NULL
- ExIdx — INT
- Stock — INT
- CostPrice — INT
- Status — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
ProductInventoryLog
- ProductInventoryLogID — INT — NOT NULL
- InventoryID — INT
- PreviousStockQuantity — INT
- NewStockQuantity — INT
- PreviousStatus — VARCHAR(255)
- NewStatus — VARCHAR(255)
- ChangeReason — VARCHAR(255)
- UserLevel — VARCHAR(255)
- UserSeq — INT
- created_at — TIMESTAMP
ProductOption
- OptionID — INT — NOT NULL
- ProductID — INT
- OptionName — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP