crescendo-central-api
Tables (6)
Untitled (discords)
- Key (id) — INT — Primary key — NOT NULL
- Key (user_id) — INT — Foreign key → Users.Key — NOT NULL
- Field (discord_id) — CHAR(18) — NOT NULL
Untitled (items)
- Key (id) — INT — Primary key — NOT NULL
- Key (client_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (sku) — VARCHAR(255) — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (image_url) — VARCHAR(255) — NOT NULL
- Field (price) — INT — NOT NULL
- Field (enabled) — BIT(1) — NOT NULL
- Field (consumable) — BIT(1) — NOT NULL
- Field (expiration_time) — INT
- Field (purchase_limit) — INT
Untitled (user_items)
- Key (id) — INT — Primary key — NOT NULL
- Key (user_id) — INT — Foreign key → Users.Key — NOT NULL
- Key (item_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (expired) — BIT(1) — NOT NULL
- Field (consumed) — BIT(1) — NOT NULL
- Field (sync) — BIT(1) — NOT NULL
- Field (create_time) — TIMESTAMP — NOT NULL
- Field (update_time) — TIMESTAMP — NOT NULL
Untitled (receipts)
- Key (id) — INT — Primary key — NOT NULL
- Key (user_id) — INT — Foreign key → Users.Key — NOT NULL
- Key (client_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (user_item_id) — INT — Foreign key → Untitled.Key
- Field (about_cash) — BIT(1) — NOT NULL
- Field (refund) — BIT(1) — NOT NULL
- Field (points_old) — INT — NOT NULL
- Field (points_new) — INT — NOT NULL
- Field (timestamp) — TIMESTAMP — NOT NULL
Untitled (clients)
- Key (id) — INT — Primary key — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field2 (token) — VARCHAR(255) — NOT NULL
Users (users)
- Key (id) — INT — Primary key — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (email) — VARCHAR(255) — NOT NULL
- Field (password) — VARCHAR(255) — NOT NULL
- Field (points) — BIGINT — NOT NULL