Properties Table: Difference between revisions
From Federal Burro of Information
Jump to navigationJump to search
(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...") |
No edit summary |
||
| Line 14: | Line 14: | ||
Things you can say with this schema: | Things you can say with this schema: | ||
subject id relate object id | subject id relate object id | ||
'track' 2 | 'track' 2 'has' 'genre' 4 | ||
'Jazz' 8 | 'Jazz' 8 'is_a' 'genre' '' | ||
'Industrial' 10 'is_a' 'genre' '' | 'Industrial' 10 'is_a' 'genre' '' | ||
'genre' | 'genre' NULL 'is_a' 'class' '' | ||
Revision as of 05:12, 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'
