stocks
Tables (3)
Order (주문)
- id — Primary key — NOT NULL
- stock_id (상품 id) — BIGINT — Foreign key → Stock.id — NOT NULL
- user_id (사용자 id) — BIGINT — Foreign key → User.id — NOT NULL
- order_time (주문 시각) — DATETIME
Stock (상품)
- id — BIGINT — Primary key — NOT NULL
- name (제품명) — VARCHAR
- amount (재고량) — BIGINT
User (사용자/계좌)
- id — BIGINT — Primary key — NOT NULL
- username (사용자명) — VARCHAR
- balance (계좌잔고) — BIGINT