Changes between Version 35 and Version 36 of DBModel


Ignore:
Timestamp:
02/20/10 04:19:50 (15 years ago)
Author:
Vangel Ajanovski
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • DBModel

    v35 v36  
    2121subgraph clusterCurriculum { n1085; n1097; n1109; n1119; n1129; n1166; n1136; n1156; n1173; n1180; bgcolor="gray90";}
    2222
    23 n1008 [ label="{ institution| #institution_id\lcode\ltitle\ltitle_en\lnote\l*parent_institution_id\l*institution_type_id\l }"]
    24 n1019 [ label="{ institution_type| #institution_type_id\lcode\ltitle\ltitle_en\lhost_programs\lnote\l }"]
    25 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 }"]
    26 n1049 [ label="{ student| #student_id\lstatus_2\l*institution_id\l*person_id\l }"]
    27 n1057 [ label="{ instructor| #instructor_id\lfrom_date\lto_date\l*person_id\l*institution_id\l }"]
    28 n1064 [ label="{ facility| #facility_id\lcode\ltitle\ltitle_en\lnote\l*parent_facility_id\l*institution_id\l*facility_type_id\l }"]
    29 n1077 [ label="{ facility_type| #facility_type_id\lcode\ltitle\ltitle_en\lhost_event\lnote\l }"]
    30 n1085 [ label="{ plan| #plan_id\lcode\ltitle\ltitle_en\lstart_term\lend_term\lnote\l*institution_id\l }"]
    31 n1097 [ label="{ program| #program_id\lcode\ltitle\ltitle_en\lterms\lnote\l*plan_id\l }"]
    32 n1109 [ label="{ degree| #degree_id\lcode\ltitle\ltitle_en\lterms\lnote\l*institution_id\l }"]
    33 n1119 [ label="{ subject| #subject_id\lcode\ltitle\ltitle_en\labstract\lnote\l*institution_id\l }"]
    34 n1129 [ label="{ program_degree| #program_degree_id\l*program_id\l*degree_id\l }"]
    35 n1136 [ label="{ curriculum| #curriculum_id\lterm\lterm_ordinal\lsubject_title\llecture\ltutorial\llaboratory\linstruction\lindividual\lcredits\l*program_id\l*subject_id\l*module_type_id\l*exam_type_id\l }"]
    36 n1156 [ label="{ curriculum_link| #curriculum_link_id\l*curriculum_id\l*link_type_id\l }"]
    37 n1166 [ label="{ link_type| #link_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
    38 n1173 [ label="{ module_type| #module_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
    39 n1180 [ label="{ exam_type| #exam_type_id\lcode\ltitle\ltitle_en\lwriten\loral\lpractical\lnote\l }"]
    40 n1190 [ label="{ curriculum_instruction| #curriculum_instruction_id\lper_week\lhours\l*instruction_type_id\l*curriculum_id\l }"]
    41 n1200 [ label="{ instruction_type| #instruction_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
    42 n1207 [ label="{ program_enrollment| #program_enrollment_id\l*program_id\l*student_id\l }"]
    43 n1214 [ label="{ term| #term_id\lterm_year\lterm_from\lterm_to\lnote\lbelowminimum_credits\lminimum_credits\lmaximum_credits\l*term_type_id\l*institution_id\l }"]
    44 n1220 [ label="{ term_program| #term_program_id\l*term_id\l*program_id\l }"]
    45 n1227 [ label="{ term_subject| #term_subject_id\lenroll_deadline\lcancel_deadline\l*subject_id\l*term_id\l }"]
    46 n1234 [ label="{ course| #course_id\lurl\lmoodle\l }"]
    47 n1242 [ label="{ course_curriculum| #course_curriculum_id\lgrade_allow\l*curriculum_link_id\l*course_id\l*term_program_id\l }"]
    48 n1253 [ label="{ course_instructor| #course_instructor_id\l*course_id\l*instructor_id\l }"]
    49 n1262 [ label="{ term_enrollment| #term_enrollment_id\lenrollment_status\lnote\l*term_program_id\l*program_enrollment_id\l }"]
    50 n1270 [ label="{ course_enrollment| #course_enrollment_id\lgrade\l*subject_enrollment_id\l*course_curriculum_id\l }"]
    51 n1281 [ label="{ course_curriculum_instruction| #coursecurr_instruction_id\l*curriculum_instruction_id\l*course_curriculum_id\l*course_instructor_id\l }"]
    52 n1294 [ label="{ assessment| #assessment_id\lgrade\lpoints\lcredit\ldescription\lnote\l*assessment_type_id\l }"]
    53 n1304 [ label="{ student_assessment| #student_assessment_id\l*program_enrollment_id\l*assessment_id\l }"]
    54 n1312 [ label="{ curriculum_assessment| #curriculum_assessment_id\l*curriculum_link_id\l*student_assessment_id\l }"]
    55 n1322 [ label="{ course_assessment| #course_assessment_id\l*activity_assessment_id\l*curriculum_assessment_id\l*student_activity_id\l }"]
    56 n1336 [ label="{ student_activity| #student_activity_id\l*course_activity_id\l*course_enrollment_id\l }"]
    57 n1348 [ label="{ activity_type| #activity_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
    58 n1355 [ label="{ schedule| #schedule_id\l*institution_id\l }"]
    59 n1361 [ label="{ formation| #formation_id\l*instruction_schedule_id\l }"]
    60 n1369 [ label="{ slot| #slot_id\l*schedule_id\l*facility_id\l }"]
    61 n1378 [ label="{ formation_student| #formation_student_id\l*formation_id\l*term_enrollment_id\l }"]
    62 n1388 [ label="{ event| #event_id\l*schedule_id\l*event_type_id\l }"]
    63 n1397 [ label="{ event_type| #event_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
    64 n1404 [ label="{ event_formation| #event_formation_id\l*event_id\l*formation_id\l }"]
    65 n1413 [ label="{ event_slot| #event_slod_id\l*event_id\l*slot_id\l }"]
    66 n1422 [ label="{ subject_event| #subject_event_id\l*subject_id\l*event_id\l }"]
    67 n1430 [ label="{ instruction_schedule| #instruction_schedule_id\l*schedule_id\l*term_id\l }"]
    68 n1437 [ label="{ course_event| #course_event_id\l*course_id\l*instruction_event_id\l*subject_event_id\l }"]
    69 n1448 [ label="{ instruction_event| #instruction_event_id\l*event_id\l*instruction_schedule_id\l*instruction_type_id\l*instructor_id\l }"]
    70 n1460 [ label="{ session_schedule| #exam_session_schedule_id\l*exam_session_id\l*schedule_id\l }"]
    71 n1467 [ label="{ exam_event| #exam_event_id\l*exam_id\l*subject_event_id\l*exam_session_schedule_id\l }"]
    72 n1478 [ label="{ activity| #activity_id\l*activity_type_id\l }"]
    73 n1483 [ label="{ assessment_type| #assessment_type_id\lcode\ltitle\ltitle_en\lgrade\lpoints\lcredit\lnote\l }"]
    74 n1493 [ label="{ course_activity| #course_activity_id\l*activity_id\l*course_id\l }"]
    75 n1502 [ label="{ exam| #exam_id\l*activity_id\l*exam_session_id\l*subject_id\l }"]
    76 n1512 [ label="{ exam_session| #exam_session_id\l*term_id\l }"]
    77 n1519 [ label="{ exam_application| #exam_application_id\l*exam_id\l*student_activity_id\l }"]
    78 n1532 [ label="{ activity_assessment| #activity_assessment_id\l*assessment_id\l*course_activity_id\l }"]
    79 n1542 [ label="{ country| #country_id\lcode\lcode_short\ltitle\ltitle_en\l }"]
    80 n1549 [ label="{ language| #language_id\lcode\ltitle\ltitle_en\l }"]
    81 n1555 [ label="{ country_language| #country_language_id\lofficial\l*country_id\l*language_id\l }"]
    82 n1562 [ label="{ province| #province_id\lcode\ltitle\ltitle_en\l*country_id\l }"]
    83 n1570 [ label="{ payment_type| #payment_type_id\ltitle\lnote\l }"]
    84 n1575 [ label="{ document_type| #document_type_id\ltitle\ltitle_en\lnote\l }"]
    85 n1581 [ label="{ account| #account_id\lcode\ltitle\lactive\lvalid_from\lvalid_to\lnote\l*institution_id\l*payment_type_id\l*pay_institution_id\l }"]
    86 n1597 [ label="{ document_type_account| #document_type_account_id\lactive\lvalid_from\lvalid_to\l*document_type_id\l*account_id\l }"]
    87 n1607 [ label="{ document| #document_id\lcreated\larchive_number\ldoc_content\lnote\lhash\lsignature\l*institution_id\l*document_type_id\l*author_person_id\l }"]
    88 n1622 [ label="{ document_student| #document_student_id\l*document_id\l*student_id\l }"]
    89 n1629 [ label="{ ledger| #ledger_id\lstate\lcreated\leffective\ldebit_amount\lcredit_amount\ldebit_point\lcredit_point\l*document_student_id\l*account_id\l }"]
    90 n1645 [ label="{ attachment| #attachment_id\lnote\lattach_content\l*document_id\l }"]
    91 n1654 [ label="{ subject_enrollment| #subject_enrollment_id\l*termsubject_currlink_id\l*term_enrollment_id\l }"]
    92 n1663 [ label="{ document_program| #document_program_id\l*program_enrollment_id\l*document_student_id\l }"]
    93 n1671 [ label="{ document_term| #document_term_id\l*term_enrollment_id\l*document_program_id\l }"]
    94 n1680 [ label="{ document_course| #document_course_id\l*document_term_id\l*course_enrollment_id\l }"]
    95 n1692 [ label="{ ledger_link| #ledger_link_id\lamount\lpoints\l*ledger_id\l*link_ledger_id\l }"]
    96 n2042 [ label="{ term_subject_curriculum_link| #termsubject_currlink_id\l*curriculum_link_id\l*term_subject_id\l }"]
    97 n2085 [ label="{ staff| #staff_id\lfrom_date\lto_date\l*person_id\l*role_type_id\l*institution_id\l }"]
    98 n2096 [ label="{ role_type| #role_type_id\lcode\ltitle\ltitle_en\labstract\lnote\l }"]
    99 n2116 [ label="{ term_type| #term_type_id\lcode\ltitle\ltitle_en\labstract\lnote\l }"]
    100 n2414 [ label="{ course_term_subject_curriculum_link| *termsubject_currlink_id\l*course_id\l }"]
     23n1008 [ label="{ <<entity>>/linstitution| #institution_id\lcode\ltitle\ltitle_en\lnote\l*parent_institution_id\l*institution_type_id\l }"]
     24n1019 [ label="{ <<entity>>/linstitution_type| #institution_type_id\lcode\ltitle\ltitle_en\lhost_programs\lnote\l }"]
     25n1027 [ label="{ <<entity>>/lperson| #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 }"]
     26n1049 [ label="{ <<entity>>/lstudent| #student_id\lstatus_2\l*institution_id\l*person_id\l }"]
     27n1057 [ label="{ <<entity>>/linstructor| #instructor_id\lfrom_date\lto_date\l*person_id\l*institution_id\l }"]
     28n1064 [ label="{ <<entity>>/lfacility| #facility_id\lcode\ltitle\ltitle_en\lnote\l*parent_facility_id\l*institution_id\l*facility_type_id\l }"]
     29n1077 [ label="{ <<entity>>/lfacility_type| #facility_type_id\lcode\ltitle\ltitle_en\lhost_event\lnote\l }"]
     30n1085 [ label="{ <<entity>>/lplan| #plan_id\lcode\ltitle\ltitle_en\lstart_term\lend_term\lnote\l*institution_id\l }"]
     31n1097 [ label="{ <<entity>>/lprogram| #program_id\lcode\ltitle\ltitle_en\lterms\lnote\l*plan_id\l }"]
     32n1109 [ label="{ <<entity>>/ldegree| #degree_id\lcode\ltitle\ltitle_en\lterms\lnote\l*institution_id\l }"]
     33n1119 [ label="{ <<entity>>/lsubject| #subject_id\lcode\ltitle\ltitle_en\labstract\lnote\l*institution_id\l }"]
     34n1129 [ label="{ <<entity>>/lprogram_degree| #program_degree_id\l*program_id\l*degree_id\l }"]
     35n1136 [ label="{ <<entity>>/lcurriculum| #curriculum_id\lterm\lterm_ordinal\lsubject_title\llecture\ltutorial\llaboratory\linstruction\lindividual\lcredits\l*program_id\l*subject_id\l*module_type_id\l*exam_type_id\l }"]
     36n1156 [ label="{ <<entity>>/lcurriculum_link| #curriculum_link_id\l*curriculum_id\l*link_type_id\l }"]
     37n1166 [ label="{ <<entity>>/llink_type| #link_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
     38n1173 [ label="{ <<entity>>/lmodule_type| #module_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
     39n1180 [ label="{ <<entity>>/lexam_type| #exam_type_id\lcode\ltitle\ltitle_en\lwriten\loral\lpractical\lnote\l }"]
     40n1190 [ label="{ <<entity>>/lcurriculum_instruction| #curriculum_instruction_id\lper_week\lhours\l*instruction_type_id\l*curriculum_id\l }"]
     41n1200 [ label="{ <<entity>>/linstruction_type| #instruction_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
     42n1207 [ label="{ <<entity>>/lprogram_enrollment| #program_enrollment_id\l*program_id\l*student_id\l }"]
     43n1214 [ label="{ <<entity>>/lterm| #term_id\lterm_year\lterm_from\lterm_to\lnote\lbelowminimum_credits\lminimum_credits\lmaximum_credits\l*term_type_id\l*institution_id\l }"]
     44n1220 [ label="{ <<entity>>/lterm_program| #term_program_id\l*term_id\l*program_id\l }"]
     45n1227 [ label="{ <<entity>>/lterm_subject| #term_subject_id\lenroll_deadline\lcancel_deadline\l*subject_id\l*term_id\l }"]
     46n1234 [ label="{ <<entity>>/lcourse| #course_id\lurl\lmoodle\l }"]
     47n1242 [ label="{ <<entity>>/lcourse_curriculum| #course_curriculum_id\lgrade_allow\l*curriculum_link_id\l*course_id\l*term_program_id\l }"]
     48n1253 [ label="{ <<entity>>/lcourse_instructor| #course_instructor_id\l*course_id\l*instructor_id\l }"]
     49n1262 [ label="{ <<entity>>/lterm_enrollment| #term_enrollment_id\lenrollment_status\lnote\l*term_program_id\l*program_enrollment_id\l }"]
     50n1270 [ label="{ <<entity>>/lcourse_enrollment| #course_enrollment_id\lgrade\l*subject_enrollment_id\l*course_curriculum_id\l }"]
     51n1281 [ label="{ <<entity>>/lcourse_curriculum_instruction| #coursecurr_instruction_id\l*curriculum_instruction_id\l*course_curriculum_id\l*course_instructor_id\l }"]
     52n1294 [ label="{ <<entity>>/lassessment| #assessment_id\lgrade\lpoints\lcredit\ldescription\lnote\l*assessment_type_id\l }"]
     53n1304 [ label="{ <<entity>>/lstudent_assessment| #student_assessment_id\l*program_enrollment_id\l*assessment_id\l }"]
     54n1312 [ label="{ <<entity>>/lcurriculum_assessment| #curriculum_assessment_id\l*curriculum_link_id\l*student_assessment_id\l }"]
     55n1322 [ label="{ <<entity>>/lcourse_assessment| #course_assessment_id\l*activity_assessment_id\l*curriculum_assessment_id\l*student_activity_id\l }"]
     56n1336 [ label="{ <<entity>>/lstudent_activity| #student_activity_id\l*course_activity_id\l*course_enrollment_id\l }"]
     57n1348 [ label="{ <<entity>>/lactivity_type| #activity_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
     58n1355 [ label="{ <<entity>>/lschedule| #schedule_id\l*institution_id\l }"]
     59n1361 [ label="{ <<entity>>/lformation| #formation_id\l*instruction_schedule_id\l }"]
     60n1369 [ label="{ <<entity>>/lslot| #slot_id\l*schedule_id\l*facility_id\l }"]
     61n1378 [ label="{ <<entity>>/lformation_student| #formation_student_id\l*formation_id\l*term_enrollment_id\l }"]
     62n1388 [ label="{ <<entity>>/levent| #event_id\l*schedule_id\l*event_type_id\l }"]
     63n1397 [ label="{ <<entity>>/levent_type| #event_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
     64n1404 [ label="{ <<entity>>/levent_formation| #event_formation_id\l*event_id\l*formation_id\l }"]
     65n1413 [ label="{ <<entity>>/levent_slot| #event_slod_id\l*event_id\l*slot_id\l }"]
     66n1422 [ label="{ <<entity>>/lsubject_event| #subject_event_id\l*subject_id\l*event_id\l }"]
     67n1430 [ label="{ <<entity>>/linstruction_schedule| #instruction_schedule_id\l*schedule_id\l*term_id\l }"]
     68n1437 [ label="{ <<entity>>/lcourse_event| #course_event_id\l*course_id\l*instruction_event_id\l*subject_event_id\l }"]
     69n1448 [ label="{ <<entity>>/linstruction_event| #instruction_event_id\l*event_id\l*instruction_schedule_id\l*instruction_type_id\l*instructor_id\l }"]
     70n1460 [ label="{ <<entity>>/lsession_schedule| #exam_session_schedule_id\l*exam_session_id\l*schedule_id\l }"]
     71n1467 [ label="{ <<entity>>/lexam_event| #exam_event_id\l*exam_id\l*subject_event_id\l*exam_session_schedule_id\l }"]
     72n1478 [ label="{ <<entity>>/lactivity| #activity_id\l*activity_type_id\l }"]
     73n1483 [ label="{ <<entity>>/lassessment_type| #assessment_type_id\lcode\ltitle\ltitle_en\lgrade\lpoints\lcredit\lnote\l }"]
     74n1493 [ label="{ <<entity>>/lcourse_activity| #course_activity_id\l*activity_id\l*course_id\l }"]
     75n1502 [ label="{ <<entity>>/lexam| #exam_id\l*activity_id\l*exam_session_id\l*subject_id\l }"]
     76n1512 [ label="{ <<entity>>/lexam_session| #exam_session_id\l*term_id\l }"]
     77n1519 [ label="{ <<entity>>/lexam_application| #exam_application_id\l*exam_id\l*student_activity_id\l }"]
     78n1532 [ label="{ <<entity>>/lactivity_assessment| #activity_assessment_id\l*assessment_id\l*course_activity_id\l }"]
     79n1542 [ label="{ <<entity>>/lcountry| #country_id\lcode\lcode_short\ltitle\ltitle_en\l }"]
     80n1549 [ label="{ <<entity>>/llanguage| #language_id\lcode\ltitle\ltitle_en\l }"]
     81n1555 [ label="{ <<entity>>/lcountry_language| #country_language_id\lofficial\l*country_id\l*language_id\l }"]
     82n1562 [ label="{ <<entity>>/lprovince| #province_id\lcode\ltitle\ltitle_en\l*country_id\l }"]
     83n1570 [ label="{ <<entity>>/lpayment_type| #payment_type_id\ltitle\lnote\l }"]
     84n1575 [ label="{ <<entity>>/ldocument_type| #document_type_id\ltitle\ltitle_en\lnote\l }"]
     85n1581 [ label="{ <<entity>>/laccount| #account_id\lcode\ltitle\lactive\lvalid_from\lvalid_to\lnote\l*institution_id\l*payment_type_id\l*pay_institution_id\l }"]
     86n1597 [ label="{ <<entity>>/ldocument_type_account| #document_type_account_id\lactive\lvalid_from\lvalid_to\l*document_type_id\l*account_id\l }"]
     87n1607 [ label="{ <<entity>>/ldocument| #document_id\lcreated\larchive_number\ldoc_content\lnote\lhash\lsignature\l*institution_id\l*document_type_id\l*author_person_id\l }"]
     88n1622 [ label="{ <<entity>>/ldocument_student| #document_student_id\l*document_id\l*student_id\l }"]
     89n1629 [ label="{ <<entity>>/lledger| #ledger_id\lstate\lcreated\leffective\ldebit_amount\lcredit_amount\ldebit_point\lcredit_point\l*document_student_id\l*account_id\l }"]
     90n1645 [ label="{ <<entity>>/lattachment| #attachment_id\lnote\lattach_content\l*document_id\l }"]
     91n1654 [ label="{ <<entity>>/lsubject_enrollment| #subject_enrollment_id\l*termsubject_currlink_id\l*term_enrollment_id\l }"]
     92n1663 [ label="{ <<entity>>/ldocument_program| #document_program_id\l*program_enrollment_id\l*document_student_id\l }"]
     93n1671 [ label="{ <<entity>>/ldocument_term| #document_term_id\l*term_enrollment_id\l*document_program_id\l }"]
     94n1680 [ label="{ <<entity>>/ldocument_course| #document_course_id\l*document_term_id\l*course_enrollment_id\l }"]
     95n1692 [ label="{ <<entity>>/lledger_link| #ledger_link_id\lamount\lpoints\l*ledger_id\l*link_ledger_id\l }"]
     96n2042 [ label="{ <<entity>>/lterm_subject_curriculum_link| #termsubject_currlink_id\l*curriculum_link_id\l*term_subject_id\l }"]
     97n2085 [ label="{ <<entity>>/lstaff| #staff_id\lfrom_date\lto_date\l*person_id\l*role_type_id\l*institution_id\l }"]
     98n2096 [ label="{ <<entity>>/lrole_type| #role_type_id\lcode\ltitle\ltitle_en\labstract\lnote\l }"]
     99n2116 [ label="{ <<entity>>/lterm_type| #term_type_id\lcode\ltitle\ltitle_en\labstract\lnote\l }"]
     100n2414 [ label="{ <<entity>>/lcourse_term_subject_curriculum_link| *termsubject_currlink_id\l*course_id\l }"]
    101101n1008 -> n1008
    102102n1008 -> n1019
     
    226226n2414 -> n2042
    227227
    228 
    229228}
    230229}}}