Changes between Version 21 and Version 22 of ConceptualModel
- Timestamp:
- 12/18/25 08:44:03 (11 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ConceptualModel
v21 v22 10 10 === Entities === 11 11 12 * **User s: Entity representing all users who access the platform (students / learners).**13 * User_ID – PRIMARY KEY12 * **User: Entity representing all users who access the platform (students / learners).** 13 * User_ID – INT (PRIMARY KEY) 14 14 * First_Name – VARCHAR 15 15 * Last_Name – VARCHAR … … 17 17 * Password – VARCHAR 18 18 19 * **Administrator s: Entity representing instructors who create and manage educational content.**20 * Admin_ID – PRIMARY KEY19 * **Administrator: Entity representing instructors who create and manage educational content.** 20 * Admin_ID – INT (PRIMARY KEY) 21 21 * Admin_Level – VARCHAR 22 22 23 * **Payment: Entity representing financial transactions.** 24 * Payment_ID – PRIMARY KEY 25 * Amount – DECIMAL 23 * **Instructor: Entity representing instructors who upload and manage course materials.** 24 * Instructor_ID – INT (PRIMARY KEY) 25 * BIO – VARCHAR 26 * Ekspertise – VARCHAR 26 27 27 28 * **Course: Entity representing the courses offered on the platform.** 28 * Course_id – PRIMARY KEY29 * Course_id – INT (PRIMARY KEY) 29 30 * Certificate – VARCHAR 30 31 * Name – VARCHAR … … 33 34 34 35 * **Enrollment: Entity representing the enrollment of a user in a course.** 35 * Enrollment_id – PRIMARY KEY36 * Enrollment_id – INT (PRIMARY KEY) 36 37 * Enroll_date – DATE 37 38 * Completion_Status – VARCHAR … … 43 44 44 45 * **SubscriptionPlan: Entity representing available subscription plans.** 45 * Plan_ID – PRIMARY KEY46 * Plan_ID – INT (PRIMARY KEY) 46 47 * Name – VARCHAR 47 48 * Price – DECIMAL … … 51 52 52 53 * **Certificate: Entity representing certificates issued after course completion.** 53 * Certificate_id – PRIMARY KEY54 * Certificate_id – INT (PRIMARY KEY) 54 55 * Issue_date – DATE 55 56 * Certificate_code – VARCHAR … … 57 58 58 59 * **UserSubscription: Entity representing active subscriptions of users.** 59 * Subscription_ID – PRIMARY KEY60 * Subscription_ID – INT (PRIMARY KEY) 60 61 * Start_date – DATE 61 62 * End_date – DATE … … 63 64 64 65 * **SupportTicket: Entity representing user support requests.** 65 * Ticket_ID – PRIMARY KEY66 * Ticket_ID – INT (PRIMARY KEY) 66 67 * Subject – VARCHAR 67 68 * Description – VARCHAR … … 70 71 71 72 * **Category: Entity representing course classification.** 72 * Category_ID – PRIMARY KEY73 * Category_ID – INT (PRIMARY KEY) 73 74 * Name – VARCHAR 74 75 * Description – VARCHAR 75 76 76 77 * **Module: Entity representing logical subdivisions of a course.** 77 * Мodule_id – PRIMARY KEY78 * Мodule_id – INT (PRIMARY KEY) 78 79 * Тitle – VARCHAR 79 80 * Description – VARCHAR 80 81 81 82 * **Lesson: Entity representing individual learning units.** 82 * Lesson_ID – PRIMARY KEY83 * Lesson_ID – INT (PRIMARY KEY) 83 84 * Тitle – VARCHAR 84 85 * Material – VARCHAR 85 86 86 87 * **Quiz: Entity representing assessments associated with lessons.** 87 * Quiz_ID – PRIMARY KEY88 * Quiz_ID – INT (PRIMARY KEY) 88 89 * Total_points – INT 89 90 * Passing_score – INT
