Complete Database Schema + Relationships (Users, Employers, Applicants) 🔥Drizzle ORM + Next.js

Description

In this tutorial I’ll walk you through how to create database schemas for Employers and Applicants and define the relationships between Users, Employers, Applicants and Sessions using Drizzle ORM in a Next.js + MySQL job-portal application. ---------------------------------------------------------------------------------- 📂 Source Code 👉 GitHub Repo: https://github.com/thapatechnical/job-portal-nextjs ------------------------------------------------------------------------------------ 🔗 Useful Playlists 📘 Next.js Full Stack Playlist: https://youtube.com/playlist?list=PLwGdqUZWnOp0lwvSBaIzzgV9X0ZiZ-42O&si=aQ_TNBNNx5L7V_bn ⚛️ React.js Playlist: https://youtube.com/playlist?list=PLwGdqUZWnOp1Rab71vx2zMF6qpwGDB2Z1&si=sDZRxsYNetYmojKd 💻 TypeScript Playlist: https://youtube.com/playlist?list=PLwGdqUZWnOp0xfHQFmlL52b_6-QZ0mnk_&si=c4jfsd5ElDC1p0A5 ------------------------------------------------------------------------------------ 💸 Get All My YouTube Videos' Source Code for just ₹199! Grab Now - https://thapatechnical.shop/source-code 📺 Watch the complete Node.JS Playlist here :https://youtube.com/playlist?list=PLwGdqUZWnOp3KELplHtc-RnJ5xTUPqdgH&si=_ob8F88HYxCdspup 🔥 Access Source Code, PPT & Notes here for Free : https://www.thapatechnical.com/2024/11/introduction-to-nodejs.html ------------------------------------------------------------------------ 🚀 Boost Your Skills with these Pre-Requisite Videos: 🔗 Best HTML Course - https://youtu.be/5ccq_nLHneE 🔗 Best CSS Course - https://youtu.be/MSICFljRcb4 🔗 JavaScript Basics Course Part 1 - https://youtu.be/13gLB6hDHR8 🔗 JavaScript Advanced Course Part 2 - https://youtu.be/YwsOCN8woA8 ------------------------------------------------------------------------ 💸 Build Your Own E-commerce Website for Free! - https://www.thapatechnical.com/2024/03/build-complete-ecommerce-website-using.html ------------------------------------------------------------------------ ✌️ Join Us! 🚀 Become a Member: Unlock perks, free source code, and more Join Now : https://www.youtube.com/channel/UCwfaAHy4zQUb2APNOGXUCCA/join 📷 Connect on Instagram: https://www.instagram.com/thapatechnical 🗨️ Join Our Discord Server: Hang out with fellow programmers Discord Link: https://discord.gg/MdScmCsua6 ------------------------------------------------------------------------ ⌛TIMELINE⏳ 0:00 Introduction to database schema for Employer and Applicant 0:32 What user selects at signup – Employer or Applicant 1:30 Asking 6 questions (based on relations) 2:40 Answering the previous asked 6 questions 4:00 Schema file path 4:25 Understanding the Employers schema 9:25 Applicant schema for the same 11:40 Syntax of tables & relationships in Drizzle ORM 12:10 Users relations with Employer table 15:20 Users relations with Applicant table 16:00 Important tips to keep in mind 16:20 Session relation with User table 17:15 Tips to get best at coding 17:40 Comment if you have doubts 17:52 Support my channel