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 — =