Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- TABLE: MARKS
- ID INT NOT NULL,
- Activity_id INT,
- User_id INT,
- Value FLOAT(2),
- IsAccepted BIT,
- PRIMARY KEY(ID)
- TABLE: ACTIVITIES
- ID INT NOT NULL,
- Lecturer_id INT,
- Subject_id INT,
- Room_id INT,
- Type_id INT,
- Term DATETIME2,
- PRIMARY KEY(ID)
- TABLE: USERACTIVITY
- ID INT NOT NULL,
- User_id INT,
- Activity_id INT,
- PRIMARY KEY(ID)
- TABLE: ACTIVITYTYPE
- ID INT NOT NULL,
- Name VARCHAR(100),
- PRIMARY KEY(ID)
- TABLE: FACULTIES
- ID INT NOT NULL,
- Name VARCHAR(100),
- Threshold INT NOT NULL,
- PRIMARY KEY(ID)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement