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