A-call_hsj

Tables (5)

App

  • AppID — INT — Primary key — NOT NULL
  • AppName — VARCHAR(100)
  • AppURL — VARCHAR(255)
  • DateCreated — DATETIME
  • RequestID — INT — Foreign key → Request.RequestID — NOT NULL
  • UserID — INT — Foreign key → Request.UserID — NOT NULL

AppContent

  • AppContentID (Key) — INT — Primary key — NOT NULL
  • AppID — INT — Foreign key → App.AppID — NOT NULL
  • ContentType — VARCHAR(50)
  • ContentData — JSON
  • DateCreated — DATETIME
  • DateUpdated — DATETIME

ChatLog

  • ChatID — INT — Primary key — NOT NULL
  • UserID — INT — Foreign key → User.UserID — NOT NULL
  • Message — TEXT
  • Time — DATETIME

Request

  • RequestID — INT — Primary key — NOT NULL
  • UserID — INT — Foreign key → User.UserID — NOT NULL
  • RequestDetails — TEXT
  • Status — VARCHAR(30)
  • DateCreated (DateSubmitted) — DATETIME
  • DateUpdated — DATETIME

User

  • UserID — INT — Primary key — NOT NULL
  • UserName — VARCHAR(50)
  • Password — VARCHAR(100)
  • DateJoined — DATETIME