: 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
: Replace SELECT * with explicit column names. This reduces unnecessary data transfer and prevents issues if the table schema changes . wynajem.sql
: Ensure that currency fields (e.g., cena , kaucja ) use precise types like DECIMAL or NUMERIC rather than floating-point types to avoid rounding errors. : Check for NOT NULL constraints on essential
This review evaluates the script for schema integrity, query efficiency, and adherence to SQL development standards . This reduces unnecessary data transfer and prevents issues
: Verify that the rental data is normalized (e.g., separate tables for Klienci (Customers), Obiekty (Properties/Items), and Wynajmy (Rentals)). Ensure there is no redundant storage of rental rates in the transaction table if they can be retrieved via a JOIN from the primary item table .
: 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.
: Add inline comments ( -- ) or block comments ( /* ... */ ) to explain complex logic, such as how tax is calculated or how "available" status is determined.