lic

 

 
company  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

COID

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

LICID

int(11)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

ADDRESS1

varchar(34)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ADDRESS2

varchar(34)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ASSUMNAME

varchar(40)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CITY

varchar(24)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CONTACT

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

employerno

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

entitytype

char(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FAX

varchar(12)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FIRM

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FIRMTYPE

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

LASTCHGDAT

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SPONBKID

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ST

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TEL

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TOLLFREE

varchar(12)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

USERINIT

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ZIPCODE

varchar(12)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FHAID

varchar(12)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

VAID

varchar(12)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

OTHERID

varchar(12)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

LOANPROD

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

REPORTYEAR

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

MBSTATUS

varchar(2)

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

company

0

PRIMARY

1

COID

A

60361

(NULL)

(NULL)

 

BTREE

 

company

1

licid

1

LICID

A

60361

(NULL)

(NULL)

YES

BTREE

 

company

1

COID

1

COID

A

60361

(NULL)

(NULL)

 

BTREE

 

Back