커머스

테이블 (9)

BALANCE

  • balance_id — INT
  • user_id — INT — NOT NULL
  • balance — DECIMAL(10, 2) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted — BOOLEAN

BALANCE_TRANSACTION

  • transaction_id — INT
  • balance_id — INT — NOT NULL
  • transaction_type — VARCHAR(10) — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • current_balance — DECIMAL(10, 2) — NOT NULL
  • external_transaction_id — VARCHAR(100)
  • order_id — INT
  • description — VARCHAR(255)
  • created_at — TIMESTAMP

CART

  • cart_id — INT
  • user_id — INT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted — BOOLEAN

CART_ITEM

  • cart_item_id — INT
  • cart_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • quantity — INT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted — BOOLEAN

ORDER

  • order_id — INT
  • user_id — INT — NOT NULL
  • order_date — DATE — NOT NULL
  • total_price — DECIMAL(10, 2) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted — BOOLEAN

ORDER_ITEM

  • order_item_id — INT
  • order_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — DECIMAL(10, 2) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted — BOOLEAN

PRODUCT

  • product_id — INT
  • name — VARCHAR(100) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • stock — INT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted — BOOLEAN

STOCK_TRANSACTION

  • transaction_id — INT
  • product_id — INT — NOT NULL
  • transaction_type — VARCHAR(10) — NOT NULL
  • quantity — INT — NOT NULL
  • current_stock — INT — NOT NULL
  • description — VARCHAR(255)
  • created_at — TIMESTAMP

USER

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted — BOOLEAN