---

{
  "_type": "Project",
  "_id": "AAAAAAFF+h6SjaM212U=",
  "name": "School_Database_ERD",
  "ownedElements": [
    {
      "_type": "ERDDataModel",
      "_id": "AAAAAAFF+qBtyKM79qY=",
      "_parent": { "$ref": "AAAAAAFF+h6SjaM212U=" },
      "name": "School_ERD_Model",
      "ownedElements": [
        {
          "_type": "ERDDiagram",
          "_id": "AAAAAAFF+qBtyKM8klE=",
          "_parent": { "$ref": "AAAAAAFF+qBtyKM79qY=" },
          "name": "School_Database_Diagram",
          "visible": true,
          "ownedViews": [
            {
              "_type": "ERDEntityView",
              "_id": "view_cabinets",
              "_parent": { "$ref": "AAAAAAFF+qBtyKM8klE=" },
              "model": { "$ref": "entity_cabinets" },
              "left": 40, "top": 40, "width": 180, "height": 90
            },
            {
              "_type": "ERDEntityView",
              "_id": "view_teachers",
              "_parent": { "$ref": "AAAAAAFF+qBtyKM8klE=" },
              "model": { "$ref": "entity_teachers" },
              "left": 280, "top": 40, "width": 190, "height": 110
            },
            {
              "_type": "ERDEntityView",
              "_id": "view_subjects",
              "_parent": { "$ref": "AAAAAAFF+qBtyKM8klE=" },
              "model": { "$ref": "entity_subjects" },
              "left": 530, "top": 40, "width": 180, "height": 90
            },
            {
              "_type": "ERDEntityView",
              "_id": "view_teacher_subjects",
              "_parent": { "$ref": "AAAAAAFF+qBtyKM8klE=" },
              "model": { "$ref": "entity_teacher_subjects" },
              "left": 400, "top": 200, "width": 180, "height": 90
            },
            {
              "_type": "ERDEntityView",
              "_id": "view_classes",
              "_parent": { "$ref": "AAAAAAFF+qBtyKM8klE=" },
              "model": { "$ref": "entity_classes" },
              "left": 160, "top": 200, "width": 190, "height": 120
            },
            {
              "_type": "ERDEntityView",
              "_id": "view_students",
              "_parent": { "$ref": "AAAAAAFF+qBtyKM8klE=" },
              "model": { "$ref": "entity_students" },
              "left": 40, "top": 380, "width": 180, "height": 110
            },
            {
              "_type": "ERDEntityView",
              "_id": "view_grades",
              "_parent": { "$ref": "AAAAAAFF+qBtyKM8klE=" },
              "model": { "$ref": "entity_grades" },
              "left": 280, "top": 380, "width": 180, "height": 140
            },
            {
              "_type": "ERDEntityView",
              "_id": "view_schedule",
              "_parent": { "$ref": "AAAAAAFF+qBtyKM8klE=" },
              "model": { "$ref": "entity_schedule" },
              "left": 530, "top": 280, "width": 190, "height": 170
            }
          ]
        },
        {
          "_type": "ERDEntity",
          "_id": "entity_cabinets",
          "_parent": { "$ref": "AAAAAAFF+qBtyKM79qY=" },
          "name": "Cabinets",
          "columns": [
            {
              "_type": "ERDColumn",
              "_id": "col_cab_id",
              "_parent": { "$ref": "entity_cabinets" },
              "name": "cabinet_id",
              "type": "INTEGER",
              "primaryKey": true,
              "foreignKey": false,
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_cab_num",
              "_parent": { "$ref": "entity_cabinets" },
              "name": "room_number",
              "type": "VARCHAR",
              "length": "20",
              "primaryKey": false,
              "foreignKey": false,
              "nullable": false
            }
          ]
        },
        {
          "_type": "ERDEntity",
          "_id": "entity_teachers",
          "_parent": { "$ref": "AAAAAAFF+qBtyKM79qY=" },
          "name": "Teachers",
          "columns": [
            {
              "_type": "ERDColumn",
              "_id": "col_teach_id",
              "_parent": { "$ref": "entity_teachers" },
              "name": "teacher_id",
              "type": "INTEGER",
              "primaryKey": true,
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_teach_name",
              "_parent": { "$ref": "entity_teachers" },
              "name": "full_name",
              "type": "VARCHAR",
              "length": "100",
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_teach_cab",
              "_parent": { "$ref": "entity_teachers" },
              "name": "cabinet_id",
              "type": "INTEGER",
              "foreignKey": true,
              "nullable": true
            }
          ]
        },
        {
          "_type": "ERDEntity",
          "_id": "entity_subjects",
          "_parent": { "$ref": "AAAAAAFF+qBtyKM79qY=" },
          "name": "Subjects",
          "columns": [
            {
              "_type": "ERDColumn",
              "_id": "col_sub_id",
              "_parent": { "$ref": "entity_subjects" },
              "name": "subject_id",
              "type": "INTEGER",
              "primaryKey": true,
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_sub_name",
              "_parent": { "$ref": "entity_subjects" },
              "name": "subject_name",
              "type": "VARCHAR",
              "length": "100",
              "nullable": false
            }
          ]
        },
        {
          "_type": "ERDEntity",
          "_id": "entity_teacher_subjects",
          "_parent": { "$ref": "AAAAAAFF+qBtyKM79qY=" },
          "name": "Teacher_Subjects",
          "columns": [
            {
              "_type": "ERDColumn",
              "_id": "col_ts_teach",
              "_parent": { "$ref": "entity_teacher_subjects" },
              "name": "teacher_id",
              "type": "INTEGER",
              "primaryKey": true,
              "foreignKey": true,
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_ts_sub",
              "_parent": { "$ref": "entity_teacher_subjects" },
              "name": "subject_id",
              "type": "INTEGER",
              "primaryKey": true,
              "foreignKey": true,
              "nullable": false
            }
          ]
        },
        {
          "_type": "ERDEntity",
          "_id": "entity_classes",
          "_parent": { "$ref": "AAAAAAFF+qBtyKM79qY=" },
          "name": "Classes",
          "columns": [
            {
              "_type": "ERDColumn",
              "_id": "col_cls_id",
              "_parent": { "$ref": "entity_classes" },
              "name": "class_id",
              "type": "INTEGER",
              "primaryKey": true,
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_cls_num",
              "_parent": { "$ref": "entity_classes" },
              "name": "class_num",
              "type": "INTEGER",
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_cls_letter",
              "_parent": { "$ref": "entity_classes" },
              "name": "class_letter",
              "type": "VARCHAR",
              "length": "5",
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_cls_teacher",
              "_parent": { "$ref": "entity_classes" },
              "name": "class_teacher_id",
              "type": "INTEGER",
              "foreignKey": true,
              "nullable": false
            }
          ]
        },
        {
          "_type": "ERDEntity",
          "_id": "entity_students",
          "_parent": { "$ref": "AAAAAAFF+qBtyKM79qY=" },
          "name": "Students",
          "columns": [
            {
              "_type": "ERDColumn",
              "_id": "col_stu_id",
              "_parent": { "$ref": "entity_students" },
              "name": "student_id",
              "type": "INTEGER",
              "primaryKey": true,
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_stu_name",
              "_parent": { "$ref": "entity_students" },
              "name": "full_name",
              "type": "VARCHAR",
              "length": "100",
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_stu_cls",
              "_parent": { "$ref": "entity_students" },
              "name": "class_id",
              "type": "INTEGER",
              "foreignKey": true,
              "nullable": false
            }
          ]
        },
        {
          "_type": "ERDEntity",
          "_id": "entity_grades",
          "_parent": { "$ref": "AAAAAAFF+qBtyKM79qY=" },
          "name": "Grades",
          "columns": [
            {
              "_type": "ERDColumn",
              "_id": "col_grd_id",
              "_parent": { "$ref": "entity_grades" },
              "name": "grade_id",
              "type": "INTEGER",
              "primaryKey": true,
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_grd_stu",
              "_parent": { "$ref": "entity_grades" },
              "name": "student_id",
              "type": "INTEGER",
              "foreignKey": true,
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_grd_sub",
              "_parent": { "$ref": "entity_grades" },
              "name": "subject_id",
              "type": "INTEGER",
              "foreignKey": true,
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_grd_qtr",
              "_parent": { "$ref": "entity_grades" },
              "name": "quarter",
              "type": "INTEGER",
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_grd_val",
              "_parent": { "$ref": "entity_grades" },
              "name": "grade_value",
              "type": "INTEGER",
              "nullable": false
            }
          ]
        },
        {
          "_type": "ERDEntity",
          "_id": "entity_schedule",
          "_parent": { "$ref": "AAAAAAFF+qBtyKM79qY=" },
          "name": "Schedule",
          "columns": [
            {
              "_type": "ERDColumn",
              "_id": "col_sch_id",
              "_parent": { "$ref": "entity_schedule" },
              "name": "schedule_id",
              "type": "INTEGER",
              "primaryKey": true,
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_sch_cls",
              "_parent": { "$ref": "entity_schedule" },
              "name": "class_id",
              "type": "INTEGER",
              "foreignKey": true,
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_sch_day",
              "_parent": { "$ref": "entity_schedule" },
              "name": "day_of_week",
              "type": "VARCHAR",
              "length": "15",
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_sch_les",
              "_parent": { "$ref": "entity_schedule" },
              "name": "lesson_number",
              "type": "INTEGER",
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_sch_sub",
              "_parent": { "$ref": "entity_schedule" },
              "name": "subject_id",
              "type": "INTEGER",
              "foreignKey": true,
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_sch_tch",
              "_parent": { "$ref": "entity_schedule" },
              "name": "teacher_id",
              "type": "INTEGER",
              "foreignKey": true,
              "nullable": false
            },
            {
              "_type": "ERDColumn",
              "_id": "col_sch_cab",
              "_parent": { "$ref": "entity_schedule" },
              "name": "cabinet_id",
              "type": "INTEGER",
              "foreignKey": true,
              "nullable": true
            }
          ]
        }
      ]
    }
  ]
}