test
Tables (5)
AutonomousDrivingData
- DataID — INT
- ScenarioData — TEXT — NOT NULL
- CreationDate — DATETIME — NOT NULL
- UpdateStatus — BOOLEAN — NOT NULL
ContextAwareSearchResult
- SearchResultID — INT
- UserID — INT
- SearchQuery — VARCHAR(255) — NOT NULL
- UserContext — JSON — NOT NULL
- ProvidedSearchResult — TEXT — NOT NULL
- UserID (UserID2) — INT — Foreign key → User.UserID
CustomerInquiry
- InquiryID — INT
- UserID — INT
- InquiryContent — TEXT — NOT NULL
- SubmissionMethod — ENUM('Board', 'Chat', 'Phone') — NOT NULL
- SubmissionDate — DATETIME — NOT NULL
- UserID (UserID2) — INT — Foreign key → User.UserID
User
- UserID — INT — Primary key
- Name — VARCHAR(100) — NOT NULL
- Email — VARCHAR(100) — NOT NULL
- Password — VARCHAR(255) — NOT NULL
- RegistrationDate — DATETIME — NOT NULL
- VoiceData — BLOB
- VoiceDataRegistrationDate — DATETIME
VoiceDataAccessLog
- LogID — INT
- UserID — INT
- AccessAttemptDate — DATETIME — NOT NULL
- AccessSuccess — BOOLEAN — NOT NULL
- FraudAlertStatus — BOOLEAN — NOT NULL
- BlockStatus — BOOLEAN — NOT NULL
- UserID (UserID2) — INT — Foreign key → User.UserID