Hi guys, I am finishing my CS course, and I decided to use Django to implement EPOS + Employee Scheduling + Stock Management system into one web app for my final year project. I have started building the application, but I am at a point where I am not too sure what is the best way to approach the …

Addressing individual points as I can: [image] antpngl92: Sales analytics and Report generation Daily/Weekly/Monthly/Yearly On the surface, this appears to be more of a “process” issue than a data issue. Am I missing something here? [image] antpngl92: the time at which the employee sig…

I would just include a DateField in each of your models, I don’t see much value in making a Date a separate model. (I’d also create an index on that field to ensure that searching for entries by date is as fast as possible.) Also, Day / Month / Year can be derived from the generic Date field and doe…

Feedback - some general thoughts, given with the understanding that I am not familiar with the processing that needs to occur. These entities don’t exist in a vacuum - they exist only to support some type of data management needs. Those needs can and should greatly affect the design of the models. S…

Hi Ken, Thanks a lot for the feedback! Sorry for not adding requirements, the list is quite long, but here are some of the ones I am unsure on how to model: Sales analytics and Report generation Daily/Weekly/Monthly/Yearly Employee scheduling for each day. On opening the schedule part of the web…

Design Problem

Using Django

antpngl92 December 2, 2020, 1:05am 3

I came up with the following model architecture. Would appreciate any feedback.

Thanks in advance!

Topic		Replies	Views
Choosing a data model for hierarchical date spans Using the ORM	3	116	February 17, 2025
Handle multiple dates on a model Using Django	0	873	November 18, 2022
create a date difference generatedfield in model Using the ORM	23	428	April 1, 2025
Design guidance on Employee model Using the ORM	7	1688	May 16, 2022
Datetime field with different precisions Using Django	1	531	February 28, 2021

Design Problem

Related topics