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