White dot for spacing only
The Dice Project


Database Service Data Model


Table: 3g Spawn-Course-Exam-Score-Feed  E3G#SPC_ESF 
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

Spawn feed for creating and maintaining initial score records for a course exam.

Fields


The following box shows the 6 fields in this table.

Name Content Length Empty?
Course@ Character/Fixed 8 NO
Diet Type@ Character/Fixed 4 NO
Exam@ Character/Fixed 1 NO
Session@ Character/Fixed 2 NO
Type@ Character/Fixed 1 NO
Year@ Character/Fixed 8 YES

Clusters


The following list shows the cluster containing this table.


Keys


There are no primary keys defined in this table.

There are no foreign keys posted into this table.

Links


There are no forward links from this table.

There are no reverse links from this table.

Schema


CREATE TABLE spawn_course_exam_score_feed_3g (
session CHAR(2) NOT NULL NOT DEFAULT,
course CHAR(8) NOT NULL NOT DEFAULT,
type CHAR(1) NOT NULL NOT DEFAULT,
exam CHAR(1) NOT NULL NOT DEFAULT,
diet_type CHAR(4) NOT NULL NOT DEFAULT,
year CHAR(8)
) 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