White dot for spacing only
The Dice Project


Database Service Data Model


Table: Module-Exam  ENT#ITO_MOE 
Related Pages

Overview

Cluster Index
Table Index
Field Index
Key Index
Link Index

Name Index
Code Index

DB Table Index
DB Column Index

DB Size Statistics

Data Model Home
Home

Details on each question that makes up a module exam.

Fields


The following box shows the 8 fields in this table.

Name Content Length Empty?
Exam@ Character/Fixed 1 NO
Ignored? Abstract/Boolean 1 YES
Module@ Character/Fixed 8 NO
Outof Abstract/Money 8 YES
Question@ Character/Fixed 4 NO
Session@ Character/Fixed 2 NO
Title Character/Fixed 80 YES
Worth Abstract/Money 8 YES

Clusters


The following list shows the cluster containing this table.


Keys


The following list shows the primary key defined in this table.

The following list shows the 2 foreign keys posted into this table.

Links


The following list shows the 5 forward links from this table.

The following list shows the 2 reverse links from this table.

Schema


CREATE TABLE module_exam (
session CHAR(2) NOT NULL NOT DEFAULT,
module CHAR(8) NOT NULL NOT DEFAULT,
exam CHAR(1) NOT NULL NOT DEFAULT,
question CHAR(4) NOT NULL NOT DEFAULT,
title CHAR(80),
ignored INTEGER1,
outof MONEY,
worth MONEY
) WITH NODUPLICATES;


 : Doc : Database : Dm : Table 

Mini Informatics Logo - Link to Main Informatics Page
Please contact us with any comments or corrections.
Unless explicitly stated otherwise, all material is copyright The University of Edinburgh
Spacing Line