Meeting Title: ABC Database Sync Date: 2025-08-27 Meeting participants: Casie Aviles, Amber Lin, Awaish Kumar
WEBVTT
1 00:00:42.200 ⇒ 00:00:43.460 Amber Lin: Hello!
2 00:00:44.810 ⇒ 00:00:47.729 Amber Lin: Thanks so much for joining.
3 00:00:47.730 ⇒ 00:00:48.650 Awaish Kumar: Oh, yep.
4 00:00:49.250 ⇒ 00:01:00.259 Amber Lin: We met a bit earlier on the… let me pull up the thick jam, and then we can discuss there. Did you have a chance to look over it?
5 00:01:00.640 ⇒ 00:01:01.690 Awaish Kumar: Oh my gosh.
6 00:01:01.790 ⇒ 00:01:03.299 Awaish Kumar: I just opened it.
7 00:01:04.569 ⇒ 00:01:05.289 Amber Lin: Yeah.
8 00:01:05.430 ⇒ 00:01:06.520 Awaish Kumar: One is, ….
9 00:01:07.840 ⇒ 00:01:11.660 Amber Lin: … Okay.
10 00:01:13.750 ⇒ 00:01:18.150 Amber Lin: Let me share screen. Well, Casey, do you want to talk over it?
11 00:01:18.620 ⇒ 00:01:21.630 Casie Aviles: Yeah, yeah, sure, … I’ll go up here.
12 00:01:28.800 ⇒ 00:01:34.269 Casie Aviles: Okay, so… basically, we are… so the goal here is we have
13 00:01:34.550 ⇒ 00:01:39.400 Casie Aviles: All these source spreadsheets, which is… which are the screenshots that we have above.
14 00:01:40.190 ⇒ 00:01:41.240 Casie Aviles: And…
15 00:01:41.560 ⇒ 00:01:46.250 Casie Aviles: The idea is we want to start migrating them into a database.
16 00:01:47.350 ⇒ 00:01:48.480 Casie Aviles: So…
17 00:01:50.030 ⇒ 00:01:57.780 Casie Aviles: As you can see, there’s, like, different kinds of formats, and this is primarily suitable for a spreadsheet-style format.
18 00:01:58.560 ⇒ 00:02:00.970 Casie Aviles: But even then, there’s a lot of things that…
19 00:02:01.170 ⇒ 00:02:05.169 Casie Aviles: Are not standard… standard to how these are structured?
20 00:02:05.820 ⇒ 00:02:06.400 Amber Lin: But….
21 00:02:06.400 ⇒ 00:02:09.810 Casie Aviles: So, the idea is, we were proposing
22 00:02:10.060 ⇒ 00:02:18.749 Casie Aviles: Design for how we would structure this, these, all of this data from the sheets into a…
23 00:02:18.870 ⇒ 00:02:25.099 Casie Aviles: database, and… at the moment, what we have, …
24 00:02:25.650 ⇒ 00:02:30.280 Casie Aviles: What we have proposed is something like this, which is a relational format.
25 00:02:30.460 ⇒ 00:02:35.900 Casie Aviles: So if you go over here, … to this section.
26 00:02:36.250 ⇒ 00:02:37.840 Amber Lin: It’s associated with stolen.
27 00:02:37.840 ⇒ 00:02:39.530 Casie Aviles: So, we have…
28 00:02:39.910 ⇒ 00:02:48.399 Casie Aviles: sort of, separation in terms of, like, the location, right? We want to separate the, the locations as one table.
29 00:02:49.150 ⇒ 00:02:51.620 Casie Aviles: And then we have the people as…
30 00:02:53.050 ⇒ 00:02:56.560 Casie Aviles: Another table, and then they would be kind of linked.
31 00:02:57.450 ⇒ 00:03:01.479 Casie Aviles: In, in, with this, assignments table?
32 00:03:02.410 ⇒ 00:03:10.959 Casie Aviles: So… Yeah, I guess those are some of the things we have in mind for the proposal, and…
33 00:03:11.490 ⇒ 00:03:16.119 Casie Aviles: I, I guess for questions, regarding this, like.
34 00:03:18.080 ⇒ 00:03:25.820 Casie Aviles: does this… what, like, what, in general, what are your thoughts regarding this kind of relational design structure?
35 00:03:26.550 ⇒ 00:03:30.719 Awaish Kumar: But, is… yeah, first off, first, my first question is….
36 00:03:30.830 ⇒ 00:03:32.570 Amber Lin: That, ….
37 00:03:33.550 ⇒ 00:03:37.879 Awaish Kumar: Is the problem only with standardization, or…?
38 00:03:38.150 ⇒ 00:03:48.280 Awaish Kumar: Do you need, … better… We, like… like, is the data, a lot?
39 00:03:48.800 ⇒ 00:03:55.030 Awaish Kumar: Are these sheets, like, have, I don’t know, thousands of rows, or is it just few rows?
40 00:03:56.090 ⇒ 00:04:02.050 Amber Lin: No, I think each one has probably 700 rows each. I think each of them are less than a thousand.
41 00:04:04.510 ⇒ 00:04:05.130 Casie Aviles: Yes.
42 00:04:05.850 ⇒ 00:04:08.810 Amber Lin: some QSR, or usually greater rate.
43 00:04:08.810 ⇒ 00:04:15.309 Awaish Kumar: Yeah, and because, So, like, ERD diagrams are good.
44 00:04:15.790 ⇒ 00:04:19.359 Awaish Kumar: When we want to have a designer system.
45 00:04:19.839 ⇒ 00:04:26.469 Awaish Kumar: Which is, where we have a lot of data, and we want to optimize the relationships.
46 00:04:26.810 ⇒ 00:04:35.630 Awaish Kumar: But I’m… if we just want to standardize things, … Maybe we… like…
47 00:04:36.820 ⇒ 00:04:48.660 Awaish Kumar: really need this, because if we make a relational database and split it like this, then you have to maintain all these tables, right?
48 00:04:48.870 ⇒ 00:04:52.410 Casie Aviles: So if there’s an assignment, then you have to make updates and….
49 00:04:52.640 ⇒ 00:04:55.969 Awaish Kumar: For example, an inspector sheet, in people’s sheet.
50 00:04:56.210 ⇒ 00:05:00.399 Awaish Kumar: If the new people join, and the assignments, or…
51 00:05:00.550 ⇒ 00:05:02.770 Awaish Kumar: And location, and all of these.
52 00:05:03.740 ⇒ 00:05:08.050 Awaish Kumar: Technicians, like, all of these table has to be Pro.
53 00:05:09.430 ⇒ 00:05:11.080 Awaish Kumar: updated.
54 00:05:11.990 ⇒ 00:05:13.790 Awaish Kumar: To make those changes.
55 00:05:13.930 ⇒ 00:05:16.560 Amber Lin: Like, the simple thing is that….
56 00:05:16.560 ⇒ 00:05:21.849 Awaish Kumar: we keep the, flat… flat tables, right? …
57 00:05:24.010 ⇒ 00:05:32.769 Awaish Kumar: like, which, like, which are relatable with the kind of work you are doing? I’m… I’m… I have little context in the…
58 00:05:32.950 ⇒ 00:05:39.960 Awaish Kumar: Like… In the master inspector Sheet, like, what is that? If you can just briefly…
59 00:05:40.560 ⇒ 00:05:43.179 Awaish Kumar: Define it, like, what kind of data, yes.
60 00:05:43.880 ⇒ 00:05:49.680 Casie Aviles: So, this is primarily just a table of… The inspector, so…
61 00:05:49.980 ⇒ 00:05:53.989 Casie Aviles: Usually, what the CSRs would ask is.
62 00:05:54.340 ⇒ 00:06:03.420 Casie Aviles: Can you give me who… who are the inspectors for this particular zip code? So it will be… so, yeah, they will… the AI would look….
63 00:06:03.420 ⇒ 00:06:06.079 Awaish Kumar: Inspector. Inspector a person?
64 00:06:06.550 ⇒ 00:06:20.759 Casie Aviles: Yes, yes, it’s an inspector, it’s a person, and they can have, like, sub… I’m not sure if that’s the right term, but they can have sub roles. So they are an inspector, and then they can be assigned as either a residential pest inspector.
65 00:06:22.180 ⇒ 00:06:25.140 Awaish Kumar: with Thermite Inspector, or they could do other….
66 00:06:25.140 ⇒ 00:06:30.400 Casie Aviles: Kinds of things, so… Kind of the more general category is inspector.
67 00:06:30.520 ⇒ 00:06:33.219 Casie Aviles: And then there’s, like, another subcategory.
68 00:06:34.140 ⇒ 00:06:36.019 Amber Lin: But I wouldn’t have hit page anyway. She was under….
69 00:06:36.020 ⇒ 00:06:38.919 Awaish Kumar: For each zip code, you have inspectors.
70 00:06:39.320 ⇒ 00:06:39.880 Awaish Kumar: Yes.
71 00:06:40.160 ⇒ 00:06:42.199 Awaish Kumar: And the general ask is that
72 00:06:42.360 ⇒ 00:06:48.880 Awaish Kumar: They ask you for a list of inspectors in a given zip code.
73 00:06:49.030 ⇒ 00:06:59.019 Casie Aviles: Yes, yes, exactly. And sometimes they ask, like, who is the residential pest inspector for 78613, for example? So, it’s more specific, but…
74 00:06:59.580 ⇒ 00:07:01.000 Casie Aviles: Yeah.
75 00:07:01.280 ⇒ 00:07:08.139 Awaish Kumar: Okay, and then, … How that connects with, for example, a technician sheet?
76 00:07:09.350 ⇒ 00:07:22.730 Casie Aviles: The technician’s sheet is a separate sheet, but the idea is it also… we… they also ask for a… for the zip… like, for the technicians, given a zip code. So instead of inspectors, they would ask
77 00:07:22.860 ⇒ 00:07:29.880 Casie Aviles: who are the technicians available for this zip code? So, kind of, if I understand correctly, it’s the same kind of
78 00:07:30.150 ⇒ 00:07:45.170 Casie Aviles: categorization, where the general category is technician in this case, and then the subcategory would be either are they a maintenance technician, are they a mosquito suppression technician? Yeah, that’s…
79 00:07:45.510 ⇒ 00:07:46.950 Casie Aviles: How it works.
80 00:07:47.780 ⇒ 00:07:56.120 Awaish Kumar: And then, how it is going to be updated, for example, if you move out of sheets to the database.
81 00:07:56.560 ⇒ 00:08:00.449 Awaish Kumar: How… how the new entries will be added?
82 00:08:01.530 ⇒ 00:08:02.499 Casie Aviles: For that.
83 00:08:02.870 ⇒ 00:08:22.449 Amber Lin: So currently, they get all the updates from the service manager, so usually the service manager either submits a Google form, which they should do, or they send an email, and then Janice and Yvette, who’s the trainers on the customer service side, they go ahead and update the spreadsheets.
84 00:08:22.450 ⇒ 00:08:33.049 Amber Lin: So the update’s not coming from them, they’re coming from the service managers, so we would be able to get them directly to update, the database if we need to.
85 00:08:33.380 ⇒ 00:08:37.400 Awaish Kumar: Yeah, okay, they won’t do that… do that.
86 00:08:38.380 ⇒ 00:08:46.590 Awaish Kumar: Databases is… in the… to update the database, it’s like running a query. I’m not sure a manager…
87 00:08:46.860 ⇒ 00:08:52.270 Awaish Kumar: Nice. Kind of will be okay with doing it, but he… he can submit the form, and….
88 00:08:52.710 ⇒ 00:08:53.199 Amber Lin: In the back end.
89 00:08:53.200 ⇒ 00:08:56.569 Awaish Kumar: And we can run a script to read the forms and….
90 00:08:56.810 ⇒ 00:08:58.159 Amber Lin: I can find that song.
91 00:08:58.160 ⇒ 00:09:00.490 Awaish Kumar: Some data can be loaded into a sheet, and….
92 00:09:00.540 ⇒ 00:09:03.739 Amber Lin: From there, we can put it in… it back in the….
93 00:09:03.920 ⇒ 00:09:05.210 Awaish Kumar: database.
94 00:09:07.390 ⇒ 00:09:08.170 Casie Aviles: Okay.
95 00:09:08.640 ⇒ 00:09:12.740 Awaish Kumar: And, but, yeah, like, the design you have.
96 00:09:13.320 ⇒ 00:09:19.260 Awaish Kumar: it’s kind of okay, like, we have zip codes, which I… what I understand from your
97 00:09:19.370 ⇒ 00:09:26.930 Awaish Kumar: description, Casey, is that the zip codes are the primary Oh, Yeah, I know.
98 00:09:26.930 ⇒ 00:09:28.869 Casie Aviles: Yeah. Feeding out.
99 00:09:28.870 ⇒ 00:09:33.720 Awaish Kumar: Like, where they are, like, most of the queries are based on zip codes, right?
100 00:09:34.010 ⇒ 00:09:35.300 Casie Aviles: Yes, yes.
101 00:09:36.250 ⇒ 00:09:39.629 Awaish Kumar: And from the zip codes, we have, like,
102 00:09:39.960 ⇒ 00:09:44.360 Awaish Kumar: We can have, then, the best people, right?
103 00:09:45.010 ⇒ 00:09:49.879 Awaish Kumar: people and a list of zip code. There, they are, like, primary tables, and then
104 00:09:50.010 ⇒ 00:09:57.400 Awaish Kumar: Then they can have as a… these two fields can be a foreign key into assignments, … Kyle.
105 00:09:58.570 ⇒ 00:10:07.350 Awaish Kumar: Similarly, Inspector, and assignments, are they also, like, unique, or…?
106 00:10:07.520 ⇒ 00:10:11.920 Awaish Kumar: Can… can they… are they, like, fixed, or they can be changed?
107 00:10:13.040 ⇒ 00:10:20.270 Amber Lin: If they change, they’ll send in an update. Usually, once it’s signed, it will be fixed, unless they submit, like, a form to change it.
108 00:10:21.730 ⇒ 00:10:24.880 Awaish Kumar: Okay, foreign… okay, on a zip?
109 00:10:25.210 ⇒ 00:10:28.210 Awaish Kumar: A person is assigned on some task.
110 00:10:28.360 ⇒ 00:10:30.970 Awaish Kumar: Assignment means a task, right?
111 00:10:32.430 ⇒ 00:10:33.140 Casie Aviles: Yes.
112 00:10:33.140 ⇒ 00:10:35.089 Amber Lin: Go ahead, sorry.
113 00:10:35.090 ⇒ 00:10:38.949 Casie Aviles: Yeah, assignment is whether, if they’re an inspector, or…
114 00:10:39.080 ⇒ 00:10:42.840 Casie Aviles: If they’re a residential pests assigned to a particular zip code.
115 00:10:43.070 ⇒ 00:10:52.190 Casie Aviles: But another thing, I guess, that is also worth considering is, like, if they have multiple Rose…
116 00:10:55.460 ⇒ 00:10:59.460 Casie Aviles: So, yeah, I guess, … The, the suggestion….
117 00:10:59.460 ⇒ 00:11:01.359 Awaish Kumar: Or a person can be assigned
118 00:11:02.200 ⇒ 00:11:04.769 Awaish Kumar: It can have different roles as well, right?
119 00:11:04.920 ⇒ 00:11:05.960 Casie Aviles: Yes, yes.
120 00:11:07.210 ⇒ 00:11:10.510 Amber Lin: about this. Try an ultra-down off of mid-bus.
121 00:11:10.510 ⇒ 00:11:11.669 Awaish Kumar: Okay, ….
122 00:11:12.670 ⇒ 00:11:16.470 Amber Lin: And what is the… if you are going to manage this database.
123 00:11:16.640 ⇒ 00:11:21.939 Awaish Kumar: Then, what is the ways to… Hmm, for example….
124 00:11:23.390 ⇒ 00:11:26.600 Amber Lin: Like, from form, you will get a….
125 00:11:26.960 ⇒ 00:11:35.480 Awaish Kumar: this assignment’s also going to come from forms? Like, somebody will be submitting a form, right? This person needs to be…
126 00:11:35.580 ⇒ 00:11:37.439 Awaish Kumar: Assigned on this loan, right?
127 00:11:37.850 ⇒ 00:11:41.559 Amber Lin: Let me go try and find the form they shared with me.
128 00:11:41.850 ⇒ 00:11:44.450 Amber Lin: … Let’s see.
129 00:11:44.450 ⇒ 00:11:50.920 Awaish Kumar: Okay, and then if somebody… Hmm… at, ….
130 00:11:52.020 ⇒ 00:11:53.150 Amber Lin: Thanks, Jeff.
131 00:11:54.910 ⇒ 00:11:56.770 Awaish Kumar: And how service area….
132 00:11:57.300 ⇒ 00:11:57.899 Amber Lin: That’s outlaw.
133 00:11:57.900 ⇒ 00:12:02.079 Awaish Kumar: Relates with assignments, or is… that is just a separate thing?
134 00:12:03.540 ⇒ 00:12:21.520 Amber Lin: Service areas is if ABC even provides service in that zip code, so I… I personally think this should be before even… before we ask or get the inspector or technicians for that zip code, we have to make sure that we even service that zip code.
135 00:12:22.710 ⇒ 00:12:23.550 Awaish Kumar: Okay.
136 00:12:25.060 ⇒ 00:12:31.580 Amber Lin: Let me… Can I quickly share screen and show you the form?
137 00:12:31.800 ⇒ 00:12:32.580 Casie Aviles: Sure, sure.
138 00:12:32.910 ⇒ 00:12:34.090 Awaish Kumar: Okay, crap.
139 00:12:34.090 ⇒ 00:12:49.089 Amber Lin: Yeah, so this is the form they have for the new, like, inspector changes. So they would say the name, and then add in the branches. So, usually they’re… they are assigned to a…
140 00:12:50.160 ⇒ 00:12:56.809 Amber Lin: like, a group of zip codes in… under the branch, so you… they would sometimes just specify,
141 00:12:58.300 ⇒ 00:13:01.869 Amber Lin: Sorry, going in order, and then quadrants…
142 00:13:02.430 ⇒ 00:13:05.790 Amber Lin: I’m not sure what that one is. Quadrants would be…
143 00:13:05.790 ⇒ 00:13:28.589 Amber Lin: they will probably list out the zip codes here, or just name, say, all of Austin North zip codes, and that’s where the quadrants come in useful. And then they will select what this person can service, can do estimates for. So we would add this person to, these… these zip codes under
144 00:13:28.590 ⇒ 00:13:32.140 Amber Lin: These services, so we’ll add them to that.
145 00:13:32.830 ⇒ 00:13:36.340 Amber Lin: And then, that’s… that’s other things.
146 00:13:36.610 ⇒ 00:13:40.059 Amber Lin: I don’t think this affects us yet.
147 00:13:40.160 ⇒ 00:13:45.299 Amber Lin: Mostly, what we care about are just the services and the zip codes, and the name of the person.
148 00:13:47.080 ⇒ 00:13:47.830 Awaish Kumar: Okay.
149 00:13:48.210 ⇒ 00:13:48.890 Amber Lin: Yup.
150 00:13:49.070 ⇒ 00:13:52.170 Amber Lin: We can also change the swarm. …
151 00:13:52.480 ⇒ 00:13:58.149 Amber Lin: As long as we tell Yvette, I think she’s open for us changing this form to make it easier for us.
152 00:13:58.870 ⇒ 00:14:00.160 Awaish Kumar: Okay, ….
153 00:14:00.490 ⇒ 00:14:01.130 Amber Lin: Yep.
154 00:14:01.780 ⇒ 00:14:06.020 Awaish Kumar: And, okay, so I will go back to databases and do a…
155 00:14:06.620 ⇒ 00:14:11.460 Awaish Kumar: Yeah, and if… yeah, so the ERD covers…
156 00:14:12.040 ⇒ 00:14:21.540 Awaish Kumar: So, if I can say it in a, like, in a sentence, so, like, ABC provides… services.
157 00:14:22.300 ⇒ 00:14:26.309 Awaish Kumar: … In different zip codes.
158 00:14:26.500 ⇒ 00:14:31.459 Awaish Kumar: And each of those And… and ABC implies the…
159 00:14:31.890 ⇒ 00:14:36.690 Awaish Kumar: People who can provide those services.
160 00:14:36.880 ⇒ 00:14:39.240 Awaish Kumar: In some areas.
161 00:14:39.760 ⇒ 00:14:43.179 Awaish Kumar: And they have defined the people.
162 00:14:43.470 ⇒ 00:14:51.230 Awaish Kumar: While working in a specific… Zip code by… by… service, right?
163 00:14:53.120 ⇒ 00:14:53.650 Casie Aviles: Yes.
164 00:14:54.210 ⇒ 00:15:05.639 Awaish Kumar: And then, … So, … Inspector sheet… Does that… zip code and assignments…
165 00:15:05.830 ⇒ 00:15:08.599 Awaish Kumar: Does that relate with, any of…
166 00:15:09.220 ⇒ 00:15:11.930 Awaish Kumar: Like, I’m seeing the specter sheet table.
167 00:15:12.070 ⇒ 00:15:14.479 Awaish Kumar: So does that relate with any…
168 00:15:15.540 ⇒ 00:15:18.069 Awaish Kumar: Yeah, this relates with assignments, right?
169 00:15:18.240 ⇒ 00:15:20.819 Awaish Kumar: So we… we are saying on this zip code.
170 00:15:21.410 ⇒ 00:15:24.770 Awaish Kumar: There are 3 different assignments, like, 3 people are…
171 00:15:24.950 ⇒ 00:15:28.289 Awaish Kumar: Can provide these services in this zip code, right?
172 00:15:28.740 ⇒ 00:15:29.460 Amber Lin: Yes.
173 00:15:31.630 ⇒ 00:15:33.700 Awaish Kumar: And what is Tricia’s….
174 00:15:34.480 ⇒ 00:15:39.350 Amber Lin: Similar thing. So, it’s just, they need to inspect and estimate
175 00:15:39.520 ⇒ 00:15:43.719 Amber Lin: What’s needed before the actual person goes and fixes it.
176 00:15:43.920 ⇒ 00:15:45.930 Amber Lin: So it’s two services. They’re different.
177 00:15:45.930 ⇒ 00:15:46.500 Awaish Kumar: Okay.
178 00:15:48.940 ⇒ 00:15:49.690 Awaish Kumar: Pink.
179 00:15:50.170 ⇒ 00:15:53.309 Awaish Kumar: Okay, two different categories of services.
180 00:15:55.790 ⇒ 00:15:59.889 Awaish Kumar: Okay, yeah, like, the… Is there anything I’m missing?
181 00:16:02.440 ⇒ 00:16:07.450 Amber Lin: … Do we address the service areas? That’s… that’s just if we….
182 00:16:07.450 ⇒ 00:16:08.120 Awaish Kumar: God.
183 00:16:08.120 ⇒ 00:16:08.930 Amber Lin: Even provide certain.
184 00:16:08.930 ⇒ 00:16:14.619 Awaish Kumar: That’s just the list of services. Yeah. So, I’m just concerned about how we are going to maintain this.
185 00:16:14.730 ⇒ 00:16:15.799 Awaish Kumar: ERD, if you are.
186 00:16:15.800 ⇒ 00:16:16.410 Amber Lin: Agree.
187 00:16:16.410 ⇒ 00:16:23.360 Awaish Kumar: maintain this database, because from the forms, Home.
188 00:16:24.090 ⇒ 00:16:34.470 Awaish Kumar: We need to have a script which basically translates our sheet, the form with the… having, like, with the business logic.
189 00:16:34.980 ⇒ 00:16:46.730 Awaish Kumar: And then update all these entries in the database. If a request comes, yeah, I also have to handle if a request comes to, like, delete some person… if some person left.
190 00:16:46.820 ⇒ 00:16:55.740 Awaish Kumar: Or if a service, a person is no longer in a zip code, he moved from one zip code to another, so these kind of things, how…
191 00:16:56.150 ⇒ 00:16:57.040 Awaish Kumar: Under that.
192 00:16:57.210 ⇒ 00:17:01.150 Awaish Kumar: But apart from that, I think, design is…
193 00:17:01.420 ⇒ 00:17:04.619 Awaish Kumar: And good, like, we need to make the connections where it…
194 00:17:04.720 ⇒ 00:17:12.299 Awaish Kumar: Wherever they’re left, but otherwise, the design is good. We don’t have, I don’t… yeah, we don’t have any…
195 00:17:13.480 ⇒ 00:17:20.759 Awaish Kumar: Like, the data is really small, so, if… yeah, like, it, it make…
196 00:17:20.930 ⇒ 00:17:24.689 Awaish Kumar: Makes sense to have fewer table, if you could.
197 00:17:25.339 ⇒ 00:17:30.899 Awaish Kumar: If you could maybe wanna merge some tables, that would be… Okay, as well.
198 00:17:30.900 ⇒ 00:17:32.820 Amber Lin: That makes sense.
199 00:17:33.400 ⇒ 00:17:37.670 Amber Lin: … Hmm.
200 00:17:40.040 ⇒ 00:17:43.909 Amber Lin: Okay, so the… what’s the assignment table there? Is that a….
201 00:17:43.910 ⇒ 00:17:49.620 Awaish Kumar: For example, inspector sheet and technicians, although these are two different tables, but.
202 00:17:49.620 ⇒ 00:17:53.650 Amber Lin: They both have same structure, same kind of fields.
203 00:17:53.650 ⇒ 00:17:56.169 Awaish Kumar: We could just merge them.
204 00:17:56.170 ⇒ 00:18:07.990 Amber Lin: I think we can even merge all three of those, inspector, technicians, and service areas. This way, we can, before we check the inspectors, we’ll just check, oh, this zip code, we said we don’t service, this.
205 00:18:08.670 ⇒ 00:18:09.210 Awaish Kumar: Yeah.
206 00:18:09.490 ⇒ 00:18:11.100 Amber Lin: So we can merge all three.
207 00:18:11.930 ⇒ 00:18:13.370 Amber Lin: If needed.
208 00:18:14.020 ⇒ 00:18:15.849 Awaish Kumar: Yeah, these can be just one table.
209 00:18:16.290 ⇒ 00:18:17.989 Amber Lin: Okay, that’s good.
210 00:18:20.640 ⇒ 00:18:28.919 Awaish Kumar: And then the other, yeah… Other three, low-code, domain, ….
211 00:18:29.720 ⇒ 00:18:31.740 Amber Lin: I’ve grappled. I can be a little bit more….
212 00:18:31.740 ⇒ 00:18:32.570 Awaish Kumar: remember the first….
213 00:18:33.020 ⇒ 00:18:33.820 Amber Lin: Excellent.
214 00:18:33.820 ⇒ 00:18:39.020 Awaish Kumar: Like, anything… if a new zip code comes in, it goes there, people there, and assignments.
215 00:18:40.670 ⇒ 00:18:44.709 Awaish Kumar: in the assignments table. So these… these are, like, basic structure, and then….
216 00:18:45.450 ⇒ 00:18:51.260 Awaish Kumar: These other two will be updated after these three are… updated, because…
217 00:18:52.420 ⇒ 00:19:05.540 Awaish Kumar: Locations, people, and assignments table are updated, then you can update inspector sheet table, which basically will get all the data from assignments, right? It just… it’s just grouped by… by zip code, service.
218 00:19:05.870 ⇒ 00:19:07.690 Amber Lin: I see.
219 00:19:07.690 ⇒ 00:19:08.950 Awaish Kumar: And it will just….
220 00:19:09.170 ⇒ 00:19:09.630 Amber Lin: Rod.
221 00:19:09.630 ⇒ 00:19:11.339 Awaish Kumar: All these separate ideas, right?
222 00:19:11.340 ⇒ 00:19:12.300 Amber Lin: Got it, I see.
223 00:19:12.300 ⇒ 00:19:16.950 Awaish Kumar: We can’t even get that on a… And I… he’s using a…
224 00:19:17.170 ⇒ 00:19:19.889 Awaish Kumar: Similar query from these three tables, but….
225 00:19:20.890 ⇒ 00:19:26.710 Awaish Kumar: A lot of our queries are, are similar to what this table is.
226 00:19:27.140 ⇒ 00:19:28.510 Awaish Kumar: structured.
227 00:19:28.750 ⇒ 00:19:32.239 Awaish Kumar: We can keep it, like, as a one table, so….
228 00:19:32.240 ⇒ 00:19:34.900 Amber Lin: Inspector sheet, technician, service data.
229 00:19:34.930 ⇒ 00:19:42.280 Awaish Kumar: It can be one table, which will basically just… aggregate assignments general.
230 00:19:42.490 ⇒ 00:19:43.080 Awaish Kumar: Kind of.
231 00:19:45.100 ⇒ 00:19:46.350 Amber Lin: Okay.
232 00:19:46.840 ⇒ 00:19:51.950 Amber Lin: So the assignments table is a joined table from, like, locations and people, essentially.
233 00:19:51.950 ⇒ 00:19:53.070 Awaish Kumar: Yep, yep.
234 00:19:55.030 ⇒ 00:20:02.309 Amber Lin: Okay. But the actual assignment itself comes from the inspector or technician’s sheet. Like, that’s the…
235 00:20:02.820 ⇒ 00:20:17.229 Amber Lin: I don’t know if that makes sense. So, in order to link the code in person, it will need to come from the inspector sheet. Like, we can’t just join the locations and people and get the assignments. I don’t think it works that way.
236 00:20:18.070 ⇒ 00:20:21.810 Awaish Kumar: Yeah, but that’s my question, like, so in the assignment.
237 00:20:22.190 ⇒ 00:20:28.340 Awaish Kumar: inspector sheet table, we have a zip code, we have a service, we have assignment IDs.
238 00:20:28.450 ⇒ 00:20:31.790 Awaish Kumar: These assignment IDs are coming from assignments table.
239 00:20:32.080 ⇒ 00:20:41.839 Awaish Kumar: So, if there’s an entry in assignment table, then it goes to inspector Sheet. It does not… right now, it doesn’t look like the inspector sheet is the…
240 00:20:42.110 ⇒ 00:20:45.090 Awaish Kumar: kind of… In public.
241 00:20:45.090 ⇒ 00:20:45.730 Amber Lin: As a big clue.
242 00:20:45.730 ⇒ 00:20:47.410 Awaish Kumar: It’ll be used as a base table.
243 00:20:47.760 ⇒ 00:20:51.679 Awaish Kumar: I see here, because it is… having a fun with IDs.
244 00:20:51.830 ⇒ 00:20:53.520 Amber Lin: recognizable.
245 00:20:55.330 ⇒ 00:20:56.220 Amber Lin: Okay.
246 00:20:56.950 ⇒ 00:20:59.590 Amber Lin: Okay. It, it, it’s… Exciting right here.
247 00:20:59.590 ⇒ 00:21:04.950 Casie Aviles: Casey, as long as it makes sense to you, I think it kind of makes sense to me, but it’s okay. I don’t need to….
248 00:21:04.950 ⇒ 00:21:06.939 Awaish Kumar: I just want to see, like, if, …
249 00:21:07.100 ⇒ 00:21:12.899 Awaish Kumar: I want to understand, like, how the assignments… so, somebody is going to give us an answer.
250 00:21:13.160 ⇒ 00:21:22.410 Awaish Kumar: kind of form that, in this zip code, this person will be serving as a residential pest inspector.
251 00:21:22.460 ⇒ 00:21:23.510 Amber Lin: Right?
252 00:21:24.560 ⇒ 00:21:25.360 Amber Lin: Huh.
253 00:21:25.360 ⇒ 00:21:31.409 Awaish Kumar: That’s going to come from a form, and using that information, we can fill in assignments table.
254 00:21:31.410 ⇒ 00:21:40.570 Amber Lin: Oh, oh, I see, sorry. No, it makes sense. I was… I was thinking of the arrows in the opposite direction. Sorry, it makes sense to me now.
255 00:21:41.110 ⇒ 00:21:42.610 Casie Aviles: Oh, okay, so….
256 00:21:43.230 ⇒ 00:21:43.549 Amber Lin: at this point.
257 00:21:43.550 ⇒ 00:21:44.270 Casie Aviles: me reverse.
258 00:21:44.270 ⇒ 00:21:51.110 Amber Lin: No, it makes sense. It makes sense. Form submitted goes… use….
259 00:21:51.110 ⇒ 00:21:56.889 Awaish Kumar: In the form submitted, we have a zip code. A zip code means, like, if it… if there’s no zip…
260 00:21:56.950 ⇒ 00:22:14.059 Awaish Kumar: If we don’t have that zip code in locations table, we can add it in locations. Otherwise, we will just use that. Similarly, if that person is not in the people’s table, we will add entry in people’s table. Otherwise, we just get the person ID.
261 00:22:14.120 ⇒ 00:22:30.490 Awaish Kumar: And then we go to the assignments table, where we have now zip code, we have a person ID, and we know what role is assigned to it. So we’ll select the role and sub-role, and assignment ID will be generated automatically by database.
262 00:22:33.630 ⇒ 00:22:34.810 Casie Aviles: Hmm, okay.
263 00:22:35.030 ⇒ 00:22:36.600 Casie Aviles: So… okay.
264 00:22:50.660 ⇒ 00:22:55.410 Awaish Kumar: And basically, using that, we can answer all the Cuties.
265 00:22:55.560 ⇒ 00:23:08.730 Awaish Kumar: Why I’m suggesting having a third table, which will… can join inspector, technician, and service areas is… is because if we are… if we are getting the similar query every time, we don’t need to…
266 00:23:08.860 ⇒ 00:23:15.200 Awaish Kumar: run that complex query. We can just create a table, Basically, and serve from there.
267 00:23:16.150 ⇒ 00:23:18.149 Awaish Kumar: To the end user, that’s on.
268 00:23:21.670 ⇒ 00:23:22.670 Casie Aviles: Yeah, okay.
269 00:23:30.570 ⇒ 00:23:33.440 Amber Lin: Yeah. I think that’s the workflow.
270 00:23:33.460 ⇒ 00:23:34.310 Casie Aviles: Okay, so the….
271 00:23:34.310 ⇒ 00:23:34.850 Amber Lin: Me.
272 00:23:34.850 ⇒ 00:23:38.800 Casie Aviles: Forms will directly update the assignments table, right?
273 00:23:40.300 ⇒ 00:23:40.990 Amber Lin: Yeah.
274 00:23:40.990 ⇒ 00:23:50.279 Awaish Kumar: Yeah, like, locations, people, and assignments. These three are needed to be… Updated from the forms correctly.
275 00:23:51.320 ⇒ 00:23:57.739 Awaish Kumar: We need to make sure the location is there, we need to make sure the person is already in our database.
276 00:23:57.990 ⇒ 00:23:58.860 Awaish Kumar: Right?
277 00:24:00.340 ⇒ 00:24:06.060 Awaish Kumar: And then we need to define role and sub-role, so that should come from the form.
278 00:24:06.640 ⇒ 00:24:07.110 Amber Lin: Something….
279 00:24:07.110 ⇒ 00:24:10.319 Awaish Kumar: Right? Otherwise, I don’t know if we have that information anywhere.
280 00:24:10.570 ⇒ 00:24:14.710 Awaish Kumar: We don’t want to go from inspector sheet to…
281 00:24:15.310 ⇒ 00:24:18.859 Awaish Kumar: To this day, right? We don’t want to go from form to this.
282 00:24:18.860 ⇒ 00:24:19.920 Amber Lin: tables, right?
283 00:24:19.920 ⇒ 00:24:20.470 Awaish Kumar: I want to remember.
284 00:24:20.470 ⇒ 00:24:23.140 Amber Lin: Move the inspector sheet is probably Yeah.
285 00:24:23.140 ⇒ 00:24:24.270 Awaish Kumar: Question, right?
286 00:24:24.450 ⇒ 00:24:36.969 Amber Lin: I see, I see. I think I mixed it up because, to create the database, it needs to… we need to get all the data from the inspection sheet, but from then, all the updates and maintenance will use this workflow from…
287 00:24:36.970 ⇒ 00:24:45.019 Amber Lin: Like, assignments, because all… it’s just that all the data is in here right now, but once we fill… once we create a database, we’ll follow this workflow.
288 00:24:46.330 ⇒ 00:24:49.290 Awaish Kumar: Because it comes from forms, like, forms is our primary.
289 00:24:49.290 ⇒ 00:24:49.980 Amber Lin: Huh.
290 00:24:50.210 ⇒ 00:24:53.390 Awaish Kumar: Right now, we are historic fortunate.
291 00:24:53.520 ⇒ 00:25:00.309 Awaish Kumar: To update the database from a historical inspector sheet, we might need to write some ad hoc scripts
292 00:25:00.480 ⇒ 00:25:02.590 Awaish Kumar: to handle that, but otherwise.
293 00:25:02.910 ⇒ 00:25:14.459 Awaish Kumar: Our workflow is, after we deprecated the inspector sheet, our workflow is that from forms, we get something, and from there, we update our database.
294 00:25:14.460 ⇒ 00:25:14.819 Amber Lin: I don’t.
295 00:25:14.820 ⇒ 00:25:16.900 Awaish Kumar: I have inspector Sheet in between, right?
296 00:25:20.380 ⇒ 00:25:25.440 Casie Aviles: Okay, so it’s going to be just these three… As the core tables, then.
297 00:25:27.130 ⇒ 00:25:27.800 Casie Aviles: Okay.
298 00:25:28.390 ⇒ 00:25:29.959 Amber Lin: Is this what amenable?
299 00:25:31.150 ⇒ 00:25:43.620 Awaish Kumar: And then you can write, like, well, once you have this database, you can write ad hoc script to, like, read from inspector sheet and update locations table, people table, and assignees.
300 00:25:43.960 ⇒ 00:25:48.559 Awaish Kumar: So that, … We… whatever in the inspector sheet.
301 00:25:48.860 ⇒ 00:25:51.469 Awaish Kumar: It can be loaded into the database.
302 00:25:58.470 ⇒ 00:25:59.060 Casie Aviles: Okay.
303 00:25:59.630 ⇒ 00:26:00.409 Amber Lin: I’m crazy.
304 00:26:15.420 ⇒ 00:26:21.189 Amber Lin: I think this is… Like, this… oops, does this make sense as a combined table?
305 00:26:21.510 ⇒ 00:26:23.520 Amber Lin: So that would be the service.
306 00:26:23.520 ⇒ 00:26:24.250 Awaish Kumar: Yep.
307 00:26:24.250 ⇒ 00:26:27.440 Amber Lin: Service areas… Service area…
308 00:26:32.160 ⇒ 00:26:32.900 Amber Lin: Fuck.
309 00:26:48.350 ⇒ 00:26:49.579 Awaish Kumar: Don’t go there, huh?
310 00:26:50.850 ⇒ 00:26:51.440 Amber Lin: Nope.
311 00:26:52.590 ⇒ 00:26:54.000 Awaish Kumar: Oh, I trusted.
312 00:26:56.180 ⇒ 00:26:57.570 Awaish Kumar: And from, …
313 00:26:58.610 ⇒ 00:27:06.419 Awaish Kumar: like, in the assignment table, we have role and sub-role. So, role is inspector, sub-role is kind of service, right?
314 00:27:06.850 ⇒ 00:27:08.249 Awaish Kumar: It’s based on whatever.
315 00:27:08.490 ⇒ 00:27:10.710 Awaish Kumar: Can we call it service or subnet?
316 00:27:10.710 ⇒ 00:27:17.329 Amber Lin: Yeah, let’s call it… yeah, let’s just do that, because we can edit the form if we need to, and I think it’s easy to understand.
317 00:27:17.330 ⇒ 00:27:25.240 Awaish Kumar: And then, similarly, we have… Role can be, for example, technician, and service can be something.
318 00:27:25.760 ⇒ 00:27:28.010 Awaish Kumar: Under the technicians, right?
319 00:27:28.310 ⇒ 00:27:28.920 Casie Aviles: Yes.
320 00:27:28.920 ⇒ 00:27:31.550 Awaish Kumar: That goes in a sandwich as well.
321 00:27:40.500 ⇒ 00:27:44.379 Amber Lin: I see, so for each zip code, we’ll essentially have, like.
322 00:27:44.680 ⇒ 00:27:52.910 Amber Lin: Two rows? Multiple rows for each zip code. So some are inspectors, some are technicians, and each of these have different services.
323 00:27:54.290 ⇒ 00:27:56.240 Awaish Kumar: Yeah, like, we can’t even have….
324 00:27:56.340 ⇒ 00:28:00.289 Amber Lin: Same zip code, same role, but multiple services.
325 00:28:00.790 ⇒ 00:28:05.179 Amber Lin: This guy’s ability. It does not work. Yeah. It does not work.
326 00:28:05.910 ⇒ 00:28:15.210 Amber Lin: So, we… do we want… sorry, last question, do we want each service to be a row, or do we want multiple columns of different services?
327 00:28:16.590 ⇒ 00:28:18.769 Awaish Kumar: No, no, no, it’s the service is a column.
328 00:28:18.990 ⇒ 00:28:21.080 Awaish Kumar: I know you just updated the value, right?
329 00:28:21.450 ⇒ 00:28:22.010 Amber Lin: Okay, okay.
330 00:28:22.010 ⇒ 00:28:25.340 Awaish Kumar: Like, a residential pest, or something else?
331 00:28:25.890 ⇒ 00:28:26.600 Amber Lin: Yeah.
332 00:28:27.930 ⇒ 00:28:38.919 Amber Lin: So, we essentially… flattened the master inspector sheet so that each row only talks about one service.
333 00:28:39.470 ⇒ 00:28:43.199 Amber Lin: Okay, that makes sense. That will make querying easier.
334 00:28:43.440 ⇒ 00:28:44.290 Amber Lin: Okay.
335 00:28:45.430 ⇒ 00:28:48.659 Amber Lin: Casey, how’s progress on this side?
336 00:28:51.580 ⇒ 00:28:55.159 Casie Aviles: For the… I haven’t really implemented anything, yeah.
337 00:28:57.790 ⇒ 00:29:02.439 Casie Aviles: I’m just trying to process if I understand everything correctly.
338 00:29:02.840 ⇒ 00:29:05.160 Amber Lin: You get the visual of the grapple.
339 00:29:06.330 ⇒ 00:29:07.839 Awaish Kumar: So, are we good here?
340 00:29:08.690 ⇒ 00:29:11.499 Amber Lin: I… I think I’m good.
341 00:29:11.630 ⇒ 00:29:12.430 Amber Lin: Version?
342 00:29:13.080 ⇒ 00:29:14.120 Awaish Kumar: Do you have any?
343 00:29:14.400 ⇒ 00:29:16.020 Awaish Kumar: I have any questions, Cassie?
344 00:29:18.070 ⇒ 00:29:26.480 Casie Aviles: Hmm… Yeah, I think this… This is, … yeah, it’s making sense, so… I’m just a little…
345 00:29:27.080 ⇒ 00:29:30.659 Casie Aviles: confused, I guess, by the arrows here.
346 00:29:32.530 ⇒ 00:29:34.149 Awaish Kumar: The book travel.
347 00:29:34.370 ⇒ 00:29:35.460 Casie Aviles: These ones….
348 00:29:35.460 ⇒ 00:29:38.570 Awaish Kumar: Yeah, these arrows can be other way around, right?
349 00:29:40.890 ⇒ 00:29:41.750 Casie Aviles: Yeah, okay.
350 00:29:41.750 ⇒ 00:29:48.600 Awaish Kumar: Locations is our… Primary table, like, and zip code is a….
351 00:29:48.800 ⇒ 00:29:49.240 Amber Lin: You can charge.
352 00:29:49.240 ⇒ 00:29:51.390 Awaish Kumar: Foreign key in the assignments table.
353 00:29:51.610 ⇒ 00:29:55.800 Awaish Kumar: from location string. So, arrows are, like, other….
354 00:29:56.040 ⇒ 00:29:56.800 Amber Lin: Got me till twice.
355 00:29:56.800 ⇒ 00:29:57.900 Awaish Kumar: I’ll be around.
356 00:30:00.190 ⇒ 00:30:08.900 Amber Lin: Locations is the primary… Let me just write that down. So that’s the primary table.
357 00:30:09.060 ⇒ 00:30:09.830 Awaish Kumar: Yeah.
358 00:30:10.100 ⇒ 00:30:14.359 Amber Lin: And then… pre-pull, is that also a patient table? Yep.
359 00:30:15.660 ⇒ 00:30:16.325 Amber Lin: So….
360 00:30:16.990 ⇒ 00:30:20.149 Casie Aviles: It’s kind of, we have a list of locations, we have a list of people.
361 00:30:20.170 ⇒ 00:30:27.720 Awaish Kumar: Then, assignments is just, we want to know which person in which zip code works, and what services he provides, right?
362 00:30:29.920 ⇒ 00:30:30.650 Casie Aviles: Yes.
363 00:30:33.410 ⇒ 00:30:37.660 Casie Aviles: And this is… this over here, this is just the merge table from….
364 00:30:38.330 ⇒ 00:30:38.980 Awaish Kumar: Yeah.
365 00:30:39.510 ⇒ 00:30:44.110 Awaish Kumar: It’s kind of aggregated table from the assignments.
366 00:30:44.650 ⇒ 00:30:47.160 Casie Aviles: Okay, so it’s gonna come from assignments.
367 00:30:47.650 ⇒ 00:30:48.290 Awaish Kumar: Yep.
368 00:30:48.610 ⇒ 00:30:51.179 Casie Aviles: Okay, yeah, that makes sense, that makes sense.
369 00:30:56.380 ⇒ 00:30:58.449 Awaish Kumar: Yeah, you have to take care of this.
370 00:30:58.710 ⇒ 00:31:04.800 Awaish Kumar: Do we service this, golem, right? I don’t know where it is coming from, …
371 00:31:05.420 ⇒ 00:31:08.120 Awaish Kumar: from assignments, or… I don’t know, man.
372 00:31:09.060 ⇒ 00:31:12.990 Casie Aviles: This is gonna come from here, right? The service areas sheet.
373 00:31:14.320 ⇒ 00:31:17.300 Awaish Kumar: Who is updating that sheet?
374 00:31:18.240 ⇒ 00:31:21.380 Amber Lin: It’s mostly set, and they barely change it.
375 00:31:21.920 ⇒ 00:31:26.920 Amber Lin: It’s mostly if they open a new office or, like, add a new lounge service, then it will change.
376 00:31:26.920 ⇒ 00:31:32.899 Awaish Kumar: No, no, but, like, is the service… Area, different from the…
377 00:31:33.250 ⇒ 00:31:36.489 Awaish Kumar: Like, the data which is coming from forms.
378 00:31:37.090 ⇒ 00:31:39.550 Amber Lin: The zip codes are the same.
379 00:31:39.680 ⇒ 00:31:47.740 Amber Lin: … I think the only thing is that, … this…
380 00:31:48.510 ⇒ 00:32:00.499 Amber Lin: the categories, the granularity of the services in the inspector sheet is a lot more granular, so under, for example, under residential pests, there’s multiple ones.
381 00:32:00.610 ⇒ 00:32:07.969 Amber Lin: But here, it’s just a general overarching branch of, okay, we do service residential pests in this zip code.
382 00:32:11.640 ⇒ 00:32:16.510 Awaish Kumar: Yeah, then I think let’s make this as a primary table as well.
383 00:32:16.850 ⇒ 00:32:19.620 Amber Lin: Okay. Let me… Mmm.
384 00:32:19.620 ⇒ 00:32:25.059 Awaish Kumar: This is defined… this is not coming from firms. This is a separate input, right?
385 00:32:25.250 ⇒ 00:32:37.340 Awaish Kumar: If from the form somebody can say, okay, this person in this area can provide, for example, a service like Bad Bug in,
386 00:32:37.990 ⇒ 00:32:40.469 Awaish Kumar: Zip code 76526.
387 00:32:41.310 ⇒ 00:32:41.730 Amber Lin: Right?
388 00:32:41.730 ⇒ 00:32:53.680 Awaish Kumar: person can provide this service in a zip code, but does not mean that ABC provides that service. So we need to maintain this table that does ABC provide this service in the zip code?
389 00:32:55.630 ⇒ 00:32:56.569 Amber Lin: I see.
390 00:32:58.150 ⇒ 00:32:59.000 Awaish Kumar: Yeah.
391 00:33:01.510 ⇒ 00:33:02.669 Amber Lin: Yeah, I thought about it.
392 00:33:03.180 ⇒ 00:33:04.210 Awaish Kumar: Yeah, absolutely.
393 00:33:04.400 ⇒ 00:33:11.900 Awaish Kumar: If ABC provides that service in the zip code, then you can maybe add a Boolean flag in assignments that
394 00:33:14.170 ⇒ 00:33:20.110 Awaish Kumar: Right, is… Like, I don’t know what to name the field.
395 00:33:20.110 ⇒ 00:33:22.659 Amber Lin: I’m just… That’s your input.
396 00:33:22.660 ⇒ 00:33:23.570 Awaish Kumar: Something like that.
397 00:33:48.120 ⇒ 00:33:50.979 Awaish Kumar: So, if we don’t service this, then…
398 00:33:51.170 ⇒ 00:33:54.049 Awaish Kumar: In the aggregated table, we are gonna say no.
399 00:33:54.220 ⇒ 00:33:57.000 Awaish Kumar: And there will be no… even if there are assignments.
400 00:33:57.120 ⇒ 00:34:00.070 Awaish Kumar: This field, is service going to say no?
401 00:34:01.980 ⇒ 00:34:10.260 Awaish Kumar: So, you know, if it is no, then even if there are people who can work in this, zip code, we… ABC don’t provide that service.
402 00:34:10.639 ⇒ 00:34:11.929 Amber Lin: I see.
403 00:34:21.979 ⇒ 00:34:23.729 Amber Lin: The tower’s, like, super long.
404 00:34:24.239 ⇒ 00:34:25.049 Amber Lin: Okay.
405 00:34:26.039 ⇒ 00:34:30.159 Amber Lin: That makes sense. I thought it for 6 seconds, it didn’t end.
406 00:34:30.159 ⇒ 00:34:32.949 Casie Aviles: Yeah, yeah, this clarifies a lot for me as well.
407 00:34:34.729 ⇒ 00:34:39.599 Amber Lin: Raw… Inspector, service…
408 00:34:49.959 ⇒ 00:34:50.949 Amber Lin: …
409 00:34:51.089 ⇒ 00:35:05.359 Amber Lin: Actually, in the aggregated table, I guess when we return values, we want to return the names of people. Are we gonna store the person ID here, or are we gonna just convert
410 00:35:05.699 ⇒ 00:35:08.119 Amber Lin: convert it into a Persian name.
411 00:35:08.899 ⇒ 00:35:12.959 Amber Lin: Because they’re gonna enter person name, they’re not gonna enter person ID.
412 00:35:14.610 ⇒ 00:35:17.279 Awaish Kumar: Yeah, they’re gonna end up personal name, but we….
413 00:35:17.280 ⇒ 00:35:17.880 Amber Lin: Hmm.
414 00:35:17.880 ⇒ 00:35:23.449 Awaish Kumar: In the database, when we are entering into the database, our script will get the person ID.
415 00:35:25.290 ⇒ 00:35:25.800 Amber Lin: Okay.
416 00:35:25.800 ⇒ 00:35:35.869 Awaish Kumar: person name is there. If person name is not there, we are going to add the entry for that person in the people’s table, so it will generate the person ID.
417 00:35:38.290 ⇒ 00:35:42.050 Awaish Kumar: But I know, like, for example.
418 00:35:42.400 ⇒ 00:35:45.970 Awaish Kumar: Like, yes, they are going to ask, like,
419 00:35:46.080 ⇒ 00:35:58.820 Awaish Kumar: In the aggregated table, obviously, they are going… they don’t need assignment IDs, right? They don’t know what assignment IDs are, they just need the information on who can serve us, right? We need to return the person’s name.
420 00:36:00.050 ⇒ 00:36:03.170 Awaish Kumar: So, either we can have, …
421 00:36:03.550 ⇒ 00:36:14.410 Awaish Kumar: Like, we can even flatten this, right? Instead of having assignments 1, 2, 3, 4 as an aggregated, we can say… we can have different rows, right? If there are multiple rows.
422 00:36:15.580 ⇒ 00:36:26.310 Awaish Kumar: So the same zip code, role, and service, and we know each service is yes or no, whatever. And then we can have multiple rows, with…
423 00:36:27.220 ⇒ 00:36:33.370 Awaish Kumar: with multiple, like, assignment ID, person ID, a person ID, things like that.
424 00:36:34.320 ⇒ 00:36:47.660 Awaish Kumar: We can just, instead of having, like, 1, 2, 3, 4 in a list form, so we… for this single row, we are seeing in the table, it will be converted into 4 different roles.
425 00:36:48.690 ⇒ 00:36:50.370 Amber Lin: I see.
426 00:36:51.910 ⇒ 00:36:57.790 Awaish Kumar: And we can… When we are generating this aggregated table, we can just bring in, like.
427 00:36:58.300 ⇒ 00:37:02.239 Awaish Kumar: assignment ID, person ID, and person name into this table.
428 00:37:03.330 ⇒ 00:37:04.080 Amber Lin: I see.
429 00:37:05.290 ⇒ 00:37:12.909 Amber Lin: Yeah, we can add, like… The Taurus is probably the official name.
430 00:37:13.260 ⇒ 00:37:14.210 Amber Lin: Needed.
431 00:37:15.360 ⇒ 00:37:17.250 Amber Lin: I’ll get that, as will be.
432 00:37:17.250 ⇒ 00:37:18.340 Awaish Kumar: What’s on….
433 00:37:20.090 ⇒ 00:37:21.379 Amber Lin: That makes sense.
434 00:37:25.620 ⇒ 00:37:26.500 Amber Lin: Okay.
435 00:37:26.690 ⇒ 00:37:31.989 Amber Lin: I’m going to hop. Thank you, this is really helpful. ….
436 00:37:32.750 ⇒ 00:37:33.090 Awaish Kumar: Sure.
437 00:37:33.090 ⇒ 00:37:38.370 Amber Lin: I guess, Casey, which one would you start working on first? Like, what’s the order of work here?
438 00:37:39.090 ⇒ 00:37:49.259 Casie Aviles: I think I’ll still start with the locations. I’ve already ticketed that out, so I think this helps clarify, and then I’ll work on the primary tables.
439 00:37:49.860 ⇒ 00:37:50.380 Amber Lin: Okay.
440 00:37:50.380 ⇒ 00:37:52.300 Casie Aviles: With the data that we already have.
441 00:37:52.640 ⇒ 00:38:01.209 Amber Lin: Yeah, okay, sounds good. And I will, send a screenshot of this to Utam, so he can take a look.
442 00:38:01.950 ⇒ 00:38:02.610 Casie Aviles: Okay.
443 00:38:03.600 ⇒ 00:38:05.419 Casie Aviles: Yeah, alright, thanks all.
444 00:38:06.140 ⇒ 00:38:07.999 Awaish Kumar: Thank you, everyone. Okay, thank you.
445 00:38:08.000 ⇒ 00:38:08.620 Amber Lin: Bye.