Рис 2. Физическая модель данных
Таблицы физической модели данных
Таблица Account:
Атрибут | Тип данных | PKEY | FKEY | NOT NULL | UNIQUE |
Id | int | * | * | * | |
Nick_Name | nvarchar(10) | * | * | ||
Full_Name | nvarchar(25) | * | |||
Account_Type | tinyint | Type(Account_Type) | * | ||
Notes | nvarchar(100) |
Таблица TestCase:
Атрибут | Тип данных | PKEY | FKEY | NOT NULL | UNIQUE |
Id | int | * | * | * | |
Name | nvarchar(20) | * | * | ||
Description | nvarchar(50) | ||||
Id_Creator | int | Account(Id_Creator) | * | ||
Creation_Date | datetime | ||||
Time_To_Answer | time | * | |||
Questions_Amount | tinyint | * |
Таблица Question:
Атрибут | Тип данных | PKEY | FKEY | NOT NULL | UNIQUE |
Id | int | * | * | * | |
Name | nvarchar(60) | * | |||
Answers | nvarchar(1000) | * | |||
Right_Answers | nvarchar(20) | * | |||
Id_Test | int | TestCase(Id_Test) | * |
Таблица Type:
Атрибут | Тип данных | PKEY | FKEY | NOT NULL | UNIQUE |
Id | tinyint | * | * | * | |
Name | nvarchar(20) | * | * | ||
Description | nvarchar(100) | ||||
Rights | tinyint | * |
Таблица Session:
Атрибут | Тип данных | PKEY | FKEY | NOT NULL | UNIQUE |
Id | int | * | * | * | |
Id_Account | int | Account(Id_Account) | * | * | |
Id_Test | int | TestCase(Id_Test) | * | ||
Passed_Questions | nvarchar(1000) | ||||
Answers | nvarchar(1000) | ||||
Start_Time | datetime | * |
|
|