lic |
course |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
PROVIDERNO |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
COURSENO |
char(15) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
APPROVALDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CATEGORY |
char(6) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CLASSROOM |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
CORRESPOND |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
COURSENAME |
varchar(60) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
COURSETYPE |
char(6) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
CREDITS |
double |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
EXPDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FEDERAL |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
LASTCHGDAT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ONLINE |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
OTHER |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
PROCESSING |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
PUBTOWEB |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
SEMINAR |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
SEMINARDTE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
STATE |
tinyint(1) |
(NULL) |
YES |
MUL |
0 |
|
select,insert,update,references |
|
STATUS |
char(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TRANNO |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
USERINIT |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
course |
0 |
PRIMARY |
1 |
TRANNO |
A |
1276 |
(NULL) |
(NULL) |
|
BTREE |
|
course |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
course |
1 |
COURSENO |
1 |
COURSENO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
course |
1 |
COURSE |
1 |
PROVIDERNO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
course |
1 |
PROVIDERNO |
1 |
PROVIDERNO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
course |
1 |
COURSENAME |
1 |
COURSENAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
course |
1 |
PUBTOWEB |
1 |
PUBTOWEB |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
course |
1 |
CLASSROOM |
1 |
CLASSROOM |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
course |
1 |
COURSETYPE |
1 |
COURSETYPE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
course |
1 |
CORRESPOND |
1 |
CORRESPOND |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
course |
1 |
FEDERAL |
1 |
FEDERAL |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
course |
1 |
ONLINE |
1 |
ONLINE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
course |
1 |
OTHER |
1 |
OTHER |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
course |
1 |
PROCESSING |
1 |
PROCESSING |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
course |
1 |
SEMINAR |
1 |
SEMINAR |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
course |
1 |
STATE |
1 |
STATE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back