White dot for spacing only
The Dice Project


Database Service Data Model


Table: 3g Student-Development  E3G#STU_DEV 
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

Holds any CPD done by the student over and above their programme of study. External training courses and placements for example.

Fields


The following box shows the 6 fields in this table.

Name Content Length Empty?
End Date Abstract/Date 12 YES
Person@ Character/Fixed 18 NO
Programme@ Character/Fixed 8 NO
Start Date Abstract/Date 12 YES
Type Abstract/Set 40 YES
Type (if Other) Character/Fixed 40 YES

Clusters


The following list shows the cluster containing this table.


Keys


There are no primary keys defined in this table.

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

Links


There are no forward links from this table.

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

Schema


CREATE TABLE student_development_3g (
person CHAR(18) NOT NULL NOT DEFAULT,
programme CHAR(8) NOT NULL NOT DEFAULT,
start_date DATE,
end_date DATE,
type CHAR(40),
type_oth CHAR(40)
) 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