Message-
From: Kirk Babb [mailto:[EMAIL PROTECTED]
Sent: Monday, December 29, 2003 4:31 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] table structure question
Hi everyone,
I would like to set up the following two tables inside a db for a soccer
league, but wanted to run their structure by you
I would do it a little bit different:
1. I would add ID's for each of the tables.
2. I would split teams in 2 tables; the captain stuff would be in a
separate table (captain_team let's say), simply because I would have
different players as captains in different games. If you keep the
structure as
Hi everyone,
I would like to set up the following two tables inside a db for a soccer
league, but wanted to run their structure by you guys first. Here it is:
dbname: soccer_stats
tables: teams, players
teams
--
name | captain | division | paid | pmnt_notes | win | loss | tie | goals_for
|