How to create Relational Database?

[Troy Sorensen]

How to create database of orders (user, date, total, payment, etc) with one-to-many relationship with database of OrderDetails (products, prices, quantities). Would this be two collections within same database?

[Serhii Kulibaba]

Hi Troy,

Appery.io uses MongoDB that is not a relational database.
In your case it's better to create 2 collections in the same database, as you asked

[greg7178824]

I see that you guys have released RESTExpress. Is this able to link multiple tables with primary and foreign keys?

[Illya Stepanov]

Hi Troy,

This should be possible with RESTxpress with multiple tables.
But not I'm not sure what do you mean by: "primary and foreign keys"?

By the way here is our video about connecting RESTxpress in Appery.io.

[greg7178824]

Its Greg, but no problem

Thanks for the link however it did not address my concern

The basics of relational databases are to create a relationship between 2 tables with the one having a primary key and the corresponding table a foreign key. So like if I have a Customer table (customerId(PK), Name, age, orderID (FK)) and Orders table (OrderId(PK), item, number). Can I link the 2 tables so that when adding/editing/deleting records?

Thanks

[Maryna Brodina]

Hello!

Please use links from one collection to another http://devcenter.appery.io/documentat...

[greg7178824]

Thank you...

Pretty confusing though. Is there a video which explains it more clearly possibly?

[Evgene Karachevtsev]

Hello Greg,

Unfortunately we don't have such video. Please read the whole doc http://devcenter.appery.io/documentat...
there are different examples of working with Pointers.