Project Database Schema

Hello guys, welcome to learnvern.

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

ok?

Right?

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.

okay?

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.

“Is updated”

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 ?

Admin.

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.

City ok?

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