web29_bmtown

Tables (7)

Users

  • user_id — INT(11) UNSIGNED AUTO_INCREMENT — Primary key — NOT NULL
  • email — VARCHAR(255) UNIQUE — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • provider — VARCHAR(255) — NOT NULL
  • provider_id — INT(11)
  • profile_path — VARCHAR(255)
  • top_id — INT(11) UNSIGNED AUTO_INCREMENT — Foreign key → avatar_assets.avatar_asset_id — NOT NULL
  • bottom_id — INT(11) UNSIGNED AUTO_INCREMENT — Foreign key → avatar_assets.avatar_asset_id — NOT NULL
  • facial_id — INT(11) UNSIGNED AUTO_INCREMENT — Foreign key → avatar_assets.avatar_asset_id — NOT NULL

assets (objects)

  • asset_id (object_id) — INT(11) UNSIGNED AUTO_INCREMENT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • path — VARCHAR(255) — NOT NULL
  • workspace_id — INT(11) UNSIGNED AUTO_INCREMENT — Foreign key → workspaces.workspace_id — Empty -> common, Not Empty -> depends on workspaces

avatar_assets

  • avatar_asset_id — INT(11) UNSIGNED AUTO_INCREMENT — Primary key — NOT NULL
  • path — VARCHAR(255) — NOT NULL
  • type — ENUM('FACIAL', 'TOP', 'BOTTOM') — NOT NULL

maps

  • map_id — INT(11) UNSIGNED AUTO_INCREMENT — Primary key — NOT NULL
  • path — VARCHAR(255) — NOT NULL

user_workspaces

  • user_id — INT(11) UNSIGNED AUTO_INCREMENT — Foreign key → Users.user_id — NOT NULL
  • workspace_id — INT(11) UNSIGNED AUTO_INCREMENT — Foreign key → workspaces.workspace_id — NOT NULL

workspace_assets (workspace_objects)

  • workspace_asset_id (workspace_object_id) — INT(11) UNSIGNED AUTO_INCREMENT — Primary key — NOT NULL
  • position_x — INT(11) UNSIGNED — NOT NULL
  • position_y — INT(11) UNSIGNED — NOT NULL
  • workspace_id — INT(11) UNSIGNED AUTO_INCREMENT — Foreign key → workspaces.workspace_id — NOT NULL
  • asset_id (object_id) — INT(11) UNSIGNED AUTO_INCREMENT — Foreign key → assets.asset_id — NOT NULL
  • Field

workspaces

  • workspace_id — INT(11) UNSIGNED AUTO_INCREMENT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • map_id — INT(11) UNSIGNED AUTO_INCREMENT — Foreign key → maps.map_id — NOT NULL