E
E
Ellik2018-05-24 12:22:41
MySQL
Ellik, 2018-05-24 12:22:41

What kind of table structure should be organized if it is required to implement the idea of ​​maintaining types of some entity?

Friends, I apologize in advance for a possibly stupid question, but the task is the following. There is a 'schedules' table and several tables describing the "type" of the schedule (schedules_type_per_week, schedules_type_per_month etc ). I don't know how best to make a request to get the schedule type, if we know that there can be only one type (i.e. if there is a schedule for a month, then there is no entry for this schedule in other tables). And somehow this crutch moment that "there is no type of schedule in other tables, if there is in one" is not very pleasant to me ... Please advise something or throw an idea. Thank you in advance

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question