lic |
educ |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
COURSEDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
COURSENAME |
varchar(60) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
HOURS |
decimal(8,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
PROVIDER |
varchar(50) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
PROVIDERNO |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
TCHGDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TRANNO |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
COURSENO |
char(15) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
COURSETYPE |
char(6) |
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 |
educ |
0 |
PRIMARY |
1 |
TRANNO |
A |
78306 |
(NULL) |
(NULL) |
|
BTREE |
|
educ |
1 |
id |
1 |
ID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
educ |
1 |
PROVIDER |
1 |
PROVIDER |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
educ |
1 |
TRANNO |
1 |
TRANNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
educ |
1 |
EDUC |
1 |
PROVIDERNO |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back