White dot for spacing only
The Dice Project


Database Service Data Model


Table: 3g ADMIS-Contact-Feed  E3G#ADM_CON 
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 EUCLID Admissions Universe data from BOXI for PGR students. Used to sync against local Address and Email records.

Fields


The following box shows the 12 fields in this table.

Name Content Length Empty?
Address 1 Character/Fixed 60 YES
Address 2 Character/Fixed 60 YES
Address 3 Character/Fixed 60 YES
Address 4 Character/Fixed 60 YES
Address 5 Character/Fixed 60 YES
Address Type Character/Fixed 20 YES
Email Character/Fixed 50 YES
Email Type Character/Fixed 20 YES
Mobile# Character/Fixed 40 YES
Phone# Character/Fixed 25 YES
Postcode Character/Fixed 12 YES
UUN Character/Fixed 8 YES

Clusters


The following list shows the cluster containing this table.


Keys


There are no primary keys defined in this table.

There are no foreign keys posted into this table.

Links


There are no forward links from this table.

There are no reverse links from this table.

Schema


CREATE TABLE admis_contact_feed_3g (
uun CHAR(8),
address1 CHAR(60),
address2 CHAR(60),
address3 CHAR(60),
address4 CHAR(60),
address5 CHAR(60),
postcode CHAR(12),
phone CHAR(25),
mobile CHAR(40),
email CHAR(50),
type CHAR(20),
etype CHAR(20)
) 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