Designing My First Real Database Schema with DDL (PostgreSQL)

Hey everyone, Today was a different kind of learning day for me. Instead of writing APIs or working on frontend, I focused on something very important in backend development — database design using DDL commands. At first, I thought database means just creating tables. But today I understood that it’s much more than that. What I worked on today My guide asked me to: Design the database structure Write DDL commands (CREATE TABLE) Apply constraints (for data integrity) Think about optimization So I didn’t just create tables — I designed a proper structure for my project. What is DDL? DDL stands for Data Definition Language It is used to define the structure of the database. Some common commands: CREATE TABLE ALTER TABLE DROP TABLE Today, I mainly worked with CREATE TABLE. My Database Design (Project Based) My project is about social media automation, so I designed tables based on real use cases. Users Table Stores user details like username, email, and password. Important: Email is unique