Changes between Version 17 and Version 18 of DBModel

Timestamp:

02/20/10 03:04:07 (15 years ago)

Author:

Vangel Ajanovski

Comment:

—

DBModel

@@ -18 +18 @@
 
  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 | #session_schedule_id\l session_id\l schedule_id\l }"]
-n1467 [ label="{ exam_event | #exam_event_id\l exam_id\l subject_event_id\l 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 session_id\l subject_id\l }"]
-n1512 [ label="{ session | #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 }"]
+n1008 [ label="{ institution | <u>#institution_id</u>\l parent_institution_id\l institution_type_id\l code\l title\l title_en\l note\l }"]
+n1019 [ label="{ institution_type | <u>#institution_type_id</u>\l code\l title\l title_en\l host_programs\l note\l }"]
+n1027 [ label="{ person | <u>#person_id</u>\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 | <u>#student_id</u>\l institution_id\l person_id\l status_2\l }"]
+n1057 [ label="{ instructor | <u>#instructor_id</u>\l person_id\l institution_id\l from_date\l to_date\l }"]
+n1064 [ label="{ facility | <u>#facility_id</u>\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 | <u>#facility_type_id</u>\l code\l title\l title_en\l host_event\l note\l }"]
+n1085 [ label="{ plan | <u>#plan_id</u>\l institution_id\l code\l title\l title_en\l start_term\l end_term\l note\l }"]
+n1097 [ label="{ program | <u>#program_id</u>\l plan_id\l code\l title\l title_en\l terms\l note\l }"]
+n1109 [ label="{ degree | <u>#degree_id</u>\l institution_id\l code\l title\l title_en\l terms\l note\l }"]
+n1119 [ label="{ subject | <u>#subject_id</u>\l institution_id\l code\l title\l title_en\l abstract\l note\l }"]
+n1129 [ label="{ program_degree | <u>#program_degree_id</u>\l program_id\l degree_id\l }"]
+n1136 [ label="{ curriculum | <u>#curriculum_id</u>\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 | <u>#curriculum_link_id</u>\l curriculum_id\l link_type_id\l }"]
+n1166 [ label="{ link_type | <u>#link_type_id</u>\l code\l title\l title_en\l note\l }"]
+n1173 [ label="{ module_type | <u>#module_type_id</u>\l code\l title\l title_en\l note\l }"]
+n1180 [ label="{ exam_type | <u>#exam_type_id</u>\l code\l title\l title_en\l writen\l oral\l practical\l note\l }"]
+n1190 [ label="{ curriculum_instruction | <u>#curriculum_instruction_id</u>\l instruction_type_id\l curriculum_id\l per_week\l hours\l }"]
+n1200 [ label="{ instruction_type | <u>#instruction_type_id</u>\l code\l title\l title_en\l note\l }"]
+n1207 [ label="{ program_enrollment | <u>#program_enrollment_id</u>\l program_id\l student_id\l }"]
+n1214 [ label="{ term | <u>#term_id</u>\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 | <u>#term_program_id</u>\l term_id\l program_id\l }"]
+n1227 [ label="{ term_subject | <u>#term_subject_id</u>\l subject_id\l term_id\l enroll_deadline\l cancel_deadline\l }"]
+n1234 [ label="{ course | <u>#course_id</u>\l url\l moodle\l }"]
+n1242 [ label="{ course_curriculum | <u>#course_curriculum_id</u>\l curriculum_link_id\l course_id\l term_program_id\l grade_allow\l }"]
+n1253 [ label="{ course_instructor | <u>#course_instructor_id</u>\l course_id\l instructor_id\l }"]
+n1262 [ label="{ term_enrollment | <u>#term_enrollment_id</u>\l term_program_id\l program_enrollment_id\l enrollment_status\l note\l }"]
+n1270 [ label="{ course_enrollment | <u>#course_enrollment_id</u>\l subject_enrollment_id\l course_curriculum_id\l grade\l }"]
+n1281 [ label="{ course_curriculum_instruction | <u>#coursecurr_instruction_id</u>\l curriculum_instruction_id\l course_curriculum_id\l course_instructor_id\l }"]
+n1294 [ label="{ assessment | <u>#assessment_id</u>\l assessment_type_id\l grade\l points\l credit\l description\l note\l }"]
+n1304 [ label="{ student_assessment | <u>#student_assessment_id</u>\l program_enrollment_id\l assessment_id\l }"]
+n1312 [ label="{ curriculum_assessment | <u>#curriculum_assessment_id</u>\l curriculum_link_id\l student_assessment_id\l }"]
+n1322 [ label="{ course_assessment | <u>#course_assessment_id</u>\l activity_assessment_id\l curriculum_assessment_id\l student_activity_id\l }"]
+n1336 [ label="{ student_activity | <u>#student_activity_id</u>\l course_activity_id\l course_enrollment_id\l }"]
+n1348 [ label="{ activity_type | <u>#activity_type_id</u>\l code\l title\l title_en\l note\l }"]
+n1355 [ label="{ schedule | <u>#schedule_id</u>\l institution_id\l }"]
+n1361 [ label="{ formation | <u>#formation_id</u>\l instruction_schedule_id\l }"]
+n1369 [ label="{ slot | <u>#slot_id</u>\l schedule_id\l facility_id\l }"]
+n1378 [ label="{ formation_student | <u>#formation_student_id</u>\l formation_id\l term_enrollment_id\l }"]
+n1388 [ label="{ event | <u>#event_id</u>\l schedule_id\l event_type_id\l }"]
+n1397 [ label="{ event_type | <u>#event_type_id</u>\l code\l title\l title_en\l note\l }"]
+n1404 [ label="{ event_formation | <u>#event_formation_id</u>\l event_id\l formation_id\l }"]
+n1413 [ label="{ event_slot | <u>#event_slod_id</u>\l event_id\l slot_id\l }"]
+n1422 [ label="{ subject_event | <u>#subject_event_id</u>\l subject_id\l event_id\l }"]
+n1430 [ label="{ instruction_schedule | <u>#instruction_schedule_id</u>\l schedule_id\l term_id\l }"]
+n1437 [ label="{ course_event | <u>#course_event_id</u>\l course_id\l instruction_event_id\l subject_event_id\l }"]
+n1448 [ label="{ instruction_event | <u>#instruction_event_id</u>\l event_id\l instruction_schedule_id\l instruction_type_id\l instructor_id\l }"]
+n1460 [ label="{ session_schedule | <u>#session_schedule_id</u>\l session_id\l schedule_id\l }"]
+n1467 [ label="{ exam_event | <u>#exam_event_id</u>\l exam_id\l subject_event_id\l session_schedule_id\l }"]
+n1478 [ label="{ activity | <u>#activity_id</u>\l activity_type_id\l }"]
+n1483 [ label="{ assessment_type | <u>#assessment_type_id</u>\l code\l title\l title_en\l grade\l points\l credit\l note\l }"]
+n1493 [ label="{ course_activity | <u>#course_activity_id</u>\l activity_id\l course_id\l }"]
+n1502 [ label="{ exam | <u>#exam_id</u>\l session_id\l subject_id\l }"]
+n1512 [ label="{ session | <u>#session_id</u>\l term_id\l }"]
+n1519 [ label="{ exam_application | <u>#exam_application_id</u>\l exam_id\l student_activity_id\l }"]
+n1532 [ label="{ activity_assessment | <u>#activity_assessment_id</u>\l assessment_id\l course_activity_id\l }"]
+n1542 [ label="{ country | <u>#country_id</u>\l code\l code_short\l title\l title_en\l }"]
+n1549 [ label="{ language | <u>#language_id</u>\l code\l title\l title_en\l }"]
+n1555 [ label="{ country_language | <u>#country_language_id</u>\l country_id\l language_id\l official\l }"]
+n1562 [ label="{ province | <u>#province_id</u>\l country_id\l code\l title\l title_en\l }"]
+n1570 [ label="{ payment_type | <u>#payment_type_id</u>\l title\l note\l }"]
+n1575 [ label="{ document_type | <u>#document_type_id</u>\l title\l title_en\l note\l }"]
+n1581 [ label="{ account | <u>#account_id</u>\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 | <u>#document_type_account_id</u>\l document_type_id\l account_id\l active\l valid_from\l valid_to\l }"]
+n1607 [ label="{ document | <u>#document_id</u>\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 | <u>#document_student_id</u>\l document_id\l student_id\l }"]
+n1629 [ label="{ ledger | <u>#ledger_id</u>\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 | <u>#attachment_id</u>\l document_id\l note\l attach_content\l }"]
+n1654 [ label="{ subject_enrollment | <u>#subject_enrollment_id</u>\l termsubject_currlink_id\l term_enrollment_id\l }"]
+n1663 [ label="{ document_program | <u>#document_program_id</u>\l program_enrollment_id\l document_student_id\l }"]
+n1671 [ label="{ document_term | <u>#document_term_id</u>\l term_enrollment_id\l document_program_id\l }"]
+n1680 [ label="{ document_course | <u>#document_course_id</u>\l document_term_id\l course_enrollment_id\l }"]
+n1692 [ label="{ ledger_link | <u>#ledger_link_id</u>\l ledger_id\l link_ledger_id\l amount\l points\l }"]
+n2042 [ label="{ term_subject_curriculum_link | <u>#termsubject_currlink_id</u>\l curriculum_link_id\l term_subject_id\l }"]
+n2085 [ label="{ staff | <u>#staff_id</u>\l person_id\l role_type_id\l institution_id\l from_date\l to_date\l }"]
+n2096 [ label="{ role_type | <u>#role_type_id</u>\l code\l title\l title_en\l abstract\l note\l }"]
+n2116 [ label="{ term_type | <u>#term_type_id</u>\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
@@ -222 +222 @@
 n2414 -> n1234
 n2414 -> n2042
-
 }
 }}}