Changes between Version 14 and Version 15 of ConceptualModel
- Timestamp:
- 12/17/25 21:38:10 (11 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ConceptualModel
v14 v15 12 12 13 13 * **Users: Entity representing all users who access the platform (students / learners).** 14 * User_ID – P rimary key15 * First_Name – V archar16 * Last_Name – V archar17 * Email – V archar(unique)18 * Password – V archar14 * User_ID – PRIMARY KEY 15 * First_Name – VARCHAR 16 * Last_Name – VARCHAR 17 * Email – VARCHAR(unique) 18 * Password – VARCHAR 19 19 20 20 * **Administrators: Entity representing instructors who create and manage educational content.** 21 * Admin_ID – P rimary key22 * Admin_Level – varchar21 * Admin_ID – PRIMARY KEY 22 * Admin_Level – VARCHAR 23 23 24 24 * **Payment: Entity representing financial transactions.** 25 * Payment_ID – P rimary key26 * Amount – D ecimal25 * Payment_ID – PRIMARY KEY 26 * Amount – DECIMAL 27 27 28 28 * **Course: Entity representing the courses offered on the platform.** 29 * Course_id – P rimary key30 * Certificate – V archar31 * Name – V archar29 * Course_id – PRIMARY KEY 30 * Certificate – VARCHAR 31 * Name – VARCHAR 32 32 * Price – Decimal 33 * status – V archar33 * status – VARCHAR 34 34 35 35 * **Enrollment: Entity representing the enrollment of a user in a course.** 36 * Enrollment_id – P rimary key37 * Enroll_date – D ate38 * Completion_Status – V archar39 * Progress_percentage – int36 * Enrollment_id – PRIMARY KEY 37 * Enroll_date – DATE 38 * Completion_Status – VARCHAR 39 * Progress_percentage – INT 40 40 41 41 * **Payment: Entity representing financial transactions.** 42 * Payment_ID – P rimary key43 * Amount – D ecimal42 * Payment_ID – PRIMARY KEY 43 * Amount – DECIMAL 44 44 45 45 * **SubscriptionPlan: Entity representing available subscription plans.** 46 * Plan_ID – P rimary key47 * Name – V archar48 * Price – D ecimal49 * Duration_months – I nt50 * Description – V archar51 * Access_type – V archar46 * Plan_ID – PRIMARY KEY 47 * Name – VARCHAR 48 * Price – DECIMAL 49 * Duration_months – INT 50 * Description – VARCHAR 51 * Access_type – VARCHAR 52 52 53 53 * **Certificate: Entity representing certificates issued after course completion.** 54 * Certificate_id – P rimary key55 * Issue_date – D ate56 * Certificate_code – V archar57 * Status – V archar54 * Certificate_id – PRIMARY KEY 55 * Issue_date – DATE 56 * Certificate_code – VARCHAR 57 * Status – VARCHAR 58 58 59 59 * **UserSubscription: Entity representing active subscriptions of users.** 60 * Subscription_ID – P rimary key61 * Start_date – D ate62 * End_date – D ate63 * Status – V archar60 * Subscription_ID – PRIMARY KEY 61 * Start_date – DATE 62 * End_date – DATE 63 * Status – VARCHAR 64 64 65 65 * **SupportTicket: Entity representing user support requests.** 66 * Ticket_ID – P rimary key67 * Subject – V archar68 * Description – V archar69 * Status – V archar70 * Created_at – D ate66 * Ticket_ID – PRIMARY KEY 67 * Subject – VARCHAR 68 * Description – VARCHAR 69 * Status – VARCHAR 70 * Created_at – DATE 71 71 72 72 * **Category: Entity representing course classification.** 73 * Category_ID – P rimary key74 * Name – V archar75 * Description – V archar73 * Category_ID – PRIMARY KEY 74 * Name – VARCHAR 75 * Description – VARCHAR 76 76 77 77 * **Module: Entity representing logical subdivisions of a course.** 78 * Мodule_id – P rimary key79 * Тitle – V archar80 * Description – V archar78 * Мodule_id – PRIMARY KEY 79 * Тitle – VARCHAR 80 * Description – VARCHAR 81 81 82 82 * **Lesson: Entity representing individual learning units.** 83 * Lesson_ID – P rimary key84 * Тitle – V archar85 * Material – V archar83 * Lesson_ID – PRIMARY KEY 84 * Тitle – VARCHAR 85 * Material – VARCHAR 86 86 87 87 * **Quiz: Entity representing assessments associated with lessons.** 88 * Quiz_ID – P rimary key89 * Total_points – I nt90 * Passing_score – I nt88 * Quiz_ID – PRIMARY KEY 89 * Total_points – INT 90 * Passing_score – INT 91 91 92 92 === Relationships ===
