lobby2 |
data_affiliatedorgs
data_agencies
data_foreignentity
data_issues
data_lobby
data_lobbyists
temp_status
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