View Single Post
01-13-2005, 04:18 PM
#4
Salathe is offline Salathe
Salathe's Avatar
Status: Community Archaeologist
Join date: Jul 2004
Location: Scotland
Expertise: Software Development
Software: vim, PHP
 
Posts: 3,820
iTrader: 25 / 100%
 

Salathe will become famous soon enough

Send a message via MSN to Salathe

  Old

Personally I would structure the tables differently. You don't know all that much about databases so I won't bore you with technical terms, instead I'll just show you how I would do it (maybe).

Code:
Table Name: project
project_id | project_name | etc

Table Name: client
client_id | client_name | etc

Table Name: project_client
procli_id | procli_project | procli_client
This means that your project data is completely separate from your client data, and vice versa. It also allows you to have multiple clients per project (it can happen!). Simple JOIN commands can be used to relate the project_client table to the project and client tables if and when necessary.