ruby on rails - Tables for Orders -

-

i'm having difficult time setting model/table relationships hobby project i'm working on. have order, order have 1 or many packages, each package has 1 or many products, each product have 1 area assigned to. there can multiple of same product on order , in same package each have different area , different quantity. i'm struggling determine how relationships set up.

at end of day need run report shows me order details listing packages on order , products , areas contained in each package. need report shows me order , sum of quantities each product on order (no packages on one). i'm using rails activerecord think believe there couple polymorphic relationships, i'm struggling identify them outside of simple "everything has one-to-many relationship" thinking. =)

can please me put these tables in intelligent manner? have searched similar schema diagrams without success , i've been working on couple of days , starting run together.

enter image description here

this basics of thinking of relationships, i'm not sure rails models like. seems every relationship orders down polymorphic.(?) how nest these relationships in rails?

i'm learning , many things, seems simple becomes lot more complicated when start writing code it. on right track? help.

i think need join tables.

an order can have many products; product can added many orders.

in case you'd have join table have 2 columns: primary keys order , product. 2 composite primary key.

i don't know area means in schema, perhaps suggestion break mental logjam you.


Comments

Post a Comment

Popular posts from this blog

javascript - Slick Slider width recalculation -

-
i'm trying add slide in panel on slick container css. carousel works except new width not being calculated when space has been added. recalibrate once advance next slide i'd happen each time panel opened or closed. i've tried adding both margin , padding, neither makes difference. ideas? https://jsfiddle.net/mhigley/dpf7mlpl/ html: <button type="button" id="button"><i class="fa fa-arrow-right"></i></button> <aside> <h2>slide in panel</h2> <ol> <li>list item</li> <li>list item</li> <li>list item</li> <li>list item</li> <li>list item</li> </ol> </aside> <main role="main"> <div class="sections"> <section> <article> <h2>first slide</h2> <p>lorem ipsum d...
Read more

jsf - PrimeFaces Datatable - What is f:facet actually doing? -

-
looking through primefaces code in app noticed following line: <f:facet name="header">#{trainsearch.traincount} trains</f:facet> it looks overriding header, makes sense, can explain me in little more detail? what happening line of code? complete code listed below: <p:datatable id = "results" value = "#{trainsearch.trains}" var = "train" rendered="#{not empty trainsearch.trains}" styleclass = "train-search-table horizontal-border"> <f:facet name="header">#{trainsearch.traincount} trains</f:facet> <p:column headertext = "train id"> <p:panelgrid columns="1" styleclass = "train-id-grid" layout = "grid"> <h:outputtext styleclass = "train-id-label" value="#{train.traini}"/> <h:outputtex...
Read more

angular2 services - Angular 2 RC 4 Http post not firing -

-
i trying fire post request app , it's not working, tried multiple ways. don't see request being fired under network tab in chrome. not sure problem is, appreciated. import { injectable } '@angular/core'; import { http, headers } '@angular/http'; @injectable() export class userservice{ private _url="users"; constructor(private _http: http){ } checkifusernameexists(username){ return this._http.get(this._url+"/"+username) .map(response => response.json()) } createuser(user){ let headers = new headers(); headers.append('content-type', 'application/json') console.log(json.stringify(user)); return this._http.post(this._url, json.stringify(user),{headers: headers}) .map(response => response.json()) } } first need capture error , solve error: this._http.post(this._url, json.stringify(user),{headers: headers}) .subscribe( ...
Read more