White dot for spacing only
The Dice Project


Database Service Data Model


Table: PAVD iE  ENT#INF_PVI 
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

Contains PAVD data managed locally attached to the automatically sync'ed data in the PAVD Person and PAVD Course tables.

Fields


The following box shows the 16 fields in this table.

Name Content Length Empty?
Attended? Abstract/Boolean 1 YES
CO Abstract/Boolean 1 YES
Code Character/Fixed 8 NO
Day Abstract/Set 10 YES
Guests Numeric/Fixed 1 YES
Interest1 Abstract/Set 20 YES
Interest2 Abstract/Set 20 YES
Person1to1 Character/Fixed 25 YES
Requirements Character/Fixed 80 YES
Sent Abstract/Date 10 YES
Sport1 Abstract/Set 20 YES
Sport2 Abstract/Set 20 YES
Time1to1 Abstract/Set 2 YES
UOCA Abstract/Boolean 1 YES
UOCH Abstract/Boolean 1 YES
Visiting Abstract/Set 20 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 foreign key posted into this table.

Links


There are no forward links from this table.

The following list shows the reverse link from this table.

Schema


CREATE TABLE pavd_ie (
code CHAR(8) NOT NULL NOT DEFAULT,
interest1 CHAR(20),
interest2 CHAR(20),
sport1 CHAR(20),
sport2 CHAR(20),
uoh INTEGER1,
uoa INTEGER1,
co INTEGER1,
sent DATE,
guests INTEGER1,
visiting CHAR(20),
requirements CHAR(80),
attended INTEGER1,
person1to1 CHAR(25),
time1to1 CHAR(2),
day CHAR(10)
) 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