Changes between Version 33 and Version 34 of DBModel

Timestamp:

02/20/10 03:44:10 (15 years ago)

Author:

Vangel Ajanovski

Comment:

—

DBModel

@@ -18 +18 @@
 
 node [ shape = "record" ]
-n1008 [ label="{ institution| #institution_id\lparent_institution_id\linstitution_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
-n1019 [ label="{ institution_type| #institution_type_id\lcode\ltitle\ltitle_en\lhost_programs\lnote\l }"]
-n1027 [ label="{ person| #person_id\lembg\lfirst_name\lmiddle_name\llast_name\lgender\lbirth_date\lbirth_place\lbirth_province\lbirth_country\lnationality\lresidence_address\lresidence_place\lresidence_province\lresidence_country\lphone_home\lphone_mobile\lemail\lpicture\lpublic_key\lusername\l }"]
-n1049 [ label="{ student| #student_id\linstitution_id\lperson_id\lstatus_2\l }"]
-n1057 [ label="{ instructor| #instructor_id\lperson_id\linstitution_id\lfrom_date\lto_date\l }"]
-n1064 [ label="{ facility| #facility_id\lparent_facility_id\linstitution_id\lfacility_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
-n1077 [ label="{ facility_type| #facility_type_id\lcode\ltitle\ltitle_en\lhost_event\lnote\l }"]
-n1085 [ label="{ plan| #plan_id\linstitution_id\lcode\ltitle\ltitle_en\lstart_term\lend_term\lnote\l }"]
-n1097 [ label="{ program| #program_id\lplan_id\lcode\ltitle\ltitle_en\lterms\lnote\l }"]
-n1109 [ label="{ degree| #degree_id\linstitution_id\lcode\ltitle\ltitle_en\lterms\lnote\l }"]
-n1119 [ label="{ subject| #subject_id\linstitution_id\lcode\ltitle\ltitle_en\labstract\lnote\l }"]
-n1129 [ label="{ program_degree| #program_degree_id\lprogram_id\ldegree_id\l }"]
-n1136 [ label="{ curriculum| #curriculum_id\lprogram_id\lsubject_id\lterm\lterm_ordinal\lsubject_title\lmodule_type_id\lexam_type_id\llecture\ltutorial\llaboratory\linstruction\lindividual\lcredits\l }"]
-n1156 [ label="{ curriculum_link| #curriculum_link_id\lcurriculum_id\llink_type_id\l }"]
-n1166 [ label="{ link_type| #link_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
-n1173 [ label="{ module_type| #module_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
-n1180 [ label="{ exam_type| #exam_type_id\lcode\ltitle\ltitle_en\lwriten\loral\lpractical\lnote\l }"]
-n1190 [ label="{ curriculum_instruction| #curriculum_instruction_id\linstruction_type_id\lcurriculum_id\lper_week\lhours\l }"]
-n1200 [ label="{ instruction_type| #instruction_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
-n1207 [ label="{ program_enrollment| #program_enrollment_id\lprogram_id\lstudent_id\l }"]
-n1214 [ label="{ term| #term_id\lterm_type_id\linstitution_id\lterm_year\lterm_from\lterm_to\lnote\lbelowminimum_credits\lminimum_credits\lmaximum_credits\l }"]
-n1220 [ label="{ term_program| #term_program_id\lterm_id\lprogram_id\l }"]
-n1227 [ label="{ term_subject| #term_subject_id\lsubject_id\lterm_id\lenroll_deadline\lcancel_deadline\l }"]
-n1234 [ label="{ course| #course_id\lurl\lmoodle\l }"]
-n1242 [ label="{ course_curriculum| #course_curriculum_id\lcurriculum_link_id\lcourse_id\lterm_program_id\lgrade_allow\l }"]
-n1253 [ label="{ course_instructor| #course_instructor_id\lcourse_id\linstructor_id\l }"]
-n1262 [ label="{ term_enrollment| #term_enrollment_id\lterm_program_id\lprogram_enrollment_id\lenrollment_status\lnote\l }"]
-n1270 [ label="{ course_enrollment| #course_enrollment_id\lsubject_enrollment_id\lcourse_curriculum_id\lgrade\l }"]
-n1281 [ label="{ course_curriculum_instruction| #coursecurr_instruction_id\lcurriculum_instruction_id\lcourse_curriculum_id\lcourse_instructor_id\l }"]
-n1294 [ label="{ assessment| #assessment_id\lassessment_type_id\lgrade\lpoints\lcredit\ldescription\lnote\l }"]
-n1304 [ label="{ student_assessment| #student_assessment_id\lprogram_enrollment_id\lassessment_id\l }"]
-n1312 [ label="{ curriculum_assessment| #curriculum_assessment_id\lcurriculum_link_id\lstudent_assessment_id\l }"]
-n1322 [ label="{ course_assessment| #course_assessment_id\lactivity_assessment_id\lcurriculum_assessment_id\lstudent_activity_id\l }"]
-n1336 [ label="{ student_activity| #student_activity_id\lcourse_activity_id\lcourse_enrollment_id\l }"]
-n1348 [ label="{ activity_type| #activity_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
-n1355 [ label="{ schedule| #schedule_id\linstitution_id\l }"]
-n1361 [ label="{ formation| #formation_id\linstruction_schedule_id\l }"]
-n1369 [ label="{ slot| #slot_id\lschedule_id\lfacility_id\l }"]
-n1378 [ label="{ formation_student| #formation_student_id\lformation_id\lterm_enrollment_id\l }"]
-n1388 [ label="{ event| #event_id\lschedule_id\levent_type_id\l }"]
-n1397 [ label="{ event_type| #event_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
-n1404 [ label="{ event_formation| #event_formation_id\levent_id\lformation_id\l }"]
-n1413 [ label="{ event_slot| #event_slod_id\levent_id\lslot_id\l }"]
-n1422 [ label="{ subject_event| #subject_event_id\lsubject_id\levent_id\l }"]
-n1430 [ label="{ instruction_schedule| #instruction_schedule_id\lschedule_id\lterm_id\l }"]
-n1437 [ label="{ course_event| #course_event_id\lcourse_id\linstruction_event_id\lsubject_event_id\l }"]
-n1448 [ label="{ instruction_event| #instruction_event_id\levent_id\linstruction_schedule_id\linstruction_type_id\linstructor_id\l }"]
-n1460 [ label="{ session_schedule| #exam_session_schedule_id\lexam_session_id\lschedule_id\l }"]
-n1467 [ label="{ exam_event| #exam_event_id\lexam_id\lsubject_event_id\lexam_session_schedule_id\l }"]
-n1478 [ label="{ activity| #activity_id\lactivity_type_id\l }"]
-n1483 [ label="{ assessment_type| #assessment_type_id\lcode\ltitle\ltitle_en\lgrade\lpoints\lcredit\lnote\l }"]
-n1493 [ label="{ course_activity| #course_activity_id\lactivity_id\lcourse_id\l }"]
-n1502 [ label="{ exam| #exam_id\lactivity_id\lexam_session_id\lsubject_id\l }"]
-n1512 [ label="{ exam_session| #exam_session_id\lterm_id\l }"]
-n1519 [ label="{ exam_application| #exam_application_id\lexam_id\lstudent_activity_id\l }"]
-n1532 [ label="{ activity_assessment| #activity_assessment_id\lassessment_id\lcourse_activity_id\l }"]
-n1542 [ label="{ country| #country_id\lcode\lcode_short\ltitle\ltitle_en\l }"]
-n1549 [ label="{ language| #language_id\lcode\ltitle\ltitle_en\l }"]
-n1555 [ label="{ country_language| #country_language_id\lcountry_id\llanguage_id\lofficial\l }"]
-n1562 [ label="{ province| #province_id\lcountry_id\lcode\ltitle\ltitle_en\l }"]
-n1570 [ label="{ payment_type| #payment_type_id\ltitle\lnote\l }"]
-n1575 [ label="{ document_type| #document_type_id\ltitle\ltitle_en\lnote\l }"]
-n1581 [ label="{ account| #account_id\linstitution_id\lpayment_type_id\lpay_institution_id\lcode\ltitle\lactive\lvalid_from\lvalid_to\lnote\l }"]
-n1597 [ label="{ document_type_account| #document_type_account_id\ldocument_type_id\laccount_id\lactive\lvalid_from\lvalid_to\l }"]
-n1607 [ label="{ document| #document_id\linstitution_id\ldocument_type_id\lauthor_person_id\lcreated\larchive_number\ldoc_content\lnote\lhash\lsignature\l }"]
-n1622 [ label="{ document_student| #document_student_id\ldocument_id\lstudent_id\l }"]
-n1629 [ label="{ ledger| #ledger_id\ldocument_student_id\laccount_id\lstate\lcreated\leffective\ldebit_amount\lcredit_amount\ldebit_point\lcredit_point\l }"]
-n1645 [ label="{ attachment| #attachment_id\ldocument_id\lnote\lattach_content\l }"]
-n1654 [ label="{ subject_enrollment| #subject_enrollment_id\ltermsubject_currlink_id\lterm_enrollment_id\l }"]
-n1663 [ label="{ document_program| #document_program_id\lprogram_enrollment_id\ldocument_student_id\l }"]
-n1671 [ label="{ document_term| #document_term_id\lterm_enrollment_id\ldocument_program_id\l }"]
-n1680 [ label="{ document_course| #document_course_id\ldocument_term_id\lcourse_enrollment_id\l }"]
-n1692 [ label="{ ledger_link| #ledger_link_id\lledger_id\llink_ledger_id\lamount\lpoints\l }"]
-n2042 [ label="{ term_subject_curriculum_link| #termsubject_currlink_id\lcurriculum_link_id\lterm_subject_id\l }"]
-n2085 [ label="{ staff| #staff_id\lperson_id\lrole_type_id\linstitution_id\lfrom_date\lto_date\l }"]
-n2096 [ label="{ role_type| #role_type_id\lcode\ltitle\ltitle_en\labstract\lnote\l }"]
-n2116 [ label="{ term_type| #term_type_id\lcode\ltitle\ltitle_en\labstract\lnote\l }"]
-n2414 [ label="{ course_term_subject_curriculum_link| termsubject_currlink_id\lcourse_id\l }"]
+n1008 [ label="{ institution| #institution_id\l }"]
+n1019 [ label="{ institution_type| #institution_type_id\l }"]
+n1027 [ label="{ person| #person_id\l }"]
+n1049 [ label="{ student| #student_id\l }"]
+n1057 [ label="{ instructor| #instructor_id\l }"]
+n1064 [ label="{ facility| #facility_id\l }"]
+n1077 [ label="{ facility_type| #facility_type_id\l }"]
+n1085 [ label="{ plan| #plan_id\l }"]
+n1097 [ label="{ program| #program_id\l }"]
+n1109 [ label="{ degree| #degree_id\l }"]
+n1119 [ label="{ subject| #subject_id\l }"]
+n1129 [ label="{ program_degree| #program_degree_id\l }"]
+n1136 [ label="{ curriculum| #curriculum_id\l }"]
+n1156 [ label="{ curriculum_link| #curriculum_link_id\l }"]
+n1166 [ label="{ link_type| #link_type_id\l }"]
+n1173 [ label="{ module_type| #module_type_id\l }"]
+n1180 [ label="{ exam_type| #exam_type_id\l }"]
+n1190 [ label="{ curriculum_instruction| #curriculum_instruction_id\l }"]
+n1200 [ label="{ instruction_type| #instruction_type_id\l }"]
+n1207 [ label="{ program_enrollment| #program_enrollment_id\l }"]
+n1214 [ label="{ term| #term_id\l }"]
+n1220 [ label="{ term_program| #term_program_id\l }"]
+n1227 [ label="{ term_subject| #term_subject_id\l }"]
+n1234 [ label="{ course| #course_id\l }"]
+n1242 [ label="{ course_curriculum| #course_curriculum_id\l }"]
+n1253 [ label="{ course_instructor| #course_instructor_id\l }"]
+n1262 [ label="{ term_enrollment| #term_enrollment_id\l }"]
+n1270 [ label="{ course_enrollment| #course_enrollment_id\l }"]
+n1281 [ label="{ course_curriculum_instruction| #coursecurr_instruction_id\l }"]
+n1294 [ label="{ assessment| #assessment_id\l }"]
+n1304 [ label="{ student_assessment| #student_assessment_id\l }"]
+n1312 [ label="{ curriculum_assessment| #curriculum_assessment_id\l }"]
+n1322 [ label="{ course_assessment| #course_assessment_id\l }"]
+n1336 [ label="{ student_activity| #student_activity_id\l }"]
+n1348 [ label="{ activity_type| #activity_type_id\l }"]
+n1355 [ label="{ schedule| #schedule_id\l }"]
+n1361 [ label="{ formation| #formation_id\l }"]
+n1369 [ label="{ slot| #slot_id\l }"]
+n1378 [ label="{ formation_student| #formation_student_id\l }"]
+n1388 [ label="{ event| #event_id\l }"]
+n1397 [ label="{ event_type| #event_type_id\l }"]
+n1404 [ label="{ event_formation| #event_formation_id\l }"]
+n1413 [ label="{ event_slot| #event_slod_id\l }"]
+n1422 [ label="{ subject_event| #subject_event_id\l }"]
+n1430 [ label="{ instruction_schedule| #instruction_schedule_id\l }"]
+n1437 [ label="{ course_event| #course_event_id\l }"]
+n1448 [ label="{ instruction_event| #instruction_event_id\l }"]
+n1460 [ label="{ session_schedule| #exam_session_schedule_id\l }"]
+n1467 [ label="{ exam_event| #exam_event_id\l }"]
+n1478 [ label="{ activity| #activity_id\l }"]
+n1483 [ label="{ assessment_type| #assessment_type_id\l }"]
+n1493 [ label="{ course_activity| #course_activity_id\l }"]
+n1502 [ label="{ exam| #exam_id\l }"]
+n1512 [ label="{ exam_session| #exam_session_id\l }"]
+n1519 [ label="{ exam_application| #exam_application_id\l }"]
+n1532 [ label="{ activity_assessment| #activity_assessment_id\l }"]
+n1542 [ label="{ country| #country_id\l }"]
+n1549 [ label="{ language| #language_id\l }"]
+n1555 [ label="{ country_language| #country_language_id\l }"]
+n1562 [ label="{ province| #province_id\l }"]
+n1570 [ label="{ payment_type| #payment_type_id\l }"]
+n1575 [ label="{ document_type| #document_type_id\l }"]
+n1581 [ label="{ account| #account_id\l }"]
+n1597 [ label="{ document_type_account| #document_type_account_id\l }"]
+n1607 [ label="{ document| #document_id\l }"]
+n1622 [ label="{ document_student| #document_student_id\l }"]
+n1629 [ label="{ ledger| #ledger_id\l }"]
+n1645 [ label="{ attachment| #attachment_id\l }"]
+n1654 [ label="{ subject_enrollment| #subject_enrollment_id\l }"]
+n1663 [ label="{ document_program| #document_program_id\l }"]
+n1671 [ label="{ document_term| #document_term_id\l }"]
+n1680 [ label="{ document_course| #document_course_id\l }"]
+n1692 [ label="{ ledger_link| #ledger_link_id\l }"]
+n2042 [ label="{ term_subject_curriculum_link| #termsubject_currlink_id\l }"]
+n2085 [ label="{ staff| #staff_id\l }"]
+n2096 [ label="{ role_type| #role_type_id\l }"]
+n2116 [ label="{ term_type| #term_type_id\l }"]
+n2414 [ label="{ course_term_subject_curriculum_link| }"]
 n1008 -> n1008
 n1008 -> n1019
@@ -223 +223 @@
 n2414 -> n2042
 
-
 }
 }}}