Tables, Schema, Data Types & Constraints — SQL Database
A table is the core storage unit in a relational database. Each column has a defined type, and each row represents a record. The schema is the complete database design: tables, columns, relationships, defaults, constraints, and indexes. Common Data Types Common data types include INTEGER/BIGINT for whole numbers, DECIMAL/NUMERIC for exact precision, VARCHAR and TEXT for strings, BOOLEAN for true/false values, DATE and TIMESTAMP for temporal data, UUID for identifiers, and JSON/JSONB for semi-structured data in engines like PostgreSQL. Constraints Constraints act like security guards at the database gate. NOT NULL prevents empty values. UNIQUE prevents duplicates. PRIMARY KEY uniquely identifies each row. FOREIGN KEY enforces relationships between parent and child tables. CHECK restricts…
Key Takeaways
Constraints preserve data accuracy, consistency, and integrity.
PRIMARY KEY and UNIQUE typically create indexes automatically.
FOREIGN KEY relationships prevent orphaned records.
Use CHECK and DEFAULT to enforce business rules at the database layer.