我有两个表格提案和提案附件。每个提案都有一个docx文件和pdf文件。让我知道下表的设计是正确的
提案和提案附件

| id | proposalNo | ProposalTitle | Status |
    --------------------------------------------
    | 1  |  PRO 123  | sample         | 0      |
    --------------------------------------------

-----------------------------------------------------------------------
| id | proposal_id | version_ID |  Status  |    fileName    | filetype   | 
------------------------------------------------------------------------
|  1  |        1   | 1          |     1    |  Sample1.docx  | doctype   |
------------------------------------------------------------------------
|  2  |        1   | 1          |     1    |  Sample1.pdf   |   pdf     |
------------------------------------------------------------------------
|  3  |        1   | 2          |     1    |  Sample2.docx  | doctype   |
------------------------------------------------------------------------  
|  4  |        1   | 2          |     1    |  Sample2.pdf   | pdf       |
------------------------------------------------------------------------

应该用like

|id| proposal_id|version_ID |Status|filetitle|fileNamedoc|fileNamePDF