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