Changes between Version 9 and Version 10 of ConceptualModel


Ignore:
Timestamp:
12/17/25 16:47:57 (11 days ago)
Author:
221296
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ConceptualModel

    v9 v10  
    1111=== Entities ===
    1212
    13 * **Users**
    14 Entity representing all users who access the platform (students / learners).
    15   * user_id – primary key
    16   * first_name – varchar
    17   * last_name – varchar
    18   * email – varchar (unique)
    19   * password – varchar
     13* **Users: Entity representing all users who access the platform (students / learners).**
     14  * user_id – Primary key
     15  * first_name – Varchar
     16  * last_name – Varchar
     17  * email – Varchar(unique)
     18  * password – Varchar
    2019
    21 * **Instructors**
    22   * instructor_id (primary key)
    23   * bio
    24   * expertise
     20* **Administrators: Entity representing instructors who create and manage educational content.**
     21  * Admin_ID – Primary key
     22  * Admin_Level – varchar
    2523
    26 * **Course**
    27   * course_id (primary key)
    28   * name
    29   * price
    30   * status
     24* **Payment: Entity representing financial transactions.**
     25  * Payment_ID – Primary key
     26  * Amount – Decimal
     27 
     28* **Course: Entity representing the courses offered on the platform.**
     29  * Course_id – Primary key
     30  * Certificate – Varchar
     31  * Name – Varchar
     32  * Price – Decimal
     33  * status – Varchar
    3134
    32 * **Enrollment**
    33   * enrollment_id (primary key)
    34   * enroll_date
    35   * completion_status
    36   * progress_percentage
     35* **Enrollment: Entity representing the enrollment of a user in a course.**
     36  * Enrollment_id – Primary key
     37  * Enroll_date – Date
     38  * Completion_Status – Varchar
     39  * Progress_percentage – int
    3740
    38 * **Payment**
    39   * payment_id (primary key)
    40   * amount
     41* **Payment: Entity representing financial transactions.**
     42  * Payment_ID – Primary key
     43  * Amount – Decimal
    4144
    42 * **SubscriptionPlan**
    43   * plan_id (primary key)
    44   * name
    45   * price
    46   * duration_months
    47   * access_type
     45* **SubscriptionPlan: Entity representing available subscription plans.**
     46  * Plan_ID – Primary key
     47  * Name – Varchar
     48  * Price – Decimal
     49  * Duration_months – Int
     50  * Description – Varchar
     51  * Access_type – Varchar
    4852
    49 * **Certificate**
    50   * certificate_id (primary key)
    51   * issue_date
    52   * certificate_code
    53   * status
     53* **Certificate: Entity representing certificates issued after course completion.**
     54  * Certificate_id – Primary key
     55  * Issue_date – Date
     56  * Certificate_code – Varchar
     57  * Status – Varchar
     58
     59* **UserSubscription: Entity representing active subscriptions of users.**
     60  * Subscription_ID – Primary key
     61  * Start_date – Date
     62  * End_date – Date
     63  * Status – Varchar
     64
     65* **SupportTicket: Entity representing user support requests.**
     66  * Ticket_ID – Primary key
     67  * Subject – Varchar
     68  * Description – Varchar
     69  * Status – Varchar
     70  * Created_at – Date
     71
     72* **Category: Entity representing course classification.**
     73  * Category_ID – Primary key
     74  * Name – Varchar
     75  * Description – Varchar
     76
     77* **Module: Entity representing logical subdivisions of a course.**
     78  * Мodule_id – Primary key
     79  * Тitle – Varchar
     80  * Description – Varchar
     81 
     82* **Lesson: Entity representing individual learning units.**
     83  * Lesson_ID – Primary key
     84  * Тitle – Varchar
     85  * Material – Varchar
     86 
     87* **Quiz: Entity representing assessments associated with lessons.**
     88  *  Quiz_ID – Primary key
     89  * Total_points – Int
     90  * Passing_score – Int
    5491
    5592=== Relationships ===