/Dbdiagram

The database design for Guvi Zen Class models various entities such as users, batches, problems, codekata, topics, attendance, tasks, and class sessions, establishing relationships to efficiently manage data related to an educational platform.

Guvi Zen Class Database Model

This project contains the database model for the Guvi Zen Class. It includes tables for users, batches, problems, codekata, topics, attendance, tasks, and zen_class.

Project Structure

The database is modeled using PostgreSQL. Below are the tables and their relationships:

Tables

  1. users

    • id (Primary Key)
    • userName: Name of the user.
    • userEmail: Email of the user (unique).
    • userContactDetails: Contact details of the user.
    • userBatchId: Foreign key referencing Batch.id.
    • feesPaid: Boolean indicating if the fees are paid.
    • placementEnabled: Boolean indicating if placement is enabled.
    • userPrimaryLanguage: Primary language of the user.
    • userSecondaryLanguage: Secondary language of the user.
    • isCourseRestarted: Boolean indicating if the course is restarted.
    • userRole: Role of the user.

  2. Batch

    • id (Primary Key)
    • batchName: Name of the batch.
    • batchStartTiming: Start time of the batch.
    • batchEndTiming: End time of the batch.
    • batchCourse: Course name of the batch.
    • mentorId: ID of the mentor.
    • batchCoordinatorId: ID of the batch coordinator.
    • studentCoordinatorId: ID of the student coordinator.
    • closureDate: Closure date of the batch.
    • batchStrength: Strength of the batch.

  3. Problems

    • id (Primary Key)
    • problemName: Name of the problem.
    • problemStatement: Statement of the problem.
    • problemDifficultyLevel: Difficulty level of the problem.
    • problemCompletionPoints: Completion points of the problem.

  4. Codekata

    • id (Primary Key)
    • problemId: Foreign key referencing Problems.id.
    • userId: Foreign key referencing users.id.
    • createdOn: Timestamp when the codekata was created.
    • updatedOn: Timestamp when the codekata was last updated.
    • progress: Progress of the codekata.
    • earnedPoints: Points earned from the codekata.

  5. Topics

    • id (Primary Key)
    • topicName: Name of the topic.
    • topicContent: Content of the topic.
    • topicPreread: Preread material for the topic.
    • topicDate: Date of the topic.
    • topicActivity: Activity associated with the topic.
    • topicTags: Tags associated with the topic.
    • topicTimelineId: Foreign key referencing zen_class.day.
    • topicType: Type of the topic (Regular/Additional).
    • topicTaskId: Foreign key referencing Tasks.id.

  6. Attendance

    • id (Primary Key)
    • batchId: Foreign key referencing Batch.id.
    • userId: Foreign key referencing users.id.
    • isPresent: Boolean indicating if the user is present.
    • taskId: Foreign key referencing Tasks.id.
    • date: Date of the attendance.

  7. Tasks

    • id (Primary Key)
    • student_id: Foreign key referencing users.id.
    • day: Foreign key referencing zen_class.day.
    • task_completion: Status of task completion.

  8. zen_class

    • day (Primary Key)
    • topic: Topic covered on the day.
    • task: Task assigned on the day.
    • recorded_link: Link to the recorded session.
    • mentor: Mentor for the session.

How to Use

  1. Clone the repository: 
    git clone https://github.com/suganyarajes/Dbdiagram.git