test
Tables (4)
tAnswer
- id — int — Primary key — NOT NULL
- student_id — int — NOT NULL
- session_id — int — NOT NULL
- exam_id — int — NOT NULL
- section_type — varchar(20) — NOT NULL
- question_id — int — NOT NULL
- number — int
- points — int
- correct — bit — NOT NULL
- eliminated — text
- answered — text
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
tErrorLog
- cLogs — int — Primary key — NOT NULL
- cDataBase — varchar(30) — NOT NULL
- cProcedure — varchar(50)
- cAuther — varchar(20) — NOT NULL
- cLoginName — varchar(20) — NOT NULL
- cHostName — varchar(30) — NOT NULL
- cErrorNo — int
- cUserError — int — NOT NULL
- cSeverity — int
- cState — int
- cLineNo — int
- cErrorMessage — nvarchar(max)
- cCreateTime — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
tReport
- cSession_idx — int — Primary key — NOT NULL
- cSection_name — varchar(20) — Primary key — NOT NULL
- cScore — tinyint — NOT NULL
- cQuestion — tinyint — NOT NULL
- cCorrect — tinyint — NOT NULL
- cOmitted — tinyint — NOT NULL
- cScaled — smallint — NOT NULL
- cPercentile — tinyint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
tSession
- id — int — Primary key — NOT NULL
- student_id — int — NOT NULL
- exam_id — int — NOT NULL
- status — int — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- ext_data — text
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =