sw
Tables (10)
AccessManagement
- AccessID — INT
- UserID — INT
- AccessType — VARCHAR(50)
- AccessDate — DATETIME
- IPAddress — VARCHAR(15)
- Device — VARCHAR(50)
CopyrightManagement
- CopyrightID — INT
- SoftwareID — INT
- CopyrightHolder — VARCHAR(100)
- RegistrationDate — DATETIME
- ExpiryDate — DATETIME
- Status — VARCHAR(50)
CustomerManagement
- CustomerID — INT — Primary key
- CustomerName — VARCHAR(100)
- ContactNumber — VARCHAR(15)
- Email — VARCHAR(100)
- Address — VARCHAR(255)
- City — VARCHAR(50)
- Country — VARCHAR(50)
- PostalCode — VARCHAR(10)
OrderManagement
- OrderID — INT — Primary key
- CustomerID — INT
- PartnerID — INT
- SoftwareID — INT
- OrderDate — DATETIME
- DeliveryDate — DATETIME
- Status — VARCHAR(50)
- TotalPrice — DECIMAL
- PaymentStatus — VARCHAR(50)
PartnerManagement
- PartnerID — INT — Primary key
- PartnerName — VARCHAR(100)
- ContactNumber — VARCHAR(15)
- Email — VARCHAR(100)
- Address — VARCHAR(255)
- City — VARCHAR(50)
- Country — VARCHAR(50)
- PostalCode — VARCHAR(10)
PermissionManagement
- PermissionID — INT
- UserID — INT
- RoleID — INT
- PermissionLevel — VARCHAR(50)
- Status — VARCHAR(50)
SAMDBManagement
- SAMDBID — INT
- SoftwareID — INT
- LicenseKey — VARCHAR(255)
- ActivationDate — DATETIME
- ExpiryDate — DATETIME
- Status — VARCHAR(50)
SDKFileManagement
- SDKFileID — INT
- SoftwareID — INT
- FilePath — VARCHAR(255)
- FileName — VARCHAR(100)
- FileSize — INT
- FileType — VARCHAR(50)
SWFileManagement
- FileID — INT — Primary key
- SoftwareID — INT
- FilePath — VARCHAR(255)
- FileName — VARCHAR(100)
- FileSize — INT
- FileType — VARCHAR(50)
SWInformationManagement
- SoftwareID — INT
- SoftwareName — VARCHAR(100)
- Version — VARCHAR(50)
- Vendor — VARCHAR(100)
- Description — TEXT
- ReleaseDate — DATETIME