White dot for spacing only
The Dice Project


Database Service Data Model


Table: 3g Group-Type  E3G#GRO_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 group there are.

Fields


The following box shows the 10 fields in this table.

Name Content Length Empty?
Archived? Abstract/Boolean 1 YES
Description Character/Fixed 320 YES
Enrol Numeric/Fixed 8 YES
Name Character/Fixed 50 YES
Size Numeric/Fixed 1 YES
Standard? Abstract/Boolean 1 YES
Summary Character/Fixed 50 YES
Tag Character/Fixed 25 YES
Transient? Abstract/Boolean 1 YES
Type@ Character/Fixed 8 NO

Clusters


The following list shows the 3 clusters containing this table.


Keys


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

There are no foreign keys posted into this table.

Links


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

There are no reverse links from this table.

Schema


CREATE TABLE group_type_3g (
type CHAR(8) NOT NULL NOT DEFAULT,
summary CHAR(50),
tag CHAR(25),
size INTEGER1,
description CHAR(320),
name CHAR(50),
archived INTEGER1,
transient INTEGER1,
standard INTEGER1,
enrol INTEGER8
) 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