Intership_project-NodeJS-/Schema.txt at master · deekshakulal/Intership_project-NodeJS- · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
user{
    _id:
    fullName:
    email:
    password:
    phone:
    gender:
    city:
    saltSecret:
    tokens: [{
                token:
            }]
}

class{
    _id:
    name:
    roomNumber:
}

subject{
    _id:
    name:
}

classSubject{
    _id:
    class_id:
    subject_id:
}

student{
    _id:
    name:
    //other student related fields:
    batch_name:
}

batch{
    _id:
    batch_name:
    subject_name:
    students:[
             {_id:  ,name:}
             ]
    price:
}

studentSubject{
    _id:
    student_id:
    subjects:[
             {subject_name:    ,batch_name:},
             {subject_name:    ,batch_name:},
             ..............................
             ]
    fees:
}

subjectfees{
    subject_id:
    default_price:
    increased_price:[
                    {batch_name:    ,price:},
                    {batch_name:    ,price:},
                    ........................
                    ]
}
userTimeTable{
    _id:
    user_id:
    mon:[
        {classSubject_id:   ,time:   },
        {classSubject_id:   ,time:   },
        ..............................
    }]
    tue:[
        {classSubject_id:   ,time:   },
        {classSubject_id:   ,time:   },
        ..............................
    }]
    ...................................
    sat:[
        {classSubject_id:   ,time:   },
        {classSubject_id:   ,time:   },
        ..............................
    }]
}

attendanceLog{
    _id:
    classSubject_id:
    user_id:
    time:
}

absentLog{
    _id:
    attendanceLog_id:
    student_id:
}
book{
    name:
    publication:
    pub_year:
    author:
    edition:
    prize:
    copy:
    supplier:
}