커머스
테이블 (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