Column |
Type |
Null |
Default |
Links to |
Comments |
Media (MIME) type |
Voter Number |
int(11) |
No |
|
Max value is 2,147,483,648 Unique field! |
|
|
Driver's License Number/State ID |
varchar(50) |
No |
|
Maximum length is 50 characters Unique field! |
|
|
Social Security Number |
varchar(11) |
No |
111-22-3333 |
Varchar can be fully indexed Unique field! |
|
|
First Name |
varchar(100) |
No |
Enter First Name! |
Maximum length is 100 characters |
|
|
Last Name |
varchar(100) |
No |
Enter Last Name! |
Maximum length is 100 characters |
|
|
Street Address |
varchar(100) |
No |
Enter Street here! |
Maximum number of characters is 100 |
|
|
Apt/Suite/Floor |
varchar(25) |
No |
Enter apt/suite/floor! |
Maximum number of characters is 25 |
|
|
City |
varchar(25) |
No |
Enter State Here! |
Maximum number of characters is 25 |
|
|
State |
varchar(25) |
No |
Enter State Here! |
Maximum 25 characters |
|
|
Zip Code |
varchar(15) |
No |
Enter Zip Code |
Maximum number of characters is 15. |
|
|
Politcal Party |
varchar(50) |
No |
Democrat/Republican/Democratic Socialist, etc. |
Maximum number of characters is 50! |
|
|
City/Town Council District |
varchar(50) |
No |
Enter City Council District! |
Maximum number of characters is 50! |
|
|
State Assembly District |
varchar(50) |
No |
Enter state assembly district |
Maximum number of characters is 50! |
|
|
State Senate District |
varchar(50) |
No |
Enter State Senate District! |
Maximum number of characters is 50! |
|
|
US House District |
varchar(50) |
No |
Enter US House Disctrict! |
Maximum number of characters is 50! |
|
|
Signature Picture-Less Than 64KB! |
blob |
No |
|
|
|
|
Voter Number |
Driver's License Number/State ID |
Social Security Number |
First Name |
Last Name |
Street Address |
Apt/Suite/Floor |
City |
State |
Zip Code |
Politcal Party |
City/Town Council District |
State Assembly District |
State Senate District |
US House District |
Signature Picture-Less Than 64KB! |