Modelling whether a service is open for the public or needs an appointment/application process etc

[adityasrini]

Suggest an amendment to the schema where a service_accessibility table or column (or a better named one) is introduced where details on whether the service is open for the public or needs an appointment/application process etc are made. On that note (and somewhat related to #187 if service_id is nullable in the new schema) does it make sense for this to be a separate table if service_id's are tied to organization_id's effectively making each service_accessibility entry unique entry for each service

[adityasrini]

UPDATE: For now I am going to repurpose the application_process column within the service table, but I am keeping the larger discussion of whether it makes sense to have separate tables for values that are often uniquely tied to service_id or service_at_location etc id's vs making additional columns within a given table

[greggish]

It might make sense to add a custom extension that does what you need, rather than repurposing a field that has a different intended purpose...

[mattweevu]

Hi Greg,

I'd love to learn more about this...

• Matt ᐧ

On Sun, May 6, 2018 at 1:38 PM, Greg Bloom notifications@github.com wrote:

It might make sense to add a custom extension that does what you need, rather than repurposing a field that has a different intended purpose...

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/openreferral/specification/issues/197#issuecomment-386902404, or mute the thread https://github.com/notifications/unsubscribe-auth/AKptVRgDNjA_fBSWCiS-SWjb-Gr3clwSks5tv0M4gaJpZM4TzRMT .

--

Matt Strauss

Co-founder & CEO

solve.is https://solvesmartcities.com/ | 312.310.7400

https://www.linkedin.com/company-beta/16164498/ https://www.facebook.com/solvesmartcities/ https://twitter.com/Solve_is

[greggish]

Hi @mattweevu ! do you mean learn more about custom field extensions? Check out the thread in #165

Or do you mean, learn more about Open Referral? you can normally join us (in our Slack) during office hours to chat on Fridays at noon EST. though the next two Fridays i will be occupied by workshops, so you can email me at bloom[at]openreferral[dot]org and we'll figure something out.