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

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

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

----
- account (**__id__**, **email**, password_hash, name)
- _user (**__user_id__**, name, **email**, password_hash, login_provider, is_verified, is_profile_complete, has_used_free_consultation, work_position, company_size, points, **account_id***(ACCOUNT))
- expert (**__expert_id__**, **account_id***(ACCOUNT))
- language (**__id__**, **value**)
- course (**__course_id__**, image_url, color, difficulty, duration_minutes, price)
- course_version (**__course_version_id__**, version_number, created_at, is_active, **course_id***(COURSE))
- course_translate (**__course_translate_id__**, title_short, title, description_short, description, description_long, what_will_be_learned, **course_id***(COURSE), **language_id***(LANGUAGE))
- course_content (**__course_content_id__**, position, **course_version_id***(COURSE VERSION))
- course_content_translate (**__course_content_translate_id__**, title, **course_content_id***(COURSE CONTENT), **language_id***(LANGUAGE))
- course_lecture (**__course_lecture_id__**, position, duration_minutes, content_type, **course_content_id***(COURSE CONTENT))
- course_lecture_translate (**__course_lecture_translate_id__**, content_file_name, content_text, title, description, **course_lecture_id***(COURSE LECTURE), **language_id***(LANGUAGE))
- enrollment (**__enrollment_id__**, enrollment_status, purchase_date, activation_date, completion_date, **user_id***(USER), **course_version_id***(COURSE VERSION))
- payment (**__payment_id__**, amount, payment_date, payment_method, payment_status, **enrollment_id***(ENROLLMENT))
- review (**__review_id__**, rating, comment, review_date, **enrollment_id***(ENROLLMENT))
- user_course_progress (**__user_course_progress_id__**, is_completed, completed_at, **enrollment_id***(ENROLLMENT), **course_lecture_id***(COURSE LECTURE))
- verification_token (**__verification_token_uuid__**, created_at, expires_at, **user_id***(USER))
- tag (**__tag_id__**, tag_type)
- tag_translate (**__tag_translate_id__**, value, **tag_id***(TAG), **language_id***(LANGUAGE))
- course_tag (**__course_id__***(COURSE), **__tag_id__***(TAG))
- user_tag (**__user_id__***(USER), **__tag_id__***(TAG))
- user_favorite_course (**__user_id__***(USER), **__course_id__***(COURSE))
- meeting_email_reminder (**__id__**, meeting_at, scheduled_at, sent, meeting_link, **user_id***(USER))

== DDL скрипта за бришење и креирање на табелите
  [attachment:ddl.sql]

== DML скрипта за полнење на табелите со податоци
  [attachment:dml.sql]

== Релациски дијаграм изведен од DataGrip
[[Image(diagram.png, 1000px)]]