CREATE OR REPLACE TRIGGER trigger_borrowing_limitREFERENCING NEW ROW AS NROWFOR EACH ROW
WHEN SELECT COUNT(*) FROM Borrowing WHERE RETURN_DATE IS NULL AND NROW.ID = Borrowing.ID
PKNAMETITLE_ID,FKREADER_ID,PKFirst_NameLast_NameADDRESSCITY_ID,FKPHONECITY_ID,PKNAMEBORROWING_ID,pkREADER_ID,fkTITLE_ID,fkDATEREADER_IDTITLE_IDDATE_OF_BORROWINGDATE_OF_RETURNINGWhen a reader borrows a book, I make an entry in BORROWING</em
CUSTOMER_ID) REFERENCES CUSTOMER (CUSTOMER_ID) ON DELETE NO ACTION ON UPDATE NO ACTION BORROWING_ID INT NOT NULL, ASSET1_ID INT NULL,
ASSET2_IDCONSTRAINT PK_BORROWING_ID PRIMARY KEY (BORROWING_ID
// My class Borrowing
use App\Entity\BorrowingDetails; * @ORM\Entity(repositoryClass=BorrowingRepository::class)class BorrowingdateStartBorrowing);
$dateLimitReturn->modif