Ready to build a database table to put the report data, involving three aspects, one is to upload the attachment of the report, one is the Forum module theme posts, there is a forum reply to the report. Now the purpose is to report information through the query, to list is, the attachment, is to show "xxx" attachment was reported, the subject post, the display "xxx" posts were reported, replies, displayed in the "xx" post "xx" Reply was reported. I would like to ask such words, is a separate table or put in a table. Because of the attachment, save an attachment ID to get the relevant information, the subject of the words, to get the title of the topic post, reply words, in addition to the content of the reply itself, but also to know the title of the subject of replies. It also has to be considered if the reported information or the post has been deleted, report the display of the problem. For example, if the ID number of the simple storage, id corresponding information is deleted, report the Information list page, it is impossible to obtain the relevant information by ID number ... Ask for advice, may say a bit chaotic.
Reply to discussion (solution)
A table is enough.
A table is enough.
Do I have to have a field to hold the title of the topic and the content of the reply? Because if the original post is deleted, the content is not available. And put in a table, that's not some of the fields are empty values, this looks good
These fields are almost there.
Informer
Reporting time
Report Content
Handling situation
Appendix
These fields are almost there.
Informer
Reporting time
Report Content
Handling situation
Appendix
I would like to report in the list page, show this form, who in the "XX" Post reply "xxx" was reported, is not just in the database, the time to put these contents into the report content of this field, and then displayed when directly called out? I also want to be related to the post or attachment link, you can go directly to the past to see.