산정관

테이블 (6)

Product (PRODUCT)

  • Key (product_id) — INTEGER — 기본 키 — NOT NULL
  • Field (name) — VARCHAR — NOT NULL
  • Field (price) — INTEGER — NOT NULL
  • Field (product_type) — VARCHAR — NOT NULL
  • Field (condition) — INTEGER — NOT NULL

Untitled (USER)

  • Key (user_id) — INTEGER — 기본 키 — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field (name) — VARCHAR — NOT NULL
  • Field (password) — VARCHAR — NOT NULL

Untitled (REGISTER)

  • Key (register_id) — INTEGER — 기본 키 — NOT NULL
  • Key (user_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
  • Key (product_id) — INTEGER — 외래 키 → Product.Key — NOT NULL

Untitled (PURCHASE)

  • Key (purchase_id) — INTEGER — 기본 키 — NOT NULL
  • Field (implemented_at) — DATETIME — NOT NULL
  • Key (product_id) — INTEGER — 외래 키 → Product.Key — NOT NULL
  • Key (user_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL

Untitled (ACCOUNT)

  • Key (account_id) — INTEGER — 기본 키 — NOT NULL
  • Field (balance) — INTEGER — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Key (user_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL

Untitled (CHARGE)

  • Key (charge_id) — INTEGER — 기본 키 — NOT NULL
  • Field (implemented_at) — DATETIME — NOT NULL
  • Field (amount) — INTEGER — NOT NULL
  • Key (account_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL