I was wondering, how you hardcore mysql programmers would do this...
I have a database project, horse thing...
I've designed this like this:
table user
- primary key(user_id)
table horse
- primary key(horse_id)
table image
- id, not auto_increment, same in table horse
Now, there are more fields ofcourse, in all of those tables...
In table horse, all the information on each horse goes there, but I need to have information on mother/father/fatherofthefather/motherofthemother on each horse in table horse, but there's not much info om the "parents"
and the "grandparents"...
So I was just wondering, how would you see me build this up?
Any suggestions are well taken,
with thanks in advance, Arni
I have a database project, horse thing...
I've designed this like this:
table user
- primary key(user_id)
table horse
- primary key(horse_id)
table image
- id, not auto_increment, same in table horse
Now, there are more fields ofcourse, in all of those tables...
In table horse, all the information on each horse goes there, but I need to have information on mother/father/fatherofthefather/motherofthemother on each horse in table horse, but there's not much info om the "parents"
and the "grandparents"...
So I was just wondering, how would you see me build this up?
Any suggestions are well taken,
with thanks in advance, Arni