: Add inline comments ( -- ) or block comments ( /* ... */ ) to explain complex logic, such as how tax is calculated or how "available" status is determined.
: Keywords should be in UPPERCASE (e.g., SELECT , FROM , WHERE ) to distinguish them from table and column names, which should follow a consistent snake_case or PascalCase naming convention.
: Use CREATE TABLE IF NOT EXISTS or DROP TABLE IF EXISTS to ensure the script can be run multiple times without errors. wynajem.sql
This review evaluates the script for schema integrity, query efficiency, and adherence to SQL development standards .
: Ensure foreign keys (e.g., klient_id , obiekt_id ) and frequently filtered columns (like data_wynajmu ) are properly indexed to speed up search queries. : Add inline comments ( -- ) or block comments ( /*
: Check for NOT NULL constraints on essential fields (dates, IDs) and CHECK constraints to ensure rental start dates are always before end dates. 2. Code Quality & Formatting
: Ensure that currency fields (e.g., cena , kaucja ) use precise types like DECIMAL or NUMERIC rather than floating-point types to avoid rounding errors. : Use CREATE TABLE IF NOT EXISTS or
: Replace SELECT * with explicit column names. This reduces unnecessary data transfer and prevents issues if the table schema changes .