| Rainbow Dash | |
<div class="walloftext">
<p>
To meet the requests of archivers, statisticians, and data analysts alike,
Derpibooru 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 PostgreSQL 13.3.
</p>
<p>
To load an entire dump (requires 29 GB of free storage):
</p>
<pre>
dropdb --if-exists derpibooru
createdb derpibooru
pg_restore -O -d derpibooru derpibooru_public_dump_2021_09_23.pgdump
</pre>
<p>
This will create the database <code>derpibooru</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>3.5G</td>
<td><a href="https://data.derpicdn.net/file/derpibooru-data/derpibooru_public_dump_2021_09_23.pgdump">derpibooru_public_dump_2021_09_23.pgdump</a></td>
<td>ce09ef855d390114d5d8db42a1f1b69099d44b9475512f19bfa8c5da9b1f8cc9</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,
Derpibooru 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 15.x.
</p>
<p>
To load an entire dump (requires 40 GB of free storage):
</p>
<pre>
dropdb --if-exists derpibooru
createdb derpibooru
pg_restore -O -d derpibooru derpibooru_public_dump_2024_11_08.pgdump
</pre>
<p>
This will create the database <code>derpibooru</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>4.8G</td>
<td><a href="https://files.derpicdn.net/derpibooru_public_dump_2024_11_08.pgdump">derpibooru_public_dump_2024_11_08.pgdump</a></td>
<td>351068a9135bfd44f968c807bfc9551107936a3e06b80353832df7106eeef01b</td>
</tr>
</tbody>
</table>
<p>
Note: these dumps do not include images.
</p>
</div>
|