DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)
-   Database Design (http://www.daniweb.com/forums/forum142.html)
-   -   Database design regarding two 'linking' tables (http://www.daniweb.com/forums/thread83950.html)

Falzz Jul 19th, 2007 9:35 am
Database design regarding two 'linking' tables
 
Hi all, im fairly new to database design and would just like a few tips if this is done correctly or if i can improve it..

Im mainly designing a 'leave' application and have an issue with regards to design of two linking tables..

First Table - [Request]
Username, DateStart, DateEnd, DayAmount

Second Table - [Log]
Username, DateStart, DateEnd, DayDate

basically the second table fills in the days of all the dates between the DateStart (starting date) and DateEnd (ending date)..

however im not sure if its good database design to use 3 columns as a primary key and if theres another easier way to solve this issue.

Thanks for your help :)


All times are GMT -4. The time now is 4:13 pm.

Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC