Changes between Version 7 and Version 8 of RelationalDesign


Ignore:
Timestamp:
08/05/26 21:58:56 (10 hours ago)
Author:
231175
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v7 v8  
    99
    1010----
    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))
     11- account (**__id__**, **email**, password_hash, name)
     12- _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))
     13- expert (**__expert_id__**, **account_id***(ACCOUNT))
     14- language (**__id__**, **value**)
     15- course (**__course_id__**, image_url, color, difficulty, duration_minutes, price)
     16- course_version (**__course_version_id__**, version_number, created_at, is_active, **course_id***(COURSE))
     17- course_translate (**__course_translate_id__**, title_short, title, description_short, description, description_long, what_will_be_learned, **course_id***(COURSE), **language_id***(LANGUAGE))
     18- course_content (**__course_content_id__**, position, **course_version_id***(COURSE VERSION))
     19- course_content_translate (**__course_content_translate_id__**, title, **course_content_id***(COURSE CONTENT), **language_id***(LANGUAGE))
     20- course_lecture (**__course_lecture_id__**, position, duration_minutes, content_type, **course_content_id***(COURSE CONTENT))
     21- course_lecture_translate (**__course_lecture_translate_id__**, content_file_name, content_text, title, description, **course_lecture_id***(COURSE LECTURE), **language_id***(LANGUAGE))
     22- enrollment (**__enrollment_id__**, enrollment_status, purchase_date, activation_date, completion_date, **user_id***(USER), **course_version_id***(COURSE VERSION))
     23- payment (**__payment_id__**, amount, payment_date, payment_method, payment_status, **enrollment_id***(ENROLLMENT))
     24- review (**__review_id__**, rating, comment, review_date, **enrollment_id***(ENROLLMENT))
     25- user_course_progress (**__user_course_progress_id__**, is_completed, completed_at, **enrollment_id***(ENROLLMENT), **course_lecture_id***(COURSE LECTURE))
     26- verification_token (**__verification_token_uuid__**, created_at, expires_at, **user_id***(USER))
     27- tag (**__tag_id__**, tag_type)
     28- tag_translate (**__tag_translate_id__**, value, **tag_id***(TAG), **language_id***(LANGUAGE))
    2829- course_tag (**__course_id__***(COURSE), **__tag_id__***(TAG))
    2930- 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 
     31- user_favorite_course (**__user_id__***(USER), **__course_id__***(COURSE))
     32- meeting_email_reminder (**__id__**, meeting_at, scheduled_at, sent, meeting_link, **user_id***(USER))
    3233
    3334== DDL скрипта за бришење и креирање на табелите
    34   [attachment:schema_creation.sql]
     35  [attachment:ddl.sql]
    3536
    3637== DML скрипта за полнење на табелите со податоци
    37   [attachment:data_load.sql]
     38  [attachment:dml.sql]
    3839
    3940== Релациски дијаграм изведен од DBeaver