scala-ec

Tables (10)

Untitled (assets)

  • Key (id) — INT UNSIGNED — Primary key — NOT NULL
  • Field (path) — VARCHAR — NOT NULL — アセットまでのパス
  • Field (filename) — VARCHAR(255) — ファイル名
  • Field (type) — VARCHAR(255) — どこで使われるか

Untitled (login_tokens)

  • Key (id) — INT UNSIGNED — Primary key — NOT NULL
  • Field (token) — VARCHAR(255) — NOT NULL
  • Key (user_id) — INT UNSIGNED — Foreign key → users.Key — NOT NULL — index

Untitled (products)

  • Key (id) — INT UNSIGNED — Primary key — NOT NULL
  • Field (title) — VARCHAR(255) — NOT NULL — product_title
  • Field (description) — LONGTEXT
  • Field (stock) — INT UNSIGNED — NOT NULL
  • Field (price) — INT
  • Field (sale_price) — INT

Untitled (product_thumbnails)

  • Key (id) — INT UNSIGNED — Primary key — NOT NULL
  • Key (product_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
  • Key (asset_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL

Untitled (carts)

  • Key (id) — INT UNSIGNED — Primary key — NOT NULL
  • Key (user_id) — INT UNSIGNED — Foreign key → users.Key — NOT NULL
  • Key (product_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
  • Field (quantity) — INT — NOT NULL

Untitled (orders)

  • Key (id) — INT UNSIGNED — Primary key — NOT NULL
  • Key (user_id) — INT UNSIGNED — Foreign key → users.Key — NOT NULL
  • Field (status) — VARCHAR(255) — NOT NULL
  • Field (amount) — INT — NOT NULL — amount of money ( yen )

Untitled (order_cart_records)

  • Key (id) — INT UNSIGNED — Primary key — NOT NULL
  • Key (user_id) — INT UNSIGNED — Foreign key → users.Key — NOT NULL
  • Key (order_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
  • Key (product_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
  • Field (quantity) — INT — NOT NULL
  • Field (sell_price) — INT

Untitled (payment)

  • Key (id) — unsignedInteger — Primary key — NOT NULL
  • Field (type) — VARCHAR(255) — NOT NULL
  • Field (expired_at) — DATETIME
  • Field (token) — VARCHAR(255)
  • Key (user_id) — INT UNSIGNED — Foreign key → users.Key — NOT NULL
  • Field (amount) — INT — NOT NULL
  • Key (order_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL

Untitled (settings)

  • Key (id) — INT UNSIGNED — Primary key — NOT NULL
  • Field (key) — VARCHAR(255) — NOT NULL
  • Field (value) — VARCHAR — NOT NULL

users

  • Key (id) — INT UNSIGNED — Primary key — NOT NULL
  • Field (name) — VARCHAR(32) — NOT NULL — ユーザー名
  • Field (screen_name) — VARCHAR(16) — NOT NULL — ユーザーID
  • Field (email) — VARCHAR(255) — NOT NULL — メールアドレス
  • Field (password) — VARCHAR(255) — NOT NULL — パスワード
  • Key (thumbnail_id) — INT UNSIGNED — Foreign key → Untitled.Key — アイコンのID