This is a question related to django. How to insert data for each user.

I'm working on a project through django I created a timetable app.

If you log in to your super account,

Enter the schedule here.

If you put in each class, you'll get a timetable

I want to have each user with this kind of data, but what should I do? <

We have the login membership function.

django

2022-09-22 18:45

1 Answers

It is time for each user to create a users_schedules table that stores the relationship between which subjects they put in their timetable.

For example, if user number 3 includes subject number 2 in the first period and subject number 4 in the sixth period, you can put these records on the table.

id (PK, a_i)  userId (FK)    scheduleId (*FK)    scheduleOrder (index)
(Omitted) 320
(Omitted) 3, 4, 5

Then, you will be able to retrieve user 3's timetable with the next query. select * from users_schedules where userId = 3 order by scheduleOrder

Hint: At this point, the schedules table is convenient to think of as a list of subjects that each user can take.



		
		
			

				

					
				

				
					2022-09-22 18:45

			
			If you have any answers or tips



		

	
		Popular Tags
	
	python x 4647
android x 1593
java x 1494
javascript x 1427
c x 927
c++ x 878
ruby-on-rails x 696
php x 692
python3 x 685
html x 656
	


	
		Popular Questions
	
	
	546 Understanding How to Configure Google API Key

	537 Uncaught (inpromise) Error on Electron: An object could not be cloned

	542 Unable to install versioned in Google Colab

	557 Scrap text information after the "View More" button when searching in the Yahoo! News search window

	642 /usr/bin/google-chrome:symbol lookup error:/usr/bin/google-chrome: undefined symbol:gbm_bo_get_modifier