Entity Relationship Diagram

Data
IT Management
Software
This schema offers a comprehensive view of operational data, supporting both transactional processing and analytical queries for educational purposes.
Title Entity Relationship Diagram
Doc# DOC-DATA-001
Version 1.0
Date 18-02-2023

This schema offers a comprehensive view of operational data, supporting both transactional processing and analytical queries for educational purposes.

USERSintuserIdPKstringusernamestringpasswordstringemailstringroleSERVICESintserviceIdPKstringserviceNamestringdescriptionfloatpricestringstatusTRANSACTIONSinttransactionIdPKintuserIdFKintserviceIdFKdateTimetransactionDatestringtransactionTypefloatamountTICKETSintticketIdPKintuserIdFKdateTimecreationDatestringstatustextdescriptionLOGSintlogIdPKintuserIdFKdateTimelogDatestringlogTypetextlogDescriptionusestriggersfilesgenerates

Explanation:

  • Users Table: Manages user credentials and roles. Each user can use multiple services.
  • Services Table: Lists the services offered by CloudCore Networks. Services can trigger multiple transactions.
  • Transactions Table: Logs financial transactions or service changes linked to users and services.
  • Tickets Table: Manages support tickets created by users, providing a connection for customer support activities.
  • Logs Table: Keeps records of activities, which could be system-generated or user-generated, providing audit trails or system operation insights.