Properties Table: Difference between revisions
From Federal Burro of Information
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
an approach to creating flexible ontologies using sql | an approach to creating flexible ontologies using sql | ||
property table | |||
<pre> | <pre> | ||
Revision as of 03:16, 12 October 2013
an approach to creating flexible ontologies using sql
property table
< 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
