Database Design -- Suggestion / Help
Posted: Sun Mar 09, 2003 3:14 am
Hello All,
I am new to DB and need guidance from DB gurus in this scenario.
I have been assigned to put up a web site to track disk usage of file servers at three sites.
Initally I had thought of four tables for each site; But then I reduced this to two tables ; one containing filer name, site name and filer id. And second table has date, disk_used, filer id.
In second table I tried using filer id as foreign key. But it seems mysql won't accept foreign key in create table statement.
I also looked at references. But this also does not seem to fit in.
Could some one suggest alternatives ?
TIA
RAM
I am new to DB and need guidance from DB gurus in this scenario.
I have been assigned to put up a web site to track disk usage of file servers at three sites.
Initally I had thought of four tables for each site; But then I reduced this to two tables ; one containing filer name, site name and filer id. And second table has date, disk_used, filer id.
In second table I tried using filer id as foreign key. But it seems mysql won't accept foreign key in create table statement.
I also looked at references. But this also does not seem to fit in.
Could some one suggest alternatives ?
TIA
RAM