Field

Type

Null

Key

Default

Extra

CLASstatus

id

smallint(5) unsigned

PRI

0

auto_increment

type

varchar(10) binary

YES

observer

Field

Type

Null

Key

Default

Extra

history

id

smallint(5) unsigned

PRI

0

auto_increment

start

date

YES

NULL

end

date

YES

99990101

person

smallint(5) unsigned

YES

NULL

institute1

smallint(5) unsigned

YES

NULL

institute2

smallint(5) unsigned

YES

NULL

institute3

smallint(5) unsigned

YES

NULL

CLASstatus

smallint(5) unsigned

YES

NULL

comment

varchar(250) binary

YES

NULL

authors

Field

Type

Null

Key

Default

Extra

id

smallint(5)unsigned

PRI

0

auto_increment

person

smallint(5)unsigned

YES

NULL

pub

smallint(5)unsigned

YES

NULL

changes

Field

Type

Null

Key

Default

Extra

id

smallint(5)unsigned

PRI

0

auto_increment

when

date

YES

NULL

what

varchar(50)binary

YES

NULL

comment

varchar(250)binary

YES

NULL

expPeriod

Field

Type

Null

Key

Default

Extra

id

smallint(5)unsigned

PRI

0

auto_increment

name

varchar(25)binary

YES

NULL

start

date

YES

NULL

end

date

YES

NULL

comment

varchar(250)binary

YES

NULL

publPeriods

Field

Type

Null

Key

Default

Extra

id

smallint(5)unsigned

PRI

0

auto_increment

period

smallint(5)unsigned

YES

NULL

pub

smallint(5)unsigned

YES

NULL

publications

Field

Type

Null

Key

Default

Extra

id

smallint(5)unsigned

PRI

0

auto_increment

rep

smallint(5)unsigned

YES

NULL

title

varchar(250)binary

YES

NULL

status

varchar(50)binary

YES

NULL

comment

varchar(250)binary

YES

NULL

workGroups

Field

Type

Null

Key

Default

Extra

id

smallint(5)unsigned

PRI

0

auto_increment

name

varchar(25)binary

YES

NULL

chair

smallint(5)unsigned

YES

NULL

rep

smallint(5)unsigned

YES

NULL

comment

varchar(250)binary

YES

NULL

Field

Type

Null

Key

Default

Extra

institutes

id

smallint(5) unsigned

PRI

0

auto_increment

acronym

varchar(20)

YES

NULL

rep

smallint(5) unsigned

YES

NULL

name

varchar(100) binary

YES

NULL

address1

varchar(100) binary

YES

NULL

address2

varchar(100) binary

YES

NULL

address3

varchar(100) binary

YES

NULL

address4

varchar(100) binary

YES

NULL

address5

varchar(100) binary

YES

NULL

web

varchar(100) binary

YES

NULL

phone

varchar(25) binary

YES

NULL

fax

varchar(25) binary

YES

NULL

CLASmember

enum('Y','N')

YES

NULL

SOSokay

enum('Y','N')

YES

NULL

SOSlink

varchar(100) binary

YES

NULL

Field

Type

Null

Key

Default

Extra

people

id

smallint(5) unsigned

PRI

0

auto_increment

title

varchar(25) binary

YES

NULL

firstname

varchar(25) binary

YES

NULL

middlename

varchar(25) binary

YES

NULL

lastname

varchar(25) binary

YES

NULL

shiftcontact

varchar(50) binary

YES

NULL

shiftstatus

enum('exper','worker','untrained')

untrained

shiftstatus2

enum('available','not available')

available

following table is repeated fo all inst shown

Field

Type

Null

Key

Default

Extra

1

ASU

id

smallint(5) unsigned

PRI

0

auto_increment

2

BATES

person

smallint(5) unsigned

YES

NULL

3

CALTECH

institute

smallint(5) unsigned

YES

NULL

4

CISCO

address1

varchar(100) binary

YES

NULL

5

CMU

address2

varchar(100) binary

YES

NULL

6

CNU

address3

varchar(100) binary

YES

NULL

7

CUA

address4

varchar(100) binary

YES

NULL

8

DUKE

address5

varchar(100) binary

YES

NULL

9

EDINBURGH

web

varchar(100) binary

YES

NULL

10

FIU

phone

varchar(25) binary

YES

NULL

11

FSU

fax

varchar(25) binary

YES

NULL

12

GEORGETOWN

pubname

varchar(50) binary

YES

NULL

13

GLASGOW

email1

varchar(100) binary

Yes

NULL

14

GWU

email2

varchar(100) binary

Yes

NULL

15

INDUSTRY1

phone2

varchar(20) binary

Yes

NULL

16

INFNFR

17

INFNGE

18

ITEP

19

JLAB

20

JMU

21

KYUNGPOOK

22

MIT

23

NSU

24

ODU

25

OHIOU

26

ORSAY

27

ORST

28

PITT

29

RICE

30

RPI

31

SACLAY

32

SCAROLINA

33

Tulane

34

UCLA

35

UCONN

36

UMASS

37

UNH

38

URICH

39

UTEP

40

VIRGINIA

41

VSU

42

VT

43

WM

44

YEREVAN