The structure of the company table and department table is either one or two (excluding the extended information)

A table Company A {code ...} company B {code ...} create two tables as follows: Company table {code ...} department table {code ...} one table

Company

-- Department -- Department

Company B

-- Department A -- department B

Create two tables as follows:

Company table

Company A Company B

Department table

-- Department A -- department B -- Department C

Reply content:

One table

Company

-- Department -- Department

Company B

-- Department A -- department B

Create two tables as follows:

Company table

Company A Company B

Department table

-- Department A -- department B -- Department C

We recommend that you use two tables to store data. The Department table stores the company ID and the ID of the higher-level department. In this way, you can query the company information in the company table, to check the departments under a company, you can check the company table and department table. To check the Department's superior department, you can check the Department's superior ID in the department table, then you can check the Department table.