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