| | 1 | = Логички и физички дизајн |
| | 2 | |
| | 3 | == Релациска шема (со парцијално мапирање) |
| | 4 | |
| | 5 | - примарни клучеви - болдирани и подвлечени |
| | 6 | - надворешни клучеви - * до името на надворешниот клуч и во заграда табелата кон која референцира |
| | 7 | - not null атрибути: bold |
| | 8 | - Останати атрибути: без ознака |
| | 9 | |
| | 10 | ---- |
| | 11 | - _user (**__id__**, name, **email**, login_provider, password_hash, is_verified, is_profile_complete, has_used_free_consultation, company_size, work_position, points) |
| | 12 | - user_favorite_course_ids (**__user__***(USER), favorite_course_ids) |
| | 13 | - verification_token (**__uuid__**, created_at, expires_at, **user_id***(USER)) |
| | 14 | - expert (**__id__**, name, **email**, login_provider, password_hash) |
| | 15 | - enrollment (**__id__**, enrollment_status, purchase_date, activation_date, completion_date, **course_version_id*** (COURSE VERSION), **user_id*** (USER)) |
| | 16 | - payment(**__id__**, amount, payment_date, payment_method, payment_status, **enrollment_id***(ENROLLMENT)) |
| | 17 | - review (**__id__**, rating, comment, review_date, **enrollment_id***(ENROLLMENT)) |
| | 18 | - course_version (**__id__**, version_number, created_at, is_active, **course_id***(COURSE)) |
| | 19 | - course (**__id__**, image_url, color, difficulty, duration_minutes, price) |
| | 20 | - course_translate (**__id__**, language, title_short, title, description_short, description, description_long, **course_id***(COURSE)) |
| | 21 | - course_translate_what_will_be_learned (**__course_id__***(COURSE), what_will_be_learned) |
| | 22 | - course_content (**__id__**, position, **course_version_id***(COURSE VERSION)) |
| | 23 | - course_content_translate (**__id__**, title, language, **course_content_id***(COURSE CONTENT)) |
| | 24 | - course_lecture (**__id__**, duration_minutes, position, content_type, **course_content_id***(COURSE CONTENT)) |
| | 25 | - course_lecture_translate (**__id__**, language, content_file_name, title, description, content_text, **course_lecture_id***(COURSE LECTURE)) |
| | 26 | - tag (**__id__**, type) |
| | 27 | - tag_translate (**__id__**, language, value, **tag_id***(TAG)) |
| | 28 | - course_tag (**__course_id__***(COURSE), **__tag_id__***(TAG)) |
| | 29 | - user_tag (**__user_id__***(USER), **__tag_id__***(TAG)) |
| | 30 | - user_course_progress (**__id__**, is_completed, completed_at, **enrollment_id***(ENROLLMENT), **course_lecture_id***(COURSE LECTURE)) |
| | 31 | |
| | 32 | |
| | 33 | == DDL скрипта за бришење и креирање на табелите |
| | 34 | [[null]] |
| | 35 | |
| | 36 | == DML скрипта за полнење на табелите со податоци |
| | 37 | [[null]] |
| | 38 | |
| | 39 | == Релациски дијаграм изведен од DBeaver |
| | 40 | [[Image(schema.png)]] |
