infidea-studio-erd
Tables (14)
AllocatedPreset
- AllocatedPresetID — INT
- PresetID — INT
- CrewID — INT
- CrewManagerID — INT
- Quantity — INT
- InUseQuantity — INT
Crew
- CrewID — INT
- Name — NVARCHAR(100)
- Description — NVARCHAR(MAX)
- CrewManagerID — INT
CrewMember
- CrewMemberID — INT
- CrewID — INT
- UserID — INT
GPUProfile
- GPUProfileID — INT
- NodeID — INT
- CardNumber — INT
- GPUMemory — NVARCHAR(50)
- UUID — NVARCHAR(100)
Node
- NodeID — INT
- ModelSeries — NVARCHAR(100)
- Manufacturer — NVARCHAR(100)
- AcceleratorProcessor — NVARCHAR(100)
- Cores — INT
- MemorySize — INT
OccupiedPreset
- OccupiedPresetID — INT
- PresetID — INT
- CrewID — INT
- UserID — INT
- CPU — INT
- RAM — INT
- GPU — INT
- Quantity — INT
- InUseQuantity — INT
- OccupancyDuration — INT
- InstanceID — INT
Preset
- PresetID — INT
- Name — NVARCHAR(100)
- CPU — INT
- RAM — INT
- GPU — INT
- Status — NVARCHAR(20)
Project
- ProjectID — INT
- Name — NVARCHAR(100)
- Description — NVARCHAR(MAX)
- Status — NVARCHAR(50)
- OwnerID — INT
ProjectMember
- ProjectMemberID — INT
- ProjectID — INT
- UserID — INT
- Role — NVARCHAR(20)
SharedFolder
- FolderID — INT
- Path — NVARCHAR(MAX)
- RWStatus — NVARCHAR(10)
- Description — NVARCHAR(MAX)
- Usage — INT
- TotalAllocation — INT
- ProjectID — INT
SignUpRequest
- RequestID — INT
- UserID — INT
- ID — NVARCHAR(100)
- Password — NVARCHAR(255)
- Name — NVARCHAR(100)
- Email — NVARCHAR(255)
- Crew — NVARCHAR(50)
Tool
- ToolID — INT
- Category — NVARCHAR(50)
- Description — NVARCHAR(MAX)
- URLs — NVARCHAR(MAX)
- ProjectID — INT
UsageStatistics
- UsageStatisticsID — INT
- OccupiedPresetID — INT
- LastAccessTime — DATETIME
- StartDate — DATETIME
- EndDate — DATETIME
- UnusedResourceTime — INT
- CPUDuration — INT
- RAMDuration — INT
- GPUDuration — INT
User
- UserID — INT
- Password — NVARCHAR(255)
- Name — NVARCHAR(100)
- Email — NVARCHAR(255)
- Status — NVARCHAR(50)
- Crew — NVARCHAR(50)
- Role — NVARCHAR(20)
- CreatedOn — DATETIME
- Approval — NVARCHAR(100)
- LastActivity — DATETIME