| Nighty | |
<div class="walloftext">
<p>
To meet the requests of archivers, statisticians, and data analysts alike,
Tantabus provides data dumps on a nightly basis. These data consist only
of publicly accessible database contents. These dumps are provided in
<code>pg_dump</code>'s custom format, and are created using latest PostgreSQL 17.x.
</p>
<p>
To load an entire dump (requires 10043 kB of free storage):
</p>
<pre>
dropdb --if-exists tantabus
createdb tantabus
pg_restore -O -d tantabus tantabus_public_dump_2024_11_28.pgdump
</pre>
<p>
This will create the database <code>tantabus</code> with the following
table layout:
</p>
<h3>public.artist_links</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>tag_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>url</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.badge_awards</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>badge_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>label</td>
<td>text</td>
<td>✔</td>
</tr>
</tbody>
</table>
<h3>public.badges</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>title</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>description</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>image_url</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.comments</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td>✔</td>
</tr>
<tr>
<td>body</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.duplicate_reports</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>duplicate_of_image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td>✔</td>
</tr>
<tr>
<td>state</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>reason</td>
<td>text</td>
<td>✔</td>
</tr>
</tbody>
</table>
<h3>public.forums</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>topic_count</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>post_count</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>name</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>short_name</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>description</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.galleries</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>thumbnail_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>image_count</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>title</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>spoiler_warning</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>description</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.gallery_interactions</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>gallery_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>position</td>
<td>integer</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.image_duplicates</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>target_id</td>
<td>bigint</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.image_faves</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.image_features</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.image_intensities</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>nw_intensity</td>
<td>double precision</td>
<td></td>
</tr>
<tr>
<td>ne_intensity</td>
<td>double precision</td>
<td></td>
</tr>
<tr>
<td>sw_intensity</td>
<td>double precision</td>
<td></td>
</tr>
<tr>
<td>se_intensity</td>
<td>double precision</td>
<td></td>
</tr>
<tr>
<td>avg_intensity</td>
<td>double precision</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.image_sources</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>source</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.image_taggings</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>tag_id</td>
<td>bigint</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.images</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>image_width</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>image_height</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>image_size</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>comment_count</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>score</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>favorites</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>upvotes</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>downvotes</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>hides</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>image_aspect_ratio</td>
<td>double precision</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td>✔</td>
</tr>
<tr>
<td>image_mime_type</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>image_format</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>image_name</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>version_path</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>image_sha512_hash</td>
<td>text</td>
<td>✔</td>
</tr>
<tr>
<td>image_orig_sha512_hash</td>
<td>text</td>
<td>✔</td>
</tr>
</tbody>
</table>
<h3>public.posts</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>topic_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td>✔</td>
</tr>
<tr>
<td>body</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.source_changes</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td>✔</td>
</tr>
<tr>
<td>new_value</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.tag_aliases</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>tag_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>target_tag_id</td>
<td>bigint</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.tag_changes</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td>✔</td>
</tr>
<tr>
<td>tag_id</td>
<td>bigint</td>
<td>✔</td>
</tr>
<tr>
<td>added</td>
<td>boolean</td>
<td></td>
</tr>
<tr>
<td>tag_name_cache</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.tag_implications</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>tag_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>target_tag_id</td>
<td>bigint</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.tags</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>image_count</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>name</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>slug</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>category</td>
<td>text</td>
<td>✔</td>
</tr>
<tr>
<td>description</td>
<td>text</td>
<td>✔</td>
</tr>
<tr>
<td>short_description</td>
<td>text</td>
<td>✔</td>
</tr>
</tbody>
</table>
<h3>public.topics</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>forum_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>post_count</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>view_count</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>sticky</td>
<td>boolean</td>
<td></td>
</tr>
<tr>
<td>locked</td>
<td>boolean</td>
<td></td>
</tr>
<tr>
<td>title</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>slug</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.users</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>name</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<p>
Finer granularity over the imported data can be controlled with <code>pg_restore</code>
flags; see <a href="https://www.postgresql.org/docs/current/app-pgrestore.html">the documentation</a>
for more detail.
</p>
<h3>Download</h3>
<table class="table">
<thead>
<tr>
<th>Size</th>
<th>Link</th>
<th>SHA-256</th>
</tr>
</thead>
<tbody>
<tr>
<td>48K</td>
<td><a href="https://files.tantabuscdn.net/tantabus_public_dump_2024_11_28.pgdump">tantabus_public_dump_2024_11_28.pgdump</a></td>
<td>a0c962ac9cf8d64a0d7031dd196b4f321bb88d857aa0bee0ff4a8b6415a62195</td>
</tr>
</tbody>
</table>
<p>
Note: these dumps do not include images.
</p>
</div>
<div class="walloftext">
<p>
To meet the requests of archivers, statisticians, and data analysts alike,
Tantabus provides data dumps on a nightly basis. These data consist only
of publicly accessible database contents. These dumps are provided in
<code>pg_dump</code>'s custom format, and are created using latest PostgreSQL 17.x.
</p>
<p>
To load an entire dump (requires 189 MB of free storage):
</p>
<pre>
dropdb --if-exists tantabus
createdb tantabus
pg_restore -O -d tantabus tantabus_public_dump_2025_01_16.pgdump
</pre>
<p>
This will create the database <code>tantabus</code> with the following
table layout:
</p>
<h3>public.artist_links</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>tag_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>url</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.badge_awards</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>badge_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>label</td>
<td>text</td>
<td>✔</td>
</tr>
</tbody>
</table>
<h3>public.badges</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>title</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>description</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>image_url</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.comments</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td>✔</td>
</tr>
<tr>
<td>body</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.duplicate_reports</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>duplicate_of_image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td>✔</td>
</tr>
<tr>
<td>state</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>reason</td>
<td>text</td>
<td>✔</td>
</tr>
</tbody>
</table>
<h3>public.forums</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>topic_count</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>post_count</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>name</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>short_name</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>description</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.galleries</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>thumbnail_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>image_count</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>title</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>spoiler_warning</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>description</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.gallery_interactions</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>gallery_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>position</td>
<td>integer</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.image_duplicates</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>target_id</td>
<td>bigint</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.image_faves</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.image_features</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.image_intensities</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>nw_intensity</td>
<td>double precision</td>
<td></td>
</tr>
<tr>
<td>ne_intensity</td>
<td>double precision</td>
<td></td>
</tr>
<tr>
<td>sw_intensity</td>
<td>double precision</td>
<td></td>
</tr>
<tr>
<td>se_intensity</td>
<td>double precision</td>
<td></td>
</tr>
<tr>
<td>avg_intensity</td>
<td>double precision</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.image_sources</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>source</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.image_taggings</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>tag_id</td>
<td>bigint</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.images</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>image_width</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>image_height</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>image_size</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>comment_count</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>score</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>favorites</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>upvotes</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>downvotes</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>hides</td>
<td>integer</td>
<td></td>
</tr>
<tr>
<td>image_aspect_ratio</td>
<td>double precision</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td>✔</td>
</tr>
<tr>
<td>image_mime_type</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>image_format</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>image_name</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>version_path</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>image_sha512_hash</td>
<td>text</td>
<td>✔</td>
</tr>
<tr>
<td>image_orig_sha512_hash</td>
<td>text</td>
<td>✔</td>
</tr>
</tbody>
</table>
<h3>public.posts</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>topic_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td>✔</td>
</tr>
<tr>
<td>body</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.source_changes</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td>✔</td>
</tr>
<tr>
<td>new_value</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.tag_aliases</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>tag_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>target_tag_id</td>
<td>bigint</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.tag_changes</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>image_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>bigint</td>
<td>✔</td>
</tr>
<tr>
<td>tag_id</td>
<td>bigint</td>
<td>✔</td>
</tr>
<tr>
<td>added</td>
<td>boolean</td>
<td></td>
</tr>
<tr>
<td>tag_name_cache</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.tag_implications</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>tag_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>target_tag_id</td>
<td>bigint</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.tags</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>image_count</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>name</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>slug</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>category</td>
<td>text</td>
<td>✔</td>
</tr>
<tr>
<td>description</td>
<td>text</td>
<td>✔</td>
</tr>
<tr>
<td>short_description</td>
<td>text</td>
<td>✔</td>
</tr>
</tbody>
</table>
<h3>public.topics</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>forum_id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>post_count</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>view_count</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>created_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>updated_at</td>
<td>timestamp</td>
<td></td>
</tr>
<tr>
<td>sticky</td>
<td>boolean</td>
<td></td>
</tr>
<tr>
<td>locked</td>
<td>boolean</td>
<td></td>
</tr>
<tr>
<td>title</td>
<td>text</td>
<td></td>
</tr>
<tr>
<td>slug</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<h3>public.users</h3>
<table class="table">
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Nullable?</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>bigint</td>
<td></td>
</tr>
<tr>
<td>name</td>
<td>text</td>
<td></td>
</tr>
</tbody>
</table>
<p>
Finer granularity over the imported data can be controlled with <code>pg_restore</code>
flags; see <a href="https://www.postgresql.org/docs/current/app-pgrestore.html">the documentation</a>
for more detail.
</p>
<h3>Download</h3>
<table class="table">
<thead>
<tr>
<th>Size</th>
<th>Link</th>
<th>SHA-256</th>
</tr>
</thead>
<tbody>
<tr>
<td>18M</td>
<td><a href="https://files.tantabuscdn.net/tantabus_public_dump_2025_01_16.pgdump">tantabus_public_dump_2025_01_16.pgdump</a></td>
<td>3afc8f6a96c70d4d80359302b3b8bb68ab5ae2f7c39b3a266b7da66eb81c6b8a</td>
</tr>
</tbody>
</table>
<p>
Note: these dumps do not include images.
</p>
</div>
|