ecommerce
Tables (10)
balance (Balance table)
- balance index (balance_id) — int — Primary key — NOT NULL
- current balance (balance) — int
- updated date (updated_at) — datetime
- created date (created_at) — datetime
- user id (user_id) — int
cart (Cart table)
- cart index (cart_id) — int — Primary key — NOT NULL
- user id (user_id) — int
- product id (product_id) — int
- product option id (product_option_id) — int
- product name (product_name) — int
- product option name (product_option_name) — varchar
- quantity — int
- single price (single_price) — int
- total price (total_price) — int
- updated date (updated_at) — datetime
- created date (created_at) — datetime
order (Order table)
- order index (order_id) — int — Primary key — NOT NULL
- order status (status) — enum
- created date (created_at) — int
- balance id (balance_id) — int — Foreign key → balance.balance index — NOT NULL
order_detail (Order detail table)
- order detail index (order_detail_id) — int — Primary key — NOT NULL
- order id (order_id) — int — Foreign key → order.order index — NOT NULL
- order status (status) — enum
- total quantity (total_cnt) — int
- total price (total_price) — int
- single price (single_price) — int
- product name (pname) — varchar
- product option name (poption_name) — varchar
- updated date (updated_at) — datetime
- created date (created_at) — datetime
- product option id (product_option_id) — int — Foreign key → product_option.product option index — NOT NULL
- product id (product_id) — int — Foreign key → product_option.product id — NOT NULL
order_log (Order log table)
- order log index (log_id) — int — Primary key — NOT NULL
- order id (order_id) — int
- order detail id (order_detail_id) — int
- order date (date) — date
- created date (created_at) — datetime
- product id (product_id) — int
- product option id (product_option_id) — int
- total quantity (total_cnt) — int
order_sheet (Order sheet table)
- order sheet index (order_sheet_id) — int — Primary key — NOT NULL
- created date (created_at) — datetime
order_sheet_item (Order sheet detail table)
- order sheet detail index (order_sheet_detail_id) — int — Primary key — NOT NULL
- order sheet id (order_sheet_id) — int — Foreign key → order_sheet.order sheet index — NOT NULL
- total quantity (total_cnt) — int
- total price (total_price) — int
- single price (single_price) — int
- product name (pname) — varchar
- product option name (poption_name) — varchar
- updated date (updated_at) — datetime
- created date (created_at) — datetime
- product option id (product_option_id) — int — Foreign key → product_option.product option index — NOT NULL
- product id (product_id) — int — Foreign key → product_option.product id — NOT NULL
payment (Payment table)
- payment index (payment_id) — int — Primary key — NOT NULL
- order id (order_id) — int — Foreign key → order.order index — NOT NULL
- payment type (type) — enum
- payment method type(paid, refund) (method_type) — enum
- payment status (status) — enum
- updated date (updated_at) — datetime
- created date (regdate) — datetime
product (Product table)
- product index (product_id) — int — Primary key — NOT NULL
- product name (name) — varchar
- status — enum
- total order (order_cnt) — int
- delete status (is_deleted) — char
- created at (created_at) — datetime
product_option (Product option table)
- product option index (product_option_id) — int — Primary key — NOT NULL
- product id (product_id) — int — Foreign key → product.product index — NOT NULL
- option name (name) — varchar
- status — enum
- total order (order_cnt) — int
- current stock (stock) — int
- delete status (is_deleted) — char
- updated date (updated_at) — datetime
- created date (created_at) — datetime