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