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)