Properties Table: Difference between revisions
From Federal Burro of Information
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 19: | Line 19: | ||
'Industrial' 10 'is_a' 'genre' '' | 'Industrial' 10 'is_a' 'genre' '' | ||
'genre' NULL 'is_a' 'class' '' | 'genre' NULL 'is_a' 'class' '' | ||
relations | |||
1 isa | |||
2 has_property | |||
3 has_member | |||
Revision as of 13:59, 29 September 2013
an approach to creating flexible ontologies using sql
< CREATE TABLE `property` ( < `subject` text, < `subject_id` int(11) DEFAULT NULL, < `relate_id` int(11) DEFAULT NULL, < `object` text, < `object_id` int(11) DEFAULT NULL, < `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' < )
Things you can say with this schema:
subject id relate object id 'track' 2 'has' 'genre' 4 'Jazz' 8 'is_a' 'genre' 'Industrial' 10 'is_a' 'genre' 'genre' NULL 'is_a' 'class'
relations
1 isa 2 has_property 3 has_member
