I've been programming for ages, but I had never gotten around to using databases to store information...I recently came upon a project that really needs a database and I'm a little overwhelmed with where i should start. So the question is, how would I go about formatting this thing? My information is like so...
Customer
|
+-----JobID
---------|
---------+---------Charge Rate
---------+---------Pay Rate
---------------------------+---------(Invoice#)
-------------------------------------Note
In short, each customer can have unique JobIDs; each JobID can have unique PayRate and ChargeRates; and each Customer->JobID->PayRate,ChargeRate can have multiple, unique invoice numbers associated with it. Each invoice can have an optional note, but the notes are not unique themselves. I know this is probably very noobish, but any help is appreciated...
Customer
|
+-----JobID
---------|
---------+---------Charge Rate
---------+---------Pay Rate
---------------------------+---------(Invoice#)
-------------------------------------Note
In short, each customer can have unique JobIDs; each JobID can have unique PayRate and ChargeRates; and each Customer->JobID->PayRate,ChargeRate can have multiple, unique invoice numbers associated with it. Each invoice can have an optional note, but the notes are not unique themselves. I know this is probably very noobish, but any help is appreciated...
Facebook
Twitter