Properties Table

From Federal Burro of Information
Revision as of 13:59, 29 September 2013 by David (talk | contribs)
Jump to navigationJump to search

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
Retrieved from "https://wiki.quadratic.net/index.php?title=Properties_Table&oldid=1779"