Semantic MediaWiki/data/smw di *: Difference between revisions

s_id: ID of page on which the property appears
p_id: ID of page for property name

Revision as of 23:27, 10 July 2020

Each of these tables contains property values for properties of a particular type.

The following fields appear in all tables:

The following fields appear only in some tables:

name↓ / table→	blob	bool	coords	number	time	URI	wikipage
o_blob	blob	-	-	-	-	URI
o_hash	blob
o_value	-	bool
o_serialized	-	-	coords	number	time	URI
o_lat	-	-	coords
o_lon	-	-	coords
o_sortkey	-	-	-	number	time
o_id	-	-	-	-	-	-	wikipage	ID of page that is the property's value

@@ Line 7: / Line 7: @@
 The following fields appear only in some tables:
-* '''o_blob''': {{l/same|smw_di_blob}}, {{l/same|smw_di_uri}}
+{|
-* '''o_hash''': {{l/same|smw_di_blob}}
+|-
-* '''o_value''': {{l/same|smw_di_bool}}
+! name&darr; / table&rarr;
-* '''o_serialized''': {{l/same|smw_di_coords}}, {{l/same|smw_di_number}}, {{l/same|smw_di_time}}, {{l/same|smw_di_uri}}
+! [[../smw_di_blob|blob]]
-* '''o_lat''': {{l/same|smw_di_coords}}
+! [[../smw_di_bool|bool]]
-* '''o_lon''': {{l/same|smw_di_coords}}
+! [[../smw_di_coords|coords]]
-* '''o_sortkey''': {{l/same|smw_di_number}}, {{l/same|smw_di_time}}
+! [[../smw_di_number|number]]
-* '''o_id''': {{l/same|smw_di_wikipage}} - ID of page that is the property's value
+! [[../smw_di_time|time]]
+! [[../smw_di_uri|URI]]
+! [[../smw_di_wikipage|wikipage]]
+|-
+| '''o_blob''' || blob || - || - || - || - || URI
+|-
+| '''o_hash''' || blob
+|-
+| '''o_value''' || - || bool
+|-
+| '''o_serialized''' || - || - || coords || number || time || URI
+|-
+| '''o_lat''' || - || - || coords
+|-
+| '''o_lon''' || - || - || coords
+|-
+| '''o_sortkey''' ||  - || - || - || number || time
+|-
+| '''o_id''' || - || - || - || - || - || - || wikipage || ID of page that is the property's value
+|}