lobby2

 

 
data_affiliatedorgs  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

filing_id

varchar(45)

latin1_swedish_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

affiliated_orgname

varchar(255)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

affiliated_orgcountry

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

affiliated_orgppbcountry

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

id

int(10) unsigned

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

source_file

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

timestamp

timestamp

(NULL)

NO

 

CURRENT_TIMESTAMP

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

data_affiliatedorgs

0

PRIMARY

1

id

A

22164

(NULL)

(NULL)

 

BTREE

 

data_affiliatedorgs

1

Index_2

1

filing_id

A

22164

(NULL)

(NULL)

 

BTREE

 

Back

 
data_agencies  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

filing_id

varchar(45)

latin1_swedish_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

gov_entity_name

varchar(255)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

id

int(10) unsigned

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

source_file

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

timestamp

timestamp

(NULL)

NO

 

CURRENT_TIMESTAMP

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

data_agencies

0

PRIMARY

1

id

A

874730

(NULL)

(NULL)

 

BTREE

 

data_agencies

1

Index_2

1

filing_id

A

874730

(NULL)

(NULL)

 

BTREE

 

Back

 
data_foreignentity  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

filing_id

varchar(45)

latin1_swedish_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

foreign_entity_name

varchar(255)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

foreign_entity_country

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

foreign_entity_ppbcountry

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

foreign_entity_status

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

foreign_entity_ownpercentage

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

foreign_entity_contribution

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

id

int(10) unsigned

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

source_file

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

timestamp

timestamp

(NULL)

NO

 

CURRENT_TIMESTAMP

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

data_foreignentity

0

PRIMARY

1

id

A

11311

(NULL)

(NULL)

 

BTREE

 

data_foreignentity

1

Index_2

1

filing_id

A

11311

(NULL)

(NULL)

 

BTREE

 

Back

 
data_issues  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

filing_id

varchar(45)

latin1_swedish_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

issue_code

varchar(45)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

specific_issue

blob

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

id

int(10) unsigned

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

source_file

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

timestamp

timestamp

(NULL)

NO

 

CURRENT_TIMESTAMP

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

data_issues

0

PRIMARY

1

id

A

684616

(NULL)

(NULL)

 

BTREE

 

data_issues

1

filing_id

1

filing_id

A

684616

(NULL)

(NULL)

 

BTREE

 

data_issues

1

iss_code

1

issue_code

A

21

(NULL)

(NULL)

YES

BTREE

 

Back

 
data_lobby  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

filing_id

varchar(45)

latin1_swedish_ci

NO

MUL

 

 

select,insert,update,references

 

year

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

received

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

amount

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

type

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

period

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

registrant_id

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

registrant_name

varchar(255)

latin1_bin

YES

 

(NULL)

 

select,insert,update,references

 

address

blob

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

registrant_country

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

registrant_ppbcountry

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

client_name

varchar(255)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

client_id

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

client_status

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

contact_fullname

varchar(45)

latin1_bin

YES

 

(NULL)

 

select,insert,update,references

 

client_country

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

client_ppbcountry

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

client_state

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

client_ppbstate

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

id

int(10) unsigned

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

source_file

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

timestamp

timestamp

(NULL)

NO

 

CURRENT_TIMESTAMP

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

data_lobby

0

PRIMARY

1

id

A

399852

(NULL)

(NULL)

 

BTREE

 

data_lobby

1

filing_id

1

filing_id

A

399852

(NULL)

(NULL)

 

BTREE

 

Back

 
data_lobbyists  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

filing_id

varchar(45)

latin1_swedish_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

lobbyist_name

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

lobbyist_status

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

lobbyist_indicator

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

official_position

varchar(255)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

id

int(10) unsigned

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

source_file

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

timestamp

timestamp

(NULL)

NO

 

CURRENT_TIMESTAMP

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

data_lobbyists

0

PRIMARY

1

id

A

1085092

(NULL)

(NULL)

 

BTREE

 

data_lobbyists

1

filing_id

1

filing_id

A

1085092

(NULL)

(NULL)

 

BTREE

 

Back

 
temp_status  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(10) unsigned

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

status_message

blob

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

timestamp

timestamp

(NULL)

NO

 

CURRENT_TIMESTAMP

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

temp_status

0

PRIMARY

1

id

A

895

(NULL)

(NULL)

 

BTREE

 

Back