| From: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
|---|---|
| To: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: database design |
| Date: | 2011-02-15 07:27:40 |
| Message-ID: | 4D5A2AEC.90603@compulab.co.il |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Kalai,
From the vagueness of your question, it sounds like you need a DBA to
design the database.
But basically you need to put the branch id as a foreign key in all data
tables and then you can generate reports grouped by date or portion
thereof, branch or company.
Sim
On 02/15/2011 08:45 AM, Kalai R wrote:
> hi,
>
> We are going to design database for a large company, which has many
> branches. In each branch they maintain data separately and also they
> maintain year wise data. ie
>
> Company
> |
> Branch
> |
> Yearly
>
> Also we need to compare and prepare reports by combine all branched data.
>
> How should we design the database. Please Give Guidance.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alessandro Candini | 2011-02-15 08:32:55 | Re: Multithreaded query onto 4 postgresql instances |
| Previous Message | John R Pierce | 2011-02-15 06:47:17 | Re: database design |