>...

dwain.c (10/29/2012)

---

I won't be able to help you much as your business logic is slightly elusive to me as I'm not much of a sports fan. 🙂

However you have two...

Is there any extra info I could provide that would help

capn.hector (4/24/2012)

---

as vinu said about the "master" tables. many players can play on a team and a player can play on many teams (not at the same time but...

So sort of make the players table a junction of players, teams and seasons and then create a foreign to games and create the relevant fields there.

I should mention there...

Where I an coming unstuck though is. Players play games and for a team. I have separate player and team tables as players could change teams transfer etc even during...

So if I haven't a constraint it should be m on the table with the created foreign key.

I guess I wIll just have to get used of it. Not initially...

I never thought about keeping the scripts for backup but that is a good point.

Is there a good editor to write the SQL in?

I have actually found a good resource for time durations and date/time which is very helpful to me. Should be able to help you too.

sqlteam time durations

So what I am asking is, there a date and time formats, that handle what date it is or what the clock time is. But is there a type in...