lic

 

 

complain  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ID

int(11)

(NULL)

YES

MUL

0

 

select,insert,update,references

 

CID

char(6)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

ASSNRCVDT

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

BKRNOTREG

int(11)

(NULL)

YES

 

0

 

select,insert,update,references

 

BKRREGNO

int(11)

(NULL)

YES

 

0

 

select,insert,update,references

 

BROKERCITY

varchar(25)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CHECKNO

varchar(16)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CLOSEDDT

date

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

CMPAMTREC

decimal(8,2)

(NULL)

YES

 

0.00

 

select,insert,update,references

 

CMPNAMELF

varchar(50)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

CMPADDRESS

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPCELL

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPCITY

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPCODE

varchar(8)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPEMAIL

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPFAX

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPHOME

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPLNAME

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPFNAME

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPMI

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPST

char(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPTITLE

char(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPWORK

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPZIPCODE

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPTITLE2

char(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPFNAME2

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPMI2

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CMPLNAME2

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

COMPANY

varchar(60)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

DAYSTORSVL

int(11)

(NULL)

YES

 

0

 

select,insert,update,references

 

EXAMASSN

varchar(40)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EXAMASSNID

char(3)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

EXAMASSNDT

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

EXAMCMPTDT

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

FILENUMBER

int(11)

(NULL)

YES

MUL

0

 

select,insert,update,references

 

FinalNoticDt

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

FinalRespDt

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

FRSTLTTRDT

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

FISCALYR

char(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

INVSTASSN

varchar(40)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

InvstAssnID

char(3)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

InvstAssnDt

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

InvstCmptDt

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

NATOFRES

varchar(40)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

NORSPRFREN

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

OPENDT

date

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

OPENSTATUS

char(1)

latin1_swedish_ci

YES

MUL

O

 

select,insert,update,references

 

PAID

decimal(8,2)

(NULL)

YES

 

0.00

 

select,insert,update,references

 

PAIDDT

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

PERSON

varchar(40)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PRIORITY

varchar(10)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

QTRPT

decimal(8,2)

(NULL)

YES

 

0.00

 

select,insert,update,references

 

RECIVEDDT

date

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

RESOLVEDT

date

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

RESPANSREC

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

respFlwUpDt

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SUPPRECDT

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TRANNO

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

PERSON1

char(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PERSON2

char(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PERSON3

char(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PERSON4

char(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

MB1

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

MB2

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

MB3

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

LO1

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

LO2

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

BROKERUK

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

APSNTDT

date

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

APDUEDT

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

APRCVDT

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

APENAMT

decimal(8,2)

(NULL)

YES

 

0.00

 

select,insert,update,references

 

NOTES

longtext

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

NAME

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

INTEGERONE

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

INTEGER2

int(11)

(NULL)

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

complain

0

PRIMARY

1

TRANNO

A

5289

(NULL)

(NULL)

 

BTREE

 

complain

1

ID

1

ID

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

complain

1

PRIORITY

1

PRIORITY

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

complain

1

RECIVEDDT

1

RECIVEDDT

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

complain

1

RECEVEDDT

1

APSNTDT

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

complain

1

CID

1

CID

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

complain

1

RESOLVEDT

1

RESOLVEDT

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

complain

1

CLOSEDDT

1

CLOSEDDT

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

complain

1

CMPNAMELF

1

CMPNAMELF

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

complain

1

OPENSTATUS

1

OPENSTATUS

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

complain

1

COMPANY

1

COMPANY

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

complain

1

INVSTASSNID

1

InvstAssnID

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

complain

1

EXAMASSNID

1

EXAMASSNID

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

complain

1

FILENUMBER

1

FILENUMBER

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

complain

1

OPENDT

1

OPENDT

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

Back