I don't have a lot of points, I hope experienced people give an authoritative reply

I do not have a lot of points, I hope that experienced people to give an authoritative reply.
I do not have a lot of points, I hope that experienced people to give an authoritative reply.

Manage multiple extranet Web sites on a single working server in the intranet.

A set of news system management A site parity, as long as the database to establish a "classification table" and an "article table", it is OK.

But to manage multiple sites is to publish to multiple sites, each site's columns and articles are not the same.
The information of multiple sites should be centrally stored in the database of a host in the intranet, how to design the table? Add a field to distinguish which site is the article, or to say that each site to create a separate article table?? Consider the need for more post-article posts.


------Solution--------------------
I don't have any experience, I don't have to divide it.
Whatever you say.

I recommend adding flag.
Of course, each station repeated the content of very few cases on a separate article table bar.

