Properties Table

From Federal Burro of Information
Revision as of 04:36, 29 September 2013 by David (talk | contribs) (Created page with "an approach to creating flexible ontologies using sql <pre> < CREATE TABLE `property` ( < `subject` text, < `subject_id` int(11) DEFAULT NULL, < `relate_id` int(11) DEF...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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'       'is_a' 'class'
Retrieved from "https://wiki.quadratic.net/index.php?title=Properties_Table&oldid=1777"