= Појаснувања за моделот = Вака се опишуваат предметите во базата и зависностите меѓу нив: [[Image(model zavisnosti.png, 300px)]] Исто така видете и [wiki:Zavisnosti зависности]. Моментална листа [wiki:TekovniZavisnosti зависности]. = Верзии на моделот = '''Верзија 0.9.3 од базата на податоци''' 1. Додавање на атрибути во Term 1. Дополнување на коментарот на status во TermEnrollment {{{ #!graphviz digraph G { fontname = "Bitstream Vera Sans" fontsize = 8 node [ shape = "record" ] n1008 [ label="{ institution | #institution_id\l parent_institution_id\l institution_type_id\l code\l title\l title_en\l note\l }"] n1019 [ label="{ institution_type | #institution_type_id\l code\l title\l title_en\l host_programs\l note\l }"] n1027 [ label="{ person | #person_id\l embg\l first_name\l middle_name\l last_name\l gender\l birth_date\l birth_place\l birth_province\l birth_country\l nationality\l residence_address\l residence_place\l residence_province\l residence_country\l phone_home\l phone_mobile\l email\l picture\l public_key\l username\l }"] n1049 [ label="{ student | #student_id\l institution_id\l person_id\l status_2\l }"] n1057 [ label="{ instructor | #instructor_id\l person_id\l institution_id\l from_date\l to_date\l }"] n1064 [ label="{ facility | #facility_id\l parent_facility_id\l institution_id\l facility_type_id\l code\l title\l title_en\l note\l }"] n1077 [ label="{ facility_type | #facility_type_id\l code\l title\l title_en\l host_event\l note\l }"] n1085 [ label="{ plan | #plan_id\l institution_id\l code\l title\l title_en\l start_term\l end_term\l note\l }"] n1097 [ label="{ program | #program_id\l plan_id\l code\l title\l title_en\l terms\l note\l }"] n1109 [ label="{ degree | #degree_id\l institution_id\l code\l title\l title_en\l terms\l note\l }"] n1119 [ label="{ subject | #subject_id\l institution_id\l code\l title\l title_en\l abstract\l note\l }"] n1129 [ label="{ program_degree | #program_degree_id\l program_id\l degree_id\l }"] n1136 [ label="{ curriculum | #curriculum_id\l program_id\l subject_id\l term\l term_ordinal\l subject_title\l module_type_id\l exam_type_id\l lecture\l tutorial\l laboratory\l instruction\l individual\l credits\l }"] n1156 [ label="{ curriculum_link | #curriculum_link_id\l curriculum_id\l link_type_id\l }"] n1166 [ label="{ link_type | #link_type_id\l code\l title\l title_en\l note\l }"] n1173 [ label="{ module_type | #module_type_id\l code\l title\l title_en\l note\l }"] n1180 [ label="{ exam_type | #exam_type_id\l code\l title\l title_en\l writen\l oral\l practical\l note\l }"] n1190 [ label="{ curriculum_instruction | #curriculum_instruction_id\l instruction_type_id\l curriculum_id\l per_week\l hours\l }"] n1200 [ label="{ instruction_type | #instruction_type_id\l code\l title\l title_en\l note\l }"] n1207 [ label="{ program_enrollment | #program_enrollment_id\l program_id\l student_id\l }"] n1214 [ label="{ term | #term_id\l term_type_id\l institution_id\l term_year\l term_from\l term_to\l note\l belowminimum_credits\l minimum_credits\l maximum_credits\l }"] n1220 [ label="{ term_program | #term_program_id\l term_id\l program_id\l }"] n1227 [ label="{ term_subject | #term_subject_id\l subject_id\l term_id\l enroll_deadline\l cancel_deadline\l }"] n1234 [ label="{ course | #course_id\l url\l moodle\l }"] n1242 [ label="{ course_curriculum | #course_curriculum_id\l curriculum_link_id\l course_id\l term_program_id\l grade_allow\l }"] n1253 [ label="{ course_instructor | #course_instructor_id\l course_id\l instructor_id\l }"] n1262 [ label="{ term_enrollment | #term_enrollment_id\l term_program_id\l program_enrollment_id\l enrollment_status\l note\l }"] n1270 [ label="{ course_enrollment | #course_enrollment_id\l subject_enrollment_id\l course_curriculum_id\l grade\l }"] n1281 [ label="{ course_curriculum_instruction | #coursecurr_instruction_id\l curriculum_instruction_id\l course_curriculum_id\l course_instructor_id\l }"] n1294 [ label="{ assessment | #assessment_id\l assessment_type_id\l grade\l points\l credit\l description\l note\l }"] n1304 [ label="{ student_assessment | #student_assessment_id\l program_enrollment_id\l assessment_id\l }"] n1312 [ label="{ curriculum_assessment | #curriculum_assessment_id\l curriculum_link_id\l student_assessment_id\l }"] n1322 [ label="{ course_assessment | #course_assessment_id\l activity_assessment_id\l curriculum_assessment_id\l student_activity_id\l }"] n1336 [ label="{ student_activity | #student_activity_id\l course_activity_id\l course_enrollment_id\l }"] n1348 [ label="{ activity_type | #activity_type_id\l code\l title\l title_en\l note\l }"] n1355 [ label="{ schedule | #schedule_id\l institution_id\l }"] n1361 [ label="{ formation | #formation_id\l instruction_schedule_id\l }"] n1369 [ label="{ slot | #slot_id\l schedule_id\l facility_id\l }"] n1378 [ label="{ formation_student | #formation_student_id\l formation_id\l term_enrollment_id\l }"] n1388 [ label="{ event | #event_id\l schedule_id\l event_type_id\l }"] n1397 [ label="{ event_type | #event_type_id\l code\l title\l title_en\l note\l }"] n1404 [ label="{ event_formation | #event_formation_id\l event_id\l formation_id\l }"] n1413 [ label="{ event_slot | #event_slod_id\l event_id\l slot_id\l }"] n1422 [ label="{ subject_event | #subject_event_id\l subject_id\l event_id\l }"] n1430 [ label="{ instruction_schedule | #instruction_schedule_id\l schedule_id\l term_id\l }"] n1437 [ label="{ course_event | #course_event_id\l course_id\l instruction_event_id\l subject_event_id\l }"] n1448 [ label="{ instruction_event | #instruction_event_id\l event_id\l instruction_schedule_id\l instruction_type_id\l instructor_id\l }"] n1460 [ label="{ session_schedule | #exam_session_schedule_id\l exam_session_id\l schedule_id\l }"] n1467 [ label="{ exam_event | #exam_event_id\l exam_id\l subject_event_id\l exam_session_schedule_id\l }"] n1478 [ label="{ activity | #activity_id\l activity_type_id\l }"] n1483 [ label="{ assessment_type | #assessment_type_id\l code\l title\l title_en\l grade\l points\l credit\l note\l }"] n1493 [ label="{ course_activity | #course_activity_id\l activity_id\l course_id\l }"] n1502 [ label="{ exam | #exam_id\l activity_id\l exam_session_id\l subject_id\l }"] n1512 [ label="{ exam_session | #exam_session_id\l term_id\l }"] n1519 [ label="{ exam_application | #exam_application_id\l exam_id\l student_activity_id\l }"] n1532 [ label="{ activity_assessment | #activity_assessment_id\l assessment_id\l course_activity_id\l }"] n1542 [ label="{ country | #country_id\l code\l code_short\l title\l title_en\l }"] n1549 [ label="{ language | #language_id\l code\l title\l title_en\l }"] n1555 [ label="{ country_language | #country_language_id\l country_id\l language_id\l official\l }"] n1562 [ label="{ province | #province_id\l country_id\l code\l title\l title_en\l }"] n1570 [ label="{ payment_type | #payment_type_id\l title\l note\l }"] n1575 [ label="{ document_type | #document_type_id\l title\l title_en\l note\l }"] n1581 [ label="{ account | #account_id\l institution_id\l payment_type_id\l pay_institution_id\l code\l title\l active\l valid_from\l valid_to\l note\l }"] n1597 [ label="{ document_type_account | #document_type_account_id\l document_type_id\l account_id\l active\l valid_from\l valid_to\l }"] n1607 [ label="{ document | #document_id\l institution_id\l document_type_id\l author_person_id\l created\l archive_number\l doc_content\l note\l hash\l signature\l }"] n1622 [ label="{ document_student | #document_student_id\l document_id\l student_id\l }"] n1629 [ label="{ ledger | #ledger_id\l document_student_id\l account_id\l state\l created\l effective\l debit_amount\l credit_amount\l debit_point\l credit_point\l }"] n1645 [ label="{ attachment | #attachment_id\l document_id\l note\l attach_content\l }"] n1654 [ label="{ subject_enrollment | #subject_enrollment_id\l termsubject_currlink_id\l term_enrollment_id\l }"] n1663 [ label="{ document_program | #document_program_id\l program_enrollment_id\l document_student_id\l }"] n1671 [ label="{ document_term | #document_term_id\l term_enrollment_id\l document_program_id\l }"] n1680 [ label="{ document_course | #document_course_id\l document_term_id\l course_enrollment_id\l }"] n1692 [ label="{ ledger_link | #ledger_link_id\l ledger_id\l link_ledger_id\l amount\l points\l }"] n2042 [ label="{ term_subject_curriculum_link | #termsubject_currlink_id\l curriculum_link_id\l term_subject_id\l }"] n2085 [ label="{ staff | #staff_id\l person_id\l role_type_id\l institution_id\l from_date\l to_date\l }"] n2096 [ label="{ role_type | #role_type_id\l code\l title\l title_en\l abstract\l note\l }"] n2116 [ label="{ term_type | #term_type_id\l code\l title\l title_en\l abstract\l note\l }"] n2414 [ label="{ course_term_subject_curriculum_link | termsubject_currlink_id\l course_id\l }"] n1008 -> n1008 n1008 -> n1019 n1049 -> n1008 n1049 -> n1027 n1057 -> n1027 n1064 -> n1008 n1064 -> n1064 n1064 -> n1077 n1085 -> n1008 n1097 -> n1085 n1109 -> n1008 n1119 -> n1008 n1129 -> n1109 n1129 -> n1097 n1136 -> n1097 n1136 -> n1119 n1156 -> n1136 n1156 -> n1136 n1057 -> n1008 n1156 -> n1166 n1136 -> n1173 n1136 -> n1180 n1190 -> n1136 n1190 -> n1200 n1207 -> n1049 n1207 -> n1097 n1214 -> n1008 n1220 -> n1214 n1220 -> n1097 n1227 -> n1214 n1227 -> n1119 n1242 -> n1234 n1242 -> n1220 n1242 -> n1156 n1253 -> n1234 n1253 -> n1057 n1262 -> n1207 n1262 -> n1220 n1270 -> n1242 n1281 -> n1242 n1281 -> n1190 n1281 -> n1253 n1304 -> n1294 n1304 -> n1207 n1369 -> n1064 n1378 -> n1262 n1388 -> n1397 n1422 -> n1119 n1355 -> n1008 n1430 -> n1214 n1361 -> n1430 n1437 -> n1422 n1437 -> n1234 n1448 -> n1388 n1437 -> n1448 n1460 -> n1355 n1448 -> n1200 n1448 -> n1057 n1467 -> n1422 n1478 -> n1348 n1294 -> n1483 n1336 -> n1493 n1502 -> n1119 n1512 -> n1214 n1502 -> n1512 n1502 -> n1478 n1532 -> n1294 n1312 -> n1156 n1532 -> n1493 n1493 -> n1478 n1493 -> n1234 n1369 -> n1355 n1448 -> n1430 n1430 -> n1355 n1388 -> n1355 n1413 -> n1388 n1413 -> n1369 n1422 -> n1388 n1404 -> n1388 n1404 -> n1361 n1378 -> n1361 n1312 -> n1304 n1322 -> n1312 n1519 -> n1336 n1336 -> n1270 n1322 -> n1532 n1322 -> n1336 n1460 -> n1512 n1467 -> n1460 n1519 -> n1502 n1467 -> n1502 n1555 -> n1542 n1555 -> n1549 n1562 -> n1542 n1581 -> n1008 n1581 -> n1570 n1581 -> n1008 n1597 -> n1575 n1597 -> n1581 n1607 -> n1008 n1622 -> n1049 n1607 -> n1575 n1622 -> n1607 n1629 -> n1622 n1629 -> n1581 n1607 -> n1027 n1645 -> n1607 n1654 -> n1262 n1270 -> n1654 n1663 -> n1622 n1663 -> n1207 n1671 -> n1663 n1671 -> n1262 n1680 -> n1671 n1680 -> n1270 n1692 -> n1629 n1692 -> n1629 n2042 -> n1227 n2042 -> n1156 n1654 -> n2042 n2085 -> n1008 n2085 -> n2096 n2085 -> n1027 n1214 -> n2116 n2414 -> n1234 n2414 -> n2042 } }}} '''Верзија 0.9.2 од базата на податоци''' Промени од претходната верзија 0.9.1 на базата на податоци: 1. Додаден е атрибут int grade (оцена) во табелата course_enrollment 1. Додадена е нова табела course_term_subject_curriculum_link што е m:m врска со term_subject_curriculum_link и course. 1. Раскината е врската term_subject_curriculum_link->course Сега course e силен ентитет. '''Верзија 0.9.1 од базата на податоци''' Промени од претходната верзија 0.9 на базата на податоци: 1. Додадена табела (релација) term_subject_curriculum_link за да се има евиденција[[BR]] за конкретната реализација на предметот во curriculum_link за која аплицирал студентот 1. Врската меѓу course и term_subject е избришана и заменета со врска меѓу term_subject_curriculum_link и course 1. Додадена е табела term_type за да се знае типот на семестар, со соодветни атрибути code:Note , title:Title, title_en:Title, abstract:Note и note:Note 1. Додадена е табела staff за m:m поврзување на person и institution, со атрибути from_date:Date и to_date:Date 1. Додадена е табела role_type 1:m со staff, за да се знае типот на role во табелата staff, со соодветни атрибути code:Note , title:Title, title_en:Title, abstract:Note и note:Note 1. Додаден е атрибут grade_allow:INT во табелата course_curriculum, во врска со дозвола за внес на оцени (има детален опис во моделот) 1. Додадени атрибути enrollment_status:INT и note:Note во term_enrollment 1. Додаден атрибут student_status:INT во табелата student 1. Додадени атрибути from_date и to_date во табелата instructor 1. Додадени атрибути url:VARCHAR и moodle:BOOL во табелата course 1. Додадени атрибути term_year:VARCHAR, term_from:Date, term_to:Date и note:Note во табелата term 1. Додадени атрибути enroll_deadline:Date и cancel_deadline:Date во табелата term_subject '''Верзија 0.9 од базата на податоци''' Се очекува да има релативно мали промени на овој модел додека да стане финална. Во оваа верзија е потребно преуредување на изгледот на базата. Во однос на почетниот модел изработен од Огнен Ивановски и Костадин Бајалцалиев во оваа верзија се направени промени така што во секоја табела има едноставен клуч базиран на Аuto Increment. Главна причина за оваа промена е полесно работење во различни рамки за развој на апликации и поедноставување на изгледот на моделот и управувањето со асоцијациите меѓу ентитетите.