= Појаснувања за моделот = Вака се опишуваат предметите во базата и зависностите меѓу нив: [[Image(model zavisnosti.png, 300px)]] Исто така видете и [wiki:Zavisnosti зависности]. Моментална листа [wiki:TekovniZavisnosti зависности]. = Верзии на моделот = '''Верзија 0.9.3 од базата на податоци''' 1. Додавање на атрибути во Term 1. Дополнување на коментарот на status во TermEnrollment {{{ #!graphviz.fdp digraph G { overlap="false" splines="true" fontsize="9.0" node [ shape = "record" ] dsubgraph clusterEnrollment { n1207; n1270; n1262; n1654; bgcolor="gray90"; } dsubgraph clusterMain { n1008 n1019 n1027 n1049 n1057 n1064 n1077 n2085 n2096 bgcolor="gray90"; } dsubgraph clusterCurriculum { n1085 n1097 n1109 n1119 n1129 n1166 n1136 n1156 n1173 n1180 bgcolor="gray90";} dsubgraph clusterDocuments { n1575 n1570 n1663 n1671 n1680 n1692 n1607 n1622 n1629 n1645 n1581 n1597 bgcolor="gray90";} dsubgraph clusterAssessment { n1502 n1512 n1519 n1532 n1483 n1478 n1493 n1294 n1304 n1312 n1322 n1336 n1348 bgcolor="gray90";} dsubgraph clusterTerm { n1190 n1214 n1220 n1227 n1234 n1242 n1253 n1281 n2042 n2414 bgcolor="gray90";} n1008 [ label="{ institution| ♦institution_id\l  code\l  title\l  title_en\l  note\l* parent_institution_id\l* institution_type_id\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  status_2\l* institution_id\l* person_id\l }"] n1057 [ label="{ instructor| ♦instructor_id\l  from_date\l  to_date\l* person_id\l* institution_id\l }"] n1064 [ label="{ facility| ♦facility_id\l  code\l  title\l  title_en\l  note\l* parent_facility_id\l* institution_id\l* facility_type_id\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  code\l  title\l  title_en\l  start_term\l  end_term\l  note\l* institution_id\l }"] n1097 [ label="{ program| ♦program_id\l  code\l  title\l  title_en\l  terms\l  note\l* plan_id\l }"] n1109 [ label="{ degree| ♦degree_id\l  code\l  title\l  title_en\l  terms\l  note\l* institution_id\l }"] n1119 [ label="{ subject| ♦subject_id\l  code\l  title\l  title_en\l  abstract\l  note\l* institution_id\l }"] n1129 [ label="{ program_degree| ♦program_degree_id\l* program_id\l* degree_id\l }"] n1136 [ label="{ curriculum| ♦curriculum_id\l  term\l  term_ordinal\l  subject_title\l  lecture\l  tutorial\l  laboratory\l  instruction\l  individual\l  credits\l* program_id\l* subject_id\l* module_type_id\l* exam_type_id\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  per_week\l  hours\l* instruction_type_id\l* curriculum_id\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_year\l  term_from\l  term_to\l  note\l  belowminimum_credits\l  minimum_credits\l  maximum_credits\l* term_type_id\l* institution_id\l }"] n1220 [ label="{ term_program| ♦term_program_id\l* term_id\l* program_id\l }"] n1227 [ label="{ term_subject| ♦term_subject_id\l  enroll_deadline\l  cancel_deadline\l* subject_id\l* term_id\l }"] n1234 [ label="{ course| ♦course_id\l  url\l  moodle\l }"] n1242 [ label="{ course_curriculum| ♦course_curriculum_id\l  grade_allow\l* curriculum_link_id\l* course_id\l* term_program_id\l }"] n1253 [ label="{ course_instructor| ♦course_instructor_id\l* course_id\l* instructor_id\l }"] n1262 [ label="{ term_enrollment| ♦term_enrollment_id\l  enrollment_status\l  note\l* term_program_id\l* program_enrollment_id\l }"] n1270 [ label="{ course_enrollment| ♦course_enrollment_id\l  grade\l* subject_enrollment_id\l* course_curriculum_id\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  grade\l  points\l  credit\l  description\l  note\l* assessment_type_id\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  official\l* country_id\l* language_id\l }"] n1562 [ label="{ province| ♦province_id\l  code\l  title\l  title_en\l* country_id\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  code\l  title\l  active\l  valid_from\l  valid_to\l  note\l* institution_id\l* payment_type_id\l* pay_institution_id\l }"] n1597 [ label="{ document_type_account| ♦document_type_account_id\l  active\l  valid_from\l  valid_to\l* document_type_id\l* account_id\l }"] n1607 [ label="{ document| ♦document_id\l  created\l  archive_number\l  doc_content\l  note\l  hash\l  signature\l* institution_id\l* document_type_id\l* author_person_id\l }"] n1622 [ label="{ document_student| ♦document_student_id\l* document_id\l* student_id\l }"] n1629 [ label="{ ledger| ♦ledger_id\l  state\l  created\l  effective\l  debit_amount\l  credit_amount\l  debit_point\l  credit_point\l* document_student_id\l* account_id\l }"] n1645 [ label="{ attachment| ♦attachment_id\l  note\l  attach_content\l* document_id\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  amount\l  points\l* ledger_id\l* link_ledger_id\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  from_date\l  to_date\l* person_id\l* role_type_id\l* institution_id\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 [ len=0.2] 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. Главна причина за оваа промена е полесно работење во различни рамки за развој на апликации и поедноставување на изгледот на моделот и управувањето со асоцијациите меѓу ентитетите.