Design Stores Database

[SirWellington]

Stores

Field	Type
Store ID	Int (Primary Key)
Store Name	String
Latitude	Double
Longitude	Double
Location	Geometry
Address ID	Int
City	String
State	String
Zip 5	Int

Users

Field	Type
User ID	Int (Primary Key)
First Name	String
Last Name	String
Email	String
EBT Card	String
EBT Benefits	Set
Zip	Int
Last Known Location	Geometry
Is Working	Boolean
Age	Int
Birtday	Date
Job Industry	String

Images

Field	Type
URL	String (Primary Key)
image	binary

[SirWellington]

The file we got from the government contains the following:

• Store Name
• Longitude
• Latitude
• Address Line 1
• Address Line 2
• City
• State
• Zip5
• Zip4
• County

[SirWellington]

Stores

• Store ID
• Store Name
• Latitude
• Longitude
• Location
• Address Line 1
• Address Line 2
• City
• State
• Zip 5
• Zip 4
• County

[SirWellington]

Field	Type
Store ID	Int
Store Name	String

[SirWellington]

Gonna save the images for another Ticket. One step at a time...

[cordhernandez]

roger that