GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Question for database developers having an argument and need some help

sandman! · 11-21-2003, 04:31 PM

Me and a buddy are having an argument about how a database should be structured please post below which way you believe is the best way from the 2 choices below.

First a little info about the database

The database will have subcontractors in it and thier employees to track sales by subcontractor and by employee.

Option 1

Every subcontractor get an id
Example: 001

Every employee gets a id in a second field
Example: 1

So first database would look like this
001-1
001-2
for the tracking of sales

Option 2

Make id #'s for each employee without a field for the sub.

Example

1001
1002
1003
1004
1005
1006
1007

In this option each # can be assined to a diffrent subcontractor

So which way do gfy people think is best?

11-21-2003, 04:31 PM
sandman! Icq: 14420613 Industry Role: Join Date: Mar 2001 Location: chicago Posts: 15,432	Question for database developers having an argument and need some help Me and a buddy are having an argument about how a database should be structured please post below which way you believe is the best way from the 2 choices below. First a little info about the database The database will have subcontractors in it and thier employees to track sales by subcontractor and by employee. Option 1 Every subcontractor get an id Example: 001 Every employee gets a id in a second field Example: 1 So first database would look like this 001-1 001-2 for the tracking of sales Option 2 Make id #'s for each employee without a field for the sub. Example 1001 1002 1003 1004 1005 1006 1007 In this option each # can be assined to a diffrent subcontractor So which way do gfy people think is best?