[sql] амам
Viewer
- -- Создание таблицы Level
- CREATE TABLE Level (
- LevelID INT PRIMARY KEY,
- LevelName VARCHAR(50),
- ExperiencePoints INT
- );
- -- Создание таблицы Admin
- CREATE TABLE Admin (
- AdminID INT PRIMARY KEY,
- AdminName VARCHAR(50),
- Email VARCHAR(50),
- Password VARCHAR(50)
- );
- -- Создание таблицы Expert
- CREATE TABLE Expert (
- ExpertID INT PRIMARY KEY,
- ExpertName VARCHAR(50),
- Email VARCHAR(50),
- Password VARCHAR(50)
- );
- -- Создание таблицы User
- CREATE TABLE USER (
- UserID INT PRIMARY KEY,
- LevelID INT,
- CourseID INT,
- FirstName VARCHAR(50),
- LastName VARCHAR(50),
- Email VARCHAR(50),
- Password VARCHAR(50),
- StartDate DATE,
- Progress INT,
- Grade DECIMAL(5,2),
- STATUS VARCHAR(20),
- ExperiencePoints INT,
- ConsecutiveDays INT,
- FOREIGN KEY (LevelID) REFERENCES Level(LevelID),
- FOREIGN KEY (CourseID) REFERENCES Course(CourseID)
- );
- -- Создание таблицы Course
- CREATE TABLE Course (
- CourseID INT PRIMARY KEY,
- ExpertID INT,
- AdminID INT,
- Title VARCHAR(100),
- Description TEXT,
- LevelID INT, -- Изменено с Level на LevelID
- FOREIGN KEY (ExpertID) REFERENCES Expert(ExpertID),
- FOREIGN KEY (AdminID) REFERENCES Admin(AdminID),
- FOREIGN KEY (LevelID) REFERENCES Level(LevelID) -- Добавлено для связи с таблицей Level
- );
- -- Создание таблицы DailyActivity
- CREATE TABLE DailyActivity (
- ActivityID INT PRIMARY KEY,
- StudentID INT,
- ActivityDate DATE,
- FOREIGN KEY (StudentID) REFERENCES USER(UserID)
- );
- -- Создание таблицы Achievement
- CREATE TABLE Achievement (
- AchievementID INT PRIMARY KEY,
- CourseID INT,
- UserID INT,
- Name VARCHAR(100),
- Description TEXT,
- Percentage DECIMAL(5,2),
- FOREIGN KEY (CourseID) REFERENCES Course(CourseID),
- FOREIGN KEY (UserID) REFERENCES USER(UserID)
- );
- -- Создание таблицы Module
- CREATE TABLE Module (
- ModuleID INT PRIMARY KEY,
- CourseID INT,
- Name VARCHAR(100),
- OrderNumber INT,
- FOREIGN KEY (CourseID) REFERENCES Course(CourseID)
- );
- -- Создание таблицы Lesson
- CREATE TABLE Lesson (
- LessonID INT PRIMARY KEY,
- ModuleID INT,
- Title VARCHAR(100),
- Content TEXT,
- FOREIGN KEY (ModuleID) REFERENCES Module(ModuleID)
- );
- -- Создание таблицы Test
- CREATE TABLE Test (
- TestID INT PRIMARY KEY,
- ModuleID INT,
- TYPE VARCHAR(50),
- MaxScore INT,
- FOREIGN KEY (ModuleID) REFERENCES Module(ModuleID)
- );
- -- Создание таблицы PracticeAssignment
- CREATE TABLE PracticeAssignment (
- PracticeAssignmentID INT PRIMARY KEY,
- ModuleID INT,
- Title VARCHAR(100),
- Description TEXT,
- FOREIGN KEY (ModuleID) REFERENCES Module(ModuleID)
- );
- -- Создание таблицы Question
- CREATE TABLE Question (
- QuestionID INT PRIMARY KEY,
- TestID INT,
- Text TEXT,
- Answers TEXT,
- CorrectAnswer VARCHAR(50),
- Points INT,
- FOREIGN KEY (TestID) REFERENCES Test(TestID)
- );
Editor
You can edit this paste and save as new:
File Description
- амам
- Paste Code
- 24 Apr-2024
- 3.14 Kb
You can Share it:
Latest Code Pastes