CodeforNRV / virginia-childcare

Project around maintaining and displaying a database of childcare facilities in (Southwest) Virginia
MIT License
0 stars 0 forks source link

Design the DB #1

Open nealf opened 7 years ago

nealf commented 7 years ago

Using the spreadsheet as the starting point, design the database that will be implemented in Postgres

nealf commented 7 years ago
Spreadsheet DSS Website
Name Name
Address Address
Website URL _
Phone Phone
WIA area _
County/City _
Sub-category Facility Type
Age category _
Age range Ages
License type License type
Total capacity Capacity
Estimated Capacity for Children
Younger than School Age
_
Cost _
Hours of operation Hours
Latitude/Longitude _
Notes _
_ Administrator
_ Inspector
_ Inspector phone
_ Inspection - Date
_ Inspection - Complaint related
_ Inspection - Violations
_ Inspection - Areas reviewed
_ Inspection - Comments
_ Inspection - Violations
Standard number
Description
* Plan of correction