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