White dot for spacing only
The Dice Project


Database Service Data Model


Table: 3g Course-Exam-Diet-Type  E3G#CED_TYP 
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

What kinds of diet are needed for an exam needed for the course in the session. This would be Semester1, Semester2, Resit, Outside (of normal diet).

Fields


The following box shows the 14 fields in this table.

Name Content Length Empty?
Course@ Character/Fixed 8 NO
Exam Type@ Character/Fixed 8 NO
Incoming Column Modified Abstract/Date 8 YES
Incoming Column Modified Abstract/Date 8 YES
Incoming Column Source Character/Fixed 8 YES
Incoming Column Source Character/Fixed 8 YES
Incoming New Abstract/Date 12 YES
Incoming Old Abstract/Date 12 YES
Incoming Source Character/Fixed 16 YES
Incoming Sync Numeric/Fixed 2 YES
Session@ Character/Fixed 2 NO
Type@ Character/Fixed 8 NO
Upcoming Course@ Character/Fixed 8 YES
Variant of Course@ Character/Fixed 8 YES

Clusters


The following list shows the 2 clusters containing this table.


Keys


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

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

Links


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

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

Schema


CREATE TABLE course_exam_diet_type_3g (
session CHAR(2) NOT NULL NOT DEFAULT,
course CHAR(8) NOT NULL NOT DEFAULT,
exam_type CHAR(8) NOT NULL NOT DEFAULT,
type CHAR(8) NOT NULL NOT DEFAULT,
variant_course CHAR(8),
_in_syn INTEGER2,
_in_new DATE,
_in_old DATE,
_in_src CHAR(16),
_in_upcoming_course CHAR(8),
_in_mod_type DATE,
_in_src_type CHAR(8),
_in_mod_variant_course DATE,
_in_src_variant_course 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