The SME Veritas platform is built on a structured data model that links every SME to its directors, compliance documents, experience records, grading, credit scoring, verification logs, marketplace entries and payments.
This structured model ensures every SME has a complete, verifiable digital profile. Because all records are linked and auditable, grading is transparent, verifications are fully traceable, and data is handled in line with POPIA and GDPR requirements.
SME_ID (PK), Business_Name, Registration_Number, Sector/Industry, Country, Contact_Info, Profile_Status
Director_ID (PK), SME_ID (FK), Full_Name, ID_Number, Role, Compliance_Flag
Document_ID (PK), SME_ID (FK), Document_Type, File_Path, Upload_Date, Verification_Status, Verified_By
Experience_ID (PK), SME_ID (FK), Project_Name, Project_Value, Client_Name, Completion_Date, Verified_Status
Log_ID (PK), SME_ID (FK), Verification_Type, Action_By, Action_Date, Result, Notes
Grade_ID (PK), SME_ID (FK), Grade_Level, Criteria_Score, Assigned_Date, Validity_Period, Status
Credit_ID (PK), SME_ID (FK), Credit_Score, Risk_Profile, Data_Source, Last_Updated, Monitoring_Alerts
Marketplace_ID (PK), SME_ID (FK), Industry, Grade_Level, Compliance_Status, Credit_Score, Visibility
Payment_ID (PK), Client_ID (FK), SME_ID (FK), Payment_Amount, Payment_Date, Payment_Method, Transaction_Status
Client_ID (PK), Full_Name, Organization, Contact_Info, Account_Status
Every record links back to the SME profile
SME ↔ Directors (One-to-Many)
SME ↔ Compliance Documents (One-to-Many)
SME ↔ Experience Records (One-to-Many)
SME ↔ Grading (One-to-One)
SME ↔ Credit Scoring (One-to-One)
SME ↔ Verification Logs (One-to-Many)
SME ↔ Marketplace (One-to-Many)
SME ↔ Payments & Clients ↔ Payments (One-to-Many)
Clients ↔ Payments (One-to-Many)
SME ↔ Directors: One-to-Many • SME ↔ Compliance Documents: One-to-Many • SME ↔ Experience Records: One-to-Many • SME ↔ Grading: One-to-One • SME ↔ Credit Scoring: One-to-One • SME ↔ Verification Logs: One-to-Many • SME ↔ Marketplace: One-to-Many • SME ↔ Payments: One-to-Many • Clients ↔ Payments: One-to-Many