= Логички и физички дизајн 

== Релациска шема (со парцијално мапирање)

- примарни клучеви - болдирани и подвлечени
- надворешни клучеви - * до името на надворешниот клуч и во заграда табелата кон која референцира
- not null атрибути: bold
- Останати атрибути: без ознака 

----
- _user (**__id__**, name, **email**, login_provider, password_hash, is_verified, is_profile_complete, has_used_free_consultation, company_size, work_position, points)
- user_favorite_course_ids (**__user__***(USER), favorite_course_ids)
- verification_token (**__uuid__**, created_at, expires_at, **user_id***(USER))
- expert (**__id__**, name, **email**, login_provider, password_hash)
- enrollment (**__id__**, enrollment_status, purchase_date, activation_date, completion_date, **course_version_id*** (COURSE VERSION), **user_id*** (USER))
- payment(**__id__**, amount, payment_date, payment_method, payment_status, **enrollment_id***(ENROLLMENT))
- review (**__id__**, rating, comment, review_date, **enrollment_id***(ENROLLMENT))
- course_version (**__id__**, version_number, created_at, is_active, **course_id***(COURSE))
- course (**__id__**, image_url, color, difficulty, duration_minutes, price)
- course_translate (**__id__**, language, title_short, title, description_short, description, description_long, **course_id***(COURSE))
- course_translate_what_will_be_learned (**__course_id__***(COURSE), what_will_be_learned)
- course_content (**__id__**, position, **course_version_id***(COURSE VERSION))
- course_content_translate (**__id__**, title, language, **course_content_id***(COURSE CONTENT))
- course_lecture (**__id__**, duration_minutes, position, content_type, **course_content_id***(COURSE CONTENT))
- course_lecture_translate (**__id__**, language, content_file_name, title, description, content_text, **course_lecture_id***(COURSE LECTURE))
- tag (**__id__**, type)
- tag_translate (**__id__**, language, value, **tag_id***(TAG))
- course_tag (**__course_id__***(COURSE), **__tag_id__***(TAG))
- user_tag (**__user_id__***(USER), **__tag_id__***(TAG))
- user_course_progress (**__id__**, is_completed, completed_at, **enrollment_id***(ENROLLMENT), **course_lecture_id***(COURSE LECTURE))


== DDL скрипта за бришење и креирање на табелите
  [[null]]

== DML скрипта за полнење на табелите со податоци
  [[null]]

== Релациски дијаграм изведен од DBeaver
[[Image(schema.png)]]