I need some help building a metadata database to associate metadata with content.
I have been given a table structure for the main tables shown below but just don't understand it.
METADATA TABLE and data
ID | KEYWORD
1 | top
2 | dog
3 | car
JOIN TABLE STRUCTURE and data
ID | ParentID | ChildID | RelID
1 | - | 1 | -
2 | 1 | 2 | 1
3 | 2 | 3 | 2
4 | 2 | 3 | 2
This would apparently create a structure like:
top
|
|- dog
| |- car
|
|- car
Anyone know how this join table works????? Help.
I have been given a table structure for the main tables shown below but just don't understand it.
METADATA TABLE and data
ID | KEYWORD
1 | top
2 | dog
3 | car
JOIN TABLE STRUCTURE and data
ID | ParentID | ChildID | RelID
1 | - | 1 | -
2 | 1 | 2 | 1
3 | 2 | 3 | 2
4 | 2 | 3 | 2
This would apparently create a structure like:
top
|
|- dog
| |- car
|
|- car
Anyone know how this join table works????? Help.