diff options
author | Bryan Newbold <bnewbold@robocracy.org> | 2018-05-15 11:06:08 -0700 |
---|---|---|
committer | Bryan Newbold <bnewbold@robocracy.org> | 2018-05-15 11:06:08 -0700 |
commit | 428898b3ca46855822c80c9bd8a9ae9c8da5aaf2 (patch) | |
tree | 13d97758bc10507bc49b7fa201a785774c1e61ca /rust/src/database_schema.rs | |
parent | 08447760cd3580504ff6d5c6ea8d5dd6cea1fb64 (diff) | |
download | fatcat-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.rs | 191 |
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, ); |