![]() Every record will contain a staff member + an event. When we assign staff members to an event, we'll be creating individual records for each assignment. This data table has a one-to-one connection to both Events and Staff. Let's add a third data table called "Schedule". Additionally - after staff members have worked multiple events, we won't be able to run any calculations on how much each staff member has earned over a period of time, or by role. We can't specify which staff member gets paid a specific amount. You'll be able to see details about the event, and the assigned staff.īut - what if we want to add data specific to each staff member? For example, payroll, staff evaluations, or shift times. This method can work - depending on what actions you want to perform in your app. We can add an Event record - a Concert in the Park - and then add staff members to the record in our one-to-many connection field. We could build this with just two data tables. ![]() We have an app to manage Event scheduling. This will make sense in a minute, hang on. A join table is a data table that has multiple outgoing connections - connecting multiple data tables to one data table. Imagine connecting two spreadsheets together so you can access data from both at the same time.īack to join tables. It's a real rockstar □.Ī relational database is simply multiple data tables, consisting of rows and columns, that connect to each other in order to provide a pathway to see data across multiple data tables. Tadabase is a relational database, the most common database model. There's a few basics to cover and then we'll get right into a real life example.įirst, what is a join table? To understand what a join table is, we need to understand what database model Tadabase uses. Good news! I'm not going to get into super complex stuff here. When we use join tables, we allow for greater flexibility, data integrity, and scalability to our data base. While the example discussed here is simple, join tables are incredibly powerful and useful no matter how complex your app is.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |