White dot for spacing only
The Dice Project


Database Service Data Model


Table: 3g Course-Work-Part  E3G#CWO_PAR 
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 part of an assignment that makes up the assessment of a course.

Fields


The following box shows the 7 fields in this table.

Name Content Length Empty?
Course@ Character/Fixed 8 NO
Max-Mark Abstract/Money 8 YES
Part@ Character/Fixed 4 NO
Session@ Character/Fixed 2 NO
Title Character/Fixed 40 YES
Type@ Character/Fixed 4 NO
Work@ Character/Fixed 4 NO

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 foreign key posted into this table.

Links


The following list shows the forward link from this table.

The following list shows the reverse link from this table.

Schema


CREATE TABLE course_work_part_3g (
session CHAR(2) NOT NULL NOT DEFAULT,
course CHAR(8) NOT NULL NOT DEFAULT,
type CHAR(4) NOT NULL NOT DEFAULT,
work CHAR(4) NOT NULL NOT DEFAULT,
part CHAR(4) NOT NULL NOT DEFAULT,
title CHAR(40),
max_mark 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