@prefix sioc: <http://rdfs.org/sioc/ns#> .
@prefix dc: <http://purl.org/dc/elements/1.1/> .
@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix content: <http://purl.org/rss/1.0/modules/content/> .
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .

<https://lhero.org/?post_type=lh-portfolio-doc&#038;p=150026>
  a sioc:Post ;
  dc:title "Database tables" ;
  dcterms:identifier 150026 ;
  dc:modified "2026-10-12T03:44:37Z"^^xsd:dateTime ;
  dc:created "2026-10-12T02:58:28Z"^^xsd:dateTime ;
  sioc:link <https://lhero.org/portfolio/lh-addresses/database-tables/> ;
  sioc:has_creator <https://lhero.org/author/1/#account> ;
  sioc:has_container <https://lhero.org/#posts> ;
  content:encoded """<ul class="lh_portfolio-meta"><li><strong>Part of:</strong> <a href="https://lhero.org/portfolio/lh-addresses/">LH Addresses</a></li></ul>
<p class="wp-block-paragraph">All tables use the network base prefix and live on the main site. They are created by <code>LH_Addresses_Table::maybe_upgrade()</code>, keyed on <code>schema_version()</code> (currently 0.1.0) stored in the network option <code>lh_addresses-schema_version</code>.</p>



<h2 class="wp-block-heading">{base_prefix}lh_addresses</h2>



<ul class="wp-block-list">
<li><code>id</code>, <code>object_type</code> (user), <code>object_id</code> (user ID)</li>



<li><code>country_code</code> (ISO 3166-1 alpha-2), <code>administrative_area</code>, <code>locality</code>, <code>dependent_locality</code>, <code>postal_code</code>, <code>sorting_code</code>, <code>address_line1</code>, <code>address_line2</code></li>



<li><code>source</code> (where it came from), <code>created_by</code>, <code>validation_status</code></li>



<li><code>geocode_status</code> (pending, done, failed, skipped), <code>geocode_attempts</code>, <code>geocode_accuracy</code>, <code>geocoded_at</code></li>



<li><code>created</code>, <code>updated</code> (GMT)</li>
</ul>



<h2 class="wp-block-heading">{base_prefix}lh_address_uses</h2>



<p class="wp-block-paragraph"><code>address_id</code>, <code>blog_id</code> (0 for the member&#8217;s own book), <code>type</code>, <code>created</code>. Primary key (address_id, blog_id, type); index on (blog_id, type).</p>



<h2 class="wp-block-heading">{base_prefix}lh_address_geo</h2>



<p class="wp-block-paragraph"><code>address_id</code>, <code>geo_point</code> (POINT, NOT NULL, spatial index), <code>latitude</code>, <code>longitude</code>. A row exists only once an address is geocoded; it is a side table because a spatial index needs a NOT NULL column.</p>



<h2 class="wp-block-heading">History</h2>



<p class="wp-block-paragraph">Rows are updated in place; there are no valid-from or valid-to columns. Changes are meant to be recorded by LH Audit Trail, from the hooks this plugin fires.</p>
"""^^rdf:XMLLiteral ;
  sioc:content """Part of: LH Addresses
All tables use the network base prefix and live on the main site. They are created by LH_Addresses_Table::maybe_upgrade(), keyed on schema_version() (currently 0.1.0) stored in the network option lh_addresses-schema_version.



{base_prefix}lh_addresses




id, object_type (user), object_id (user ID)



country_code (ISO 3166-1 alpha-2), administrative_area, locality, dependent_locality, postal_code, sorting_code, address_line1, address_line2



source (where it came from), created_by, validation_status



geocode_status (pending, done, failed, skipped), geocode_attempts, geocode_accuracy, geocoded_at



created, updated (GMT)




{base_prefix}lh_address_uses



address_id, blog_id (0 for the member&#8217;s own book), type, created. Primary key (address_id, blog_id, type); index on (blog_id, type).



{base_prefix}lh_address_geo



address_id, geo_point (POINT, NOT NULL, spatial index), latitude, longitude. A row exists only once an address is geocoded; it is a side table because a spatial index needs a NOT NULL column.



History



Rows are updated in place; there are no valid-from or valid-to columns. Changes are meant to be recorded by LH Audit Trail, from the hooks this plugin fires.
""" ;
  sioc:topic <https://lhero.org/?taxonomy=author&term=cap-1> .

<https://lhero.org/author/1/#account> rdfs:seeAlso <https://lhero.org/author/1/?feed=lhrdf&format=turtle> .
<https://lhero.org/?taxonomy=author&term=cap-1> rdfs:seeAlso <https://lhero.org/?taxonomy=author&term=cap-1&feed=lhrdf&format=turtle> .