For this Question: In the `post` table set the 'USERNAME' field as foreign key to USERNAME field in the `PROFILE` table. If the 'USERNAME' updates then the 'USERNAME' in the `POST` table must also update and on deletion of the user the corresponding posts should be deleted. The POST table contains the following fields ( ID INT, USERNAME VARCHAR(24) NOT NULL, POST_TITLE VARCHAR(72), POST_DESCRIPTION TEXT, DATETIME_CREATED TEXT, PHOTO BLOB ).
( USE ONLY UPPERCASE LETTERS ) 


<schema>[{'name': 'PROFILE', 'columns': [{'name': 'USERNAME', 'type': 'VARCHAR (24)'},{'name': 'FULL_NAME', 'type': 'VARCHAR (72)'}, {'name': 'HEADLINE', 'type': 'VARCHAR (72)'}]},{'name': 'POST', 'columns': [{'name': 'ID', 'type': 'INT'}, {'name': 'USERNAME', 'type': 'VARCHAR(24)'}, {'name': 'POST_TITLE', 'type': 'VARCHAR (72)'}, {'name': 'POST_DESCRIPTION', 'type': 'TEXT'}, {'name': 'DATETIME_CREATED', 'type': 'DATETIME'}, {'name': 'NUMBER_OF_LIKES', 'type': 'INT'}, {'name': 'PHOTO', 'type': 'BLOB'}]}]</schema>nannannan, I have written this Solution Code: CREATE TABLE POST (
    ID INT, 
    USERNAME VARCHAR(24) NOT NULL,
    POST_TITLE VARCHAR(72), 
    POST_DESCRIPTION TEXT,
    DATETIME_CREATED TEXT, 
    PHOTO BLOB,
    FOREIGN KEY (USERNAME)
    REFERENCES  PROFILE(USERNAME) 
    ON UPDATE CASCADE
    ON DELETE CASCADE
);, In this Programming Language: SQL, Now tell me if this Code is compilable or not?