Gazareth (9/24/2012)

---

Hello,

I seem to recall from my database design classes a while back, being told that a link table with just a datetime field in wasn't really a link table.

I've just designed exactly that, but can't see another way?

Is this true, and what would the alternative be?

create table sourcefile (sourcefileid int primary key, name varchar(500));

create table updateserver (updateserverid int primary key, name varchar(500));

create table sourcefiles_updateserver (sourcefileid int, updateserverid int, updatetime datetime,

primary key (sourcefileid, updateserverid),

foreign key (sourcefileid) references sourcefile (sourcefileid),

foreign key (updateserverid) references updateserver (updateserverid));

Cheers