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