Last time, we discussed a project and did the introduction of that project.
And then we decided with which Modules we are going to work, What will be our project definition, How will we get the functionality of the module.
We defined All these things in the last topic.
Today We are making Project’s database schema ready.
Well, the Database schema is made before starting the project.
Because You get the exact idea of what Tables you’re making in that particular project and what will be the relations of those particular tables and what will be the fields with all the relations respectively.
So this particular thing is known as database schema
So let's start from the tables.
Where the first table that we will make will be the user master table.
Now what does the user master table mean?
This particular table will have the Fields that will be useful while logging in.
This particular table will have those particular fields which will be used at the time of logging in.
Your admin can handle that particular thing through this table, ok? Right?
What are the particular fields in the table? Let’s decide the Fields as well.
here first of all I want the email of that particular user right?
So email id will be here.
Then password .
Role as well.
Role means The user which is registering, Is doing registration as a candidate or Doing registration as a company.
What we will do is decide his role.
The particular login registration that is happening, Is coming particularly as a candidate or as a company.
And we will use the OTP as well.
OTP means Particular registration that is happening here, After registration we will send an OTP.
And as the OTP will be verified, based on that Particular OTP, You will verify him over here and And complete the registration process ok? Right?
Only then he'll be able to Login Or else He won't be able to login.
Then here we want some flags.
These are called flags.
For example “is active”
So I have taken this “is active” field because, Here, If admin wants to deactivate some company. right?
Then he can do it from here Using this particular flag.
Then “is created”
When was the particular account created.
When did this particular account get updated?
And “Is verify”
So I told you Whenever a particular company is coming, Who will Verify that company ?
In this way we are going to Decide all the things through the admin panel.
Whatever Company is to be verified has to be given a field.
Whatever is to be activated Also has to be given a field Right? Clear?
So these are the Particular fields in this master table ok?
Then let’s make another table over here.
With the name suppose “candidate”
Imagine I am making a candidate table.
This will include First name.. last name..
Now be Careful with the one thing over here.
Whenever you are Making candidate or company table, So in these particular tables, the fields which are Already in the master table will not be included. ok?
So neither our email field will be added, nor password.
here contact will be added, his skills will be added, ok?
If we want to make another table for Skills, We can make another table as well, No problem.
Then his state will be added, City, His particular address, then gender ok?
And date of birth, Let's take D.O.B here right?
These particular fields will be in the candidate table.
Similarly we will make a table for companies over here.
So Which will be the fields added in the company ?
Owner name… Company name ..
Details of the company.
Contact of the company.
Address of the company.
State of the company.
Whatever will be the particular logo of the company, for that We will take an image field. ok?
So all these fields will be included in the company table.
This particular thing that we are doing, This particular thing is known as database schema.
I am not making a Database schema for every table here. why?
Because already we are already going to do all these things in our project.
When we will make our models in django, We are going to do these same things in models of django as well.
That’s why I am not showing you everything here, not showing you all the things of the table.
I kept the Topic of database schema just to Explain the Example.
To make you know, What all you need before starting the project. ok guys?
So particularly in this way the database schema is made, with the table names and with particular field names. ok? Right? Understood?
When we will meet in next topic, we will Start the project implementation .
In that will start our Particular projects With the database creation.
Ok? right? Thank you.
Let's meet for the next topic With project.
If you have any queries or comments, click the discussion button below the video and post there. This way, you will be able to connect to fellow learners and discuss the course. Also, Our Team will try to solve your query.
This video took half hour
Set up the Django project and create a virtual environment.
Make a new database.
Make a change to settings.py.
Install mysqlclient package.
Run the migrate command.
SQLite, MySQL, and PostgreSQL are the three most used database management systems for Django. PostgreSQL is the preferred database for Django Web Apps, according to the Django community and official documentation.
Schema. A [schema] explains what resources are available via the API, their URLs, how they are represented, and what operations they support in a machine-readable format.
SQLite is used by default in the settings. This is the simplest option if you're new to databases or just want to try out Django. You won't need to install anything additional to support your database because SQLite is built into Python.
Multiple databases are not explicitly supported by Django's admin. You'll need to develop custom ModelAdmin classes to direct the admin to utilise a certain database for content if you wish to provide an admin interface for a model on a database different than the one indicated by your router chain.
where will i get code access for the project source code?
this course structure is very good. I suggest for learning to this website.
Superb and amazing 😍🤩 enjoyable experience.
Er Komal Gupta
thnku so much sir. after waisting so mch time in boring videos.i learned only from here.explained vry well and i will suggest evryone that learnvern is the bst online plateform where you can learnalot
ajax lesson was something like boring . But , learned a lot with the sunit sir . Just learned how to deal with ajax in django