musivrse

Tables (6)

Assets (assets)

  • Unique ID (uuid) — UUID PK — Primary key — NOT NULL
  • Hash (hash) — CHAR(64) UNIQUE
  • Type (type)
  • File Name (filename) — VARCHAR(100)
  • URL Override (urlOverride) — VARCHAR(300) NULL

Avatar (avatars)

  • Relation UUID (uuid) — UUID PK — Primary key — NOT NULL
  • Owner ID (ownerId) — UUID — Foreign key → UserInfo.Unique ID — NOT NULL
  • Asset ID (assetId) — UUID — Foreign key → Assets.Unique ID — NOT NULL

Inventory (inventory)

  • Inventory UUID (uuid) — UUID PK — Primary key — NOT NULL
  • Owner ID (ownerId) — UUID — Foreign key → UserInfo.Unique ID — NOT NULL
  • Data (data) — JSON

Performance Recording (performance)

  • Performance UUID (uuid) — UUID PK — Primary key — NOT NULL
  • Owner ID (ownerId) — UUID — Foreign key → UserInfo.Unique ID — NOT NULL
  • Title (title) — VARCHAR(100)
  • Thumbnail (thumbnail) — UUID FK
  • Participants (participants) — UUID[]
  • World Map (worldMap) — UUID FK
  • Description (description) — VARCHAR(500)
  • Public/Private (isPublic) — BOOL

Room (room)

  • Room UUID (uuid) — UUID PK — Primary key — NOT NULL
  • Host ID (hostId) — UUID — Foreign key → UserInfo.Unique ID — NOT NULL
  • Title (title) — VARCHAR(100)
  • Max Player (maxPlayer) — INTEGER
  • Password (password) — CHAR(64)
  • Thumbnail (thumbnail) — UUID FK
  • Participants (participants) — UUID[]
  • World Map (worldMap) — UUID FK

UserInfo (users)

  • Unique ID (uuid) — UUID PK — Primary key — NOT NULL
  • Login ID (id) — VARCHAR(30) UNIQUE
  • Login PW (pw) — CHAR(64)
  • Email (email) — VARCHAR(50) UNIQUE
  • Email Verified (emailVerified) — BOOL
  • Display Name (displayName) — VARCHAR(30)
  • Description (description) — VARCHAR(400)