lic
 

 

coursetype  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

CODE

char(6)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

DESCRIP

varchar(60)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

TRANNO

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

coursetype

0

PRIMARY

1

TRANNO

A

3

(NULL)

(NULL)

 

BTREE

 

coursetype

1

CODE

1

CODE

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

coursetype

1

DESCRIP

1

DESCRIP

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

coursetype

1

TRANNO

1

TRANNO

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

Back