For this Question: If we delete a post the comments associated with it should also delete. Make a table `COMMENT` with fields  (USERNAME VARCHAR(24), COMMENT_TEXT TEXT, POST_ID INT )  where POST_ID is foreign key to POST table.
( USE ONLY UPPERCASE LETTERS) 
<schema>[ {'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'}]}  ,{'name': 'COMMENT', 'columns': [{'name': 'USERNAME', 'type': 'VARCHAR(24)'}, {'name': 'COMMENT_TEXT', 'type': 'TEXT'}, {'name': 'POST_ID', 'type': 'INT'}]}]</schema>nannannan, I have written this Solution Code: CREATE TABLE comment(
    username varchar(24),
    comment_text text,
    post_id int,
    FOREIGN KEY (post_id)
    REFERENCES  post(id) 
    ON DELETE CASCADE
);, In this Programming Language: SQL, Now tell me if this Code is compilable or not?