Should foreign keys (FK) be explicitly labeled as such in PHP when creating relationships between tables, or is it sufficient to have a meaningful name for the column?

When creating relationships between tables in a database using foreign keys (FK), it is good practice to explicitly label them as such in PHP for clarity and maintainability. This helps other developers understand the structure of the database and easily identify the relationships between tables. While having a meaningful name for the column is important, explicitly labeling it as a foreign key adds an extra layer of documentation and organization to the database schema.

// Example of explicitly labeling a foreign key in PHP when creating a table
$sql = "CREATE TABLE orders (
    order_id INT AUTO_INCREMENT PRIMARY KEY,
    customer_id INT,
    FOREIGN KEY (customer_id) REFERENCES customers(customer_id)
)";