lic

 

 

crime  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ID

int(11)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

AUTHORITY

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CASENO

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CRIMEDATE

date

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

CRIMETYPE

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

OFFENSE

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

OUTCOME

longtext

latin1_swedish_ci

YES

 

(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

crime

0

PRIMARY

1

TRANNO

A

8115

(NULL)

(NULL)

 

BTREE

 

crime

1

ID

1

ID

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

crime

1

TRANNO

1

TRANNO

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

crime

1

CRIMEDATE

1

CRIMEDATE

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

Back