aboutsummaryrefslogtreecommitdiffstats
path: root/rust/src/database_schema.rs
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2018-05-15 11:06:08 -0700
committerBryan Newbold <bnewbold@robocracy.org>2018-05-15 11:06:08 -0700
commit428898b3ca46855822c80c9bd8a9ae9c8da5aaf2 (patch)
tree13d97758bc10507bc49b7fa201a785774c1e61ca /rust/src/database_schema.rs
parent08447760cd3580504ff6d5c6ea8d5dd6cea1fb64 (diff)
downloadfatcat-428898b3ca46855822c80c9bd8a9ae9c8da5aaf2.tar.gz
fatcat-428898b3ca46855822c80c9bd8a9ae9c8da5aaf2.zip
regenerate full(er) database schema
Diffstat (limited to 'rust/src/database_schema.rs')
-rw-r--r--rust/src/database_schema.rs191
1 files changed, 191 insertions, 0 deletions
diff --git a/rust/src/database_schema.rs b/rust/src/database_schema.rs
index 7bef7dcd..83e7f7d0 100644
--- a/rust/src/database_schema.rs
+++ b/rust/src/database_schema.rs
@@ -7,6 +7,37 @@ table! {
}
table! {
+ container_edit (id) {
+ id -> Int8,
+ extra_json -> Nullable<Json>,
+ ident_id -> Uuid,
+ rev_id -> Nullable<Int8>,
+ redirect_id -> Nullable<Uuid>,
+ editgroup_id -> Int8,
+ }
+}
+
+table! {
+ container_ident (id) {
+ id -> Uuid,
+ is_live -> Bool,
+ rev_id -> Nullable<Int8>,
+ redirect_id -> Nullable<Uuid>,
+ }
+}
+
+table! {
+ container_rev (id) {
+ id -> Int8,
+ extra_json -> Nullable<Json>,
+ name -> Nullable<Text>,
+ parent_ident_id -> Nullable<Int8>,
+ publisher -> Nullable<Text>,
+ issn -> Nullable<Text>,
+ }
+}
+
+table! {
creator_edit (id) {
id -> Int8,
extra_json -> Nullable<Json>,
@@ -53,16 +84,176 @@ table! {
}
}
+table! {
+ file_edit (id) {
+ id -> Int8,
+ extra_json -> Nullable<Json>,
+ ident_id -> Uuid,
+ rev_id -> Nullable<Int8>,
+ redirect_id -> Nullable<Uuid>,
+ editgroup_id -> Int8,
+ }
+}
+
+table! {
+ file_ident (id) {
+ id -> Uuid,
+ is_live -> Bool,
+ rev_id -> Nullable<Int8>,
+ redirect_id -> Nullable<Uuid>,
+ }
+}
+
+table! {
+ file_release (id) {
+ id -> Int8,
+ file_rev -> Int8,
+ target_release_ident_id -> Uuid,
+ }
+}
+
+table! {
+ file_rev (id) {
+ id -> Int8,
+ extra_json -> Nullable<Json>,
+ size -> Nullable<Int4>,
+ sha1 -> Nullable<Text>,
+ url -> Nullable<Text>,
+ }
+}
+
+table! {
+ release_contrib (id) {
+ id -> Int8,
+ release_rev -> Int8,
+ creator_ident_id -> Nullable<Uuid>,
+ stub -> Nullable<Text>,
+ contrib_type -> Nullable<Text>,
+ }
+}
+
+table! {
+ release_edit (id) {
+ id -> Int8,
+ extra_json -> Nullable<Json>,
+ ident_id -> Uuid,
+ rev_id -> Nullable<Int8>,
+ redirect_id -> Nullable<Uuid>,
+ editgroup_id -> Int8,
+ }
+}
+
+table! {
+ release_ident (id) {
+ id -> Uuid,
+ is_live -> Bool,
+ rev_id -> Nullable<Int8>,
+ redirect_id -> Nullable<Uuid>,
+ }
+}
+
+table! {
+ release_ref (id) {
+ id -> Int8,
+ release_rev -> Int8,
+ target_release_ident_id -> Nullable<Uuid>,
+ index -> Nullable<Int4>,
+ stub -> Nullable<Text>,
+ }
+}
+
+table! {
+ release_rev (id) {
+ id -> Int8,
+ extra_json -> Nullable<Json>,
+ work_ident_id -> Nullable<Uuid>,
+ container_ident_id -> Nullable<Uuid>,
+ title -> Nullable<Text>,
+ license -> Nullable<Text>,
+ release_type -> Nullable<Text>,
+ date -> Nullable<Text>,
+ doi -> Nullable<Text>,
+ volume -> Nullable<Text>,
+ pages -> Nullable<Text>,
+ issue -> Nullable<Text>,
+ }
+}
+
+table! {
+ work_edit (id) {
+ id -> Int8,
+ extra_json -> Nullable<Json>,
+ ident_id -> Uuid,
+ rev_id -> Nullable<Int8>,
+ redirect_id -> Nullable<Uuid>,
+ editgroup_id -> Int8,
+ }
+}
+
+table! {
+ work_ident (id) {
+ id -> Uuid,
+ is_live -> Bool,
+ rev_id -> Nullable<Int8>,
+ redirect_id -> Nullable<Uuid>,
+ }
+}
+
+table! {
+ work_rev (id) {
+ id -> Int8,
+ extra_json -> Nullable<Json>,
+ work_type -> Nullable<Text>,
+ primary_release_id -> Nullable<Uuid>,
+ }
+}
+
joinable!(changelog -> editgroup (editgroup_id));
+joinable!(container_edit -> container_rev (rev_id));
+joinable!(container_edit -> editgroup (editgroup_id));
+joinable!(container_ident -> container_rev (rev_id));
joinable!(creator_edit -> creator_rev (rev_id));
joinable!(creator_edit -> editgroup (editgroup_id));
joinable!(creator_ident -> creator_rev (rev_id));
+joinable!(file_edit -> editgroup (editgroup_id));
+joinable!(file_edit -> file_rev (rev_id));
+joinable!(file_ident -> file_rev (rev_id));
+joinable!(file_release -> creator_ident (target_release_ident_id));
+joinable!(file_release -> file_rev (file_rev));
+joinable!(release_contrib -> creator_ident (creator_ident_id));
+joinable!(release_contrib -> release_rev (release_rev));
+joinable!(release_edit -> editgroup (editgroup_id));
+joinable!(release_edit -> release_rev (rev_id));
+joinable!(release_ident -> release_rev (rev_id));
+joinable!(release_ref -> creator_ident (target_release_ident_id));
+joinable!(release_ref -> release_rev (release_rev));
+joinable!(release_rev -> container_ident (container_ident_id));
+joinable!(release_rev -> work_ident (work_ident_id));
+joinable!(work_edit -> editgroup (editgroup_id));
+joinable!(work_edit -> work_rev (rev_id));
+joinable!(work_ident -> work_rev (rev_id));
+joinable!(work_rev -> release_ident (primary_release_id));
allow_tables_to_appear_in_same_query!(
changelog,
+ container_edit,
+ container_ident,
+ container_rev,
creator_edit,
creator_ident,
creator_rev,
editgroup,
editor,
+ file_edit,
+ file_ident,
+ file_release,
+ file_rev,
+ release_contrib,
+ release_edit,
+ release_ident,
+ release_ref,
+ release_rev,
+ work_edit,
+ work_ident,
+ work_rev,
);