Changes between Version 9 and Version 10 of WikiStart/RelationalDesign


Ignore:
Timestamp:
01/19/24 20:02:10 (8 months ago)
Author:
133039
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • WikiStart/RelationalDesign

    v9 v10  
    99- student(student_id, username, s_first_name, s_last_name, s_password)
    1010- subject-book(book_id, book_title, b_year_of_publishment, book_edition)
    11 chapter(book_id*, chapter_number, chapter_title)
    12 * референцира од subject_book(book_id)
    13 author(author_id, author_name, a_short_biography)
    14 feedback(fb_id, fb_date, fb_title, fb_description, fb_rating)
    15 e-mail(student_id*, e-mail_id, e-mail_address)
    16 * референцира од student(student_id)
    17 school_year(student_id*, starting_year, finishing_year)
    18 *референцира од student(student_id)
    19 term(student_id*, starting_year*, finishing_year*, term_type, term_start_date, term_end_date)
    20 *референцира од school_year(student_id, starting_year, finishing_year)
    21 subject_at_term(student_id*, starting_year*, finishing_year*, term_type*, term_subject_id, subject_name)
    22 *референцира од term(student_id, starting_year, finishing_year, term_type)
    23 professor(professor_id, p_first_name, p_last_name, p_role, p_e-mail)
    24 dashboard(student_id*, dashboard_id, dashboard_date)
    25 *референцира од student(student_id)
    26 notes(student_id*, dashboard_id*, note_id, notes_Date, note_text)
    27 *референцира од dashboard(student_id, dashboard_id)
    28 place(place_id, building_name, room_name)
    29 chalendar_event(chalendar_event_id, event_name, event_type, event_description, event_start_time, event_end_time)
    30 task(task_id, task_name, task_description, task_priority, is_done)
    31 reminder(calendar_event_id*, r_id, minutes_before_event, r_flag)
    32 *референцира од calendar_event(calendar _event_id)
     11-chapter(book_id*, chapter_number, chapter_title)
     12  * референцира од subject_book(book_id)
     13- author(author_id, author_name, a_short_biography)
     14- feedback(fb_id, fb_date, fb_title, fb_description, fb_rating)
     15- e-mail(student_id*, e-mail_id, e-mail_address)
     16  * референцира од student(student_id)
     17- school_year(student_id*, starting_year, finishing_year)
     18  *референцира од student(student_id)
     19- term(student_id*, starting_year*, finishing_year*, term_type, term_start_date, term_end_date)
     20  *референцира од school_year(student_id, starting_year, finishing_year)
     21- subject_at_term(student_id*, starting_year*, finishing_year*, term_type*, term_subject_id, subject_name)
     22  *референцира од term(student_id, starting_year, finishing_year, term_type)
     23- professor(professor_id, p_first_name, p_last_name, p_role, p_e-mail)
     24- dashboard(student_id*, dashboard_id, dashboard_date)
     25  *референцира од student(student_id)
     26- notes(student_id*, dashboard_id*, note_id, notes_Date, note_text)
     27  *референцира од dashboard(student_id, dashboard_id)
     28- place(place_id, building_name, room_name)
     29- chalendar_event(chalendar_event_id, event_name, event_type, event_description, event_start_time, event_end_time)
     30- task(task_id, task_name, task_description, task_priority, is_done)
     31- reminder(calendar_event_id*, r_id, minutes_before_event, r_flag)
     32  *референцира од calendar_event(calendar _event_id)
    3333repeating_event(calendar_event_id*, event_week_day, repeats_every_n_weeks, starting_date, ending_date)
    3434* референцира од calendar_event(calendar_event_id)