schema.dbml

//// ------------------------------------------------------
//// THIS FILE WAS AUTOMATICALLY GENERATED (DO NOT MODIFY)
//// ------------------------------------------------------

Table pub_values_history {
  id String [pk]
  createdAt DateTime [default: `now()`, not null]
  operationType OperationType [not null]
  oldRowData Json
  newRowData Json
  pubValueId String
  user users
  userId String
  apiAccessToken api_access_tokens
  apiAccessTokenId String
  actionRun action_runs
  actionRunId String
  other String
}

Table users {
  id String [pk]
  slug String [unique, not null]
  email String [unique, not null]
  firstName String [not null]
  lastName String
  orcid String
  avatar String
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  isSuperAdmin Boolean [not null, default: false]
  passwordHash String
  memberGroups member_groups [not null]
  AuthToken auth_tokens [not null]
  assignedPubs pubs [not null]
  actionRuns action_runs [not null]
  ApiAccessToken api_access_tokens [not null]
  Session sessions [not null]
  formMemberships form_memberships [not null]
  communityMemberships community_memberships [not null]
  pubMemberships pub_memberships [not null]
  stageMemberships stage_memberships [not null]
  PubValueHistory pub_values_history [not null]
}

Table sessions {
  id String [pk]
  userId String [not null]
  user users [not null]
  expiresAt DateTime [not null]
  type AuthTokenType [not null, default: 'generic', note: 'With what type of token is this session created? Used for determining on a page-by-page basis whether to allow a certain session to access it. For instance, a verify email token/session should not allow you to access the password reset page.']
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
}

Table auth_tokens {
  id String [pk]
  hash String [not null]
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  expiresAt DateTime [not null]
  isUsed Boolean [not null, default: false]
  user users [not null]
  userId String [not null]
  type AuthTokenType [not null, default: 'generic']
}

Table communities {
  id String [pk]
  name String [not null]
  slug String [unique, not null]
  avatar String
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  pubTypes pub_types [not null]
  pubs pubs [not null]
  memberGroups member_groups [not null]
  stages stages [not null]
  APIAccessToken api_access_tokens [not null]
  Form forms [not null]
  pubFields pub_fields [not null]
  members community_memberships [not null]
}

Table pubs {
  id String [pk]
  valuesBlob Json
  pubType pub_types [not null]
  pubTypeId String [not null]
  community communities [not null]
  communityId String [not null]
  assigneeId String
  assignee users
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  title String
  stage stages
  stageId String
  parent pubs
  parentId String
  children pubs [not null]
  values pub_values [not null]
  stages PubsInStages [not null]
  actionRuns action_runs [not null]
  relatedValues pub_values [not null]
  members pub_memberships [not null]
  formMemberships form_memberships [not null]
}

Table pub_fields {
  id String [pk]
  name String [not null]
  slug String [unique, not null]
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  schema PubFieldSchema
  schemaName CoreSchemaType
  pubFieldSchemaId String
  isArchived Boolean [not null, default: false]
  community communities [not null]
  communityId String [not null]
  isRelation Boolean [not null, default: false]
  values pub_values [not null]
  pubTypes _PubFieldToPubType [not null]
  FormInput form_elements [not null]
}

Table PubFieldSchema {
  id String [pk]
  namespace String [not null]
  name String [not null]
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  schema Json [not null, note: '@type(JSONSchemaType<any>, \'ajv\', true, false, true)']
  PubFields pub_fields [not null]

  indexes {
    (name, namespace) [unique]
  }
}

Table pub_values {
  id String [pk]
  lastModifiedBy String [not null, note: '@type(LastModifiedBy, \'../types\', true, false, true)']
  field pub_fields [not null]
  fieldId String [not null]
  value Json
  pub pubs [not null]
  pubId String [not null]
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  relatedPub pubs
  relatedPubId String
}

Table pub_types {
  id String [pk]
  name String [not null]
  description String
  community communities [not null]
  communityId String [not null]
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  fields _PubFieldToPubType [not null]
  pubs pubs [not null]
  Form forms [not null]

  indexes {
    (name, communityId) [unique]
  }
}

Table _PubFieldToPubType {
  A String [not null]
  B String [not null]
  isTitle Boolean [not null, default: false]
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  pubField pub_fields [not null]
  pubType pub_types [not null]

  indexes {
    (A, B) [unique]
  }
}

Table stages {
  id String [pk]
  name String [not null]
  order String [not null]
  community communities [not null]
  communityId String [not null]
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  pubs PubsInStages [not null]
  moveConstraints move_constraint [not null]
  moveConstraintSources move_constraint [not null]
  actionInstances action_instances [not null]
  formElements form_elements [not null]
  members stage_memberships [not null]
  Pub pubs [not null]
}

Table PubsInStages {
  pub pubs [not null]
  pubId String [not null]
  stage stages [not null]
  stageId String [not null]
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]

  indexes {
    (pubId, stageId) [pk]
  }
}

Table move_constraint {
  stage stages [not null]
  stageId String [not null]
  destination stages [not null]
  destinationId String [not null]
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]

  indexes {
    (stageId, destinationId) [pk]
  }
}

Table member_groups {
  id String [pk]
  community communities [not null]
  communityId String [not null]
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  users users [not null]
  formMemberships form_memberships [not null]
  communityMemberships community_memberships [not null]
  pubMemberships pub_memberships [not null]
  stageMemberships stage_memberships [not null]
}

Table community_memberships {
  id String [pk]
  role MemberRole [not null]
  community communities [not null]
  communityId String [not null]
  user users
  userId String
  memberGroup member_groups
  memberGroupId String
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]

  indexes {
    (communityId, userId) [unique]
    (communityId, memberGroupId) [unique]
  }
}

Table pub_memberships {
  id String [pk]
  role MemberRole [not null]
  pub pubs [not null]
  pubId String [not null]
  user users
  userId String
  memberGroup member_groups
  memberGroupId String
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]

  indexes {
    (pubId, userId) [unique]
    (pubId, memberGroupId) [unique]
  }
}

Table stage_memberships {
  id String [pk]
  role MemberRole [not null]
  stage stages [not null]
  stageId String [not null]
  user users
  userId String
  memberGroup member_groups
  memberGroupId String
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]

  indexes {
    (stageId, userId) [unique]
    (stageId, memberGroupId) [unique]
  }
}

Table form_memberships {
  id String [pk]
  form forms [not null]
  formId String [not null]
  user users
  userId String
  memberGroup member_groups
  memberGroupId String
  pub pubs
  pubId String
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]

  indexes {
    (formId, userId, pubId) [unique]
    (formId, memberGroupId, pubId) [unique]
  }
}

Table action_instances {
  id String [pk]
  name String [not null, default: '']
  action Action [not null]
  stage stages [not null]
  stageId String [not null]
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  config Json
  rules rules [not null]
  runs action_runs [not null]
}

Table action_runs {
  id String [pk]
  actionInstance action_instances
  actionInstanceId String
  pub pubs
  pubId String
  config Json
  event Event
  params Json
  status ActionRunStatus [not null]
  result Json [not null]
  user users
  userId String
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  PubValueHistory pub_values_history [not null]
}

Table rules {
  id String [pk]
  event Event [not null]
  actionInstance action_instances [not null]
  actionInstanceId String [not null]
  config Json
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]

  indexes {
    (actionInstanceId, event) [unique]
  }
}

Table forms {
  id String [pk]
  name String [not null]
  slug String [not null]
  communityId String [not null]
  community communities [not null]
  pubType pub_types [not null]
  pubTypeId String [not null]
  elements form_elements [not null]
  isArchived Boolean [not null, default: false]
  access FormAccessType [not null, default: 'private']
  isDefault Boolean [not null, default: false]
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  members form_memberships [not null]

  indexes {
    (name, communityId) [unique]
    (slug, communityId) [unique]
  }
}

Table form_elements {
  id String [pk]
  type ElementType [not null]
  fieldId String
  field pub_fields
  formId String [not null]
  order Int
  label String
  element StructuralFormElement
  component InputComponent
  config Json
  content String
  required Boolean
  form forms [not null]
  stage stages
  stageId String
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]

  indexes {
    (type, label, formId) [unique]
    (fieldId, formId) [unique]
  }
}

Table api_access_tokens {
  id String [pk]
  token String [unique, not null]
  name String [not null]
  description String
  communityId String [not null]
  community communities [not null]
  expiration DateTime [not null]
  issuedBy users
  issuedById String
  issuedAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
  accessRules api_access_permissions [not null]
  logs api_access_logs [not null]
  PubValueHistory pub_values_history [not null]
}

Table api_access_logs {
  id String [pk]
  accessTokenId String
  accessToken api_access_tokens
  timestamp DateTime [default: `now()`, not null]
  action String [not null]
}

Table api_access_permissions {
  id String [pk]
  apiAccessTokenId String [not null]
  apiAccessToken api_access_tokens [not null]
  scope ApiAccessScope [not null]
  accessType ApiAccessType [not null]
  constraints Json [note: '@type(ApiAccessPermissionConstraints, \'../types\', true, false, true)']
  createdAt DateTime [default: `now()`, not null]
  updatedAt DateTime [default: `now()`, not null]
}

Table membership_capabilities {
  role MemberRole [not null]
  type MembershipType [not null]
  capability Capabilities [not null]

  indexes {
    (role, type, capability) [pk]
  }
}

Table MemberGroupToUser {
  membergroupsId String [ref: > member_groups.id]
  usersId String [ref: > users.id]
}

Enum AuthTokenType {
  generic
  passwordReset
  signup
  verifyEmail
}

Enum CoreSchemaType {
  Boolean
  DateTime
  Email
  FileUpload
  MemberId
  Null
  Number
  NumericArray
  RichText
  String
  StringArray
  URL
  Vector3
}

Enum OperationType {
  insert
  update
  delete
}

Enum MemberRole {
  admin
  editor
  contributor
}

Enum Action {
  log
  pdf
  email
  pushToV6
  http
  move
  googleDriveImport
  datacite
}

Enum ActionRunStatus {
  scheduled
  success
  failure
}

Enum Event {
  pubEnteredStage
  pubLeftStage
  pubInStageForDuration
}

Enum FormAccessType {
  private
  inviteOnly
  public
}

Enum StructuralFormElement {
  h2
  h3
  p
  hr
}

Enum ElementType {
  pubfield
  structural
  button
}

Enum InputComponent {
  textArea
  textInput
  datePicker
  checkbox
  fileUpload
  memberSelect
  confidenceInterval
  checkboxGroup
  radioGroup
  richText
  selectDropdown
  multivalueInput
  relationBlock
}

Enum ApiAccessType {
  read
  write
  archive
}

Enum ApiAccessScope {
  community
  pub
  stage
  member
  pubType
}

Enum Capabilities {
  movePub
  createPub
  viewPub
  deletePub
  updatePubValues
  createRelatedPub
  createPubWithForm
  editPubWithForm
  createPubField
  archivePubField
  editPubField
  createPubType
  editPubType
  deletePubType
  runAction
  viewStage
  createStage
  manageStage
  deleteStage
  addPubMember
  removePubMember
  addStageMember
  removeStageMember
  addFormMember
  removeFormMember
  addCommunityMember
  removeCommunityMember
  manageMemberGroups
  addCommunity
  editCommunity
  createForm
  editForm
  archiveForm
  createApiToken
  revokeApiToken
}

Enum MembershipType {
  community
  stage
  pub
  form
}

Ref: pub_values_history.userId > users.id

Ref: pub_values_history.apiAccessTokenId > api_access_tokens.id

Ref: pub_values_history.actionRunId > action_runs.id

Ref: sessions.userId > users.id

Ref: auth_tokens.userId > users.id

Ref: pubs.pubTypeId > pub_types.id

Ref: pubs.communityId > communities.id

Ref: pubs.assigneeId > users.id

Ref: pubs.stageId > stages.id [delete: Set Null]

Ref: pubs.parentId - pubs.id [delete: Cascade]

Ref: pub_fields.pubFieldSchemaId > PubFieldSchema.id

Ref: pub_fields.communityId > communities.id

Ref: pub_values.fieldId > pub_fields.id

Ref: pub_values.pubId > pubs.id [delete: Cascade]

Ref: pub_values.relatedPubId > pubs.id [delete: Cascade]

Ref: pub_types.communityId > communities.id

Ref: _PubFieldToPubType.A > pub_fields.id [delete: Cascade]

Ref: _PubFieldToPubType.B > pub_types.id [delete: Cascade]

Ref: stages.communityId > communities.id

Ref: PubsInStages.pubId > pubs.id [delete: Cascade]

Ref: PubsInStages.stageId > stages.id [delete: Cascade]

Ref: move_constraint.stageId > stages.id [delete: Cascade]

Ref: move_constraint.destinationId > stages.id [delete: Cascade]

Ref: member_groups.communityId > communities.id [delete: Cascade]

Ref: community_memberships.communityId > communities.id [delete: Cascade]

Ref: community_memberships.userId > users.id [delete: Cascade]

Ref: community_memberships.memberGroupId > member_groups.id [delete: Cascade]

Ref: pub_memberships.pubId > pubs.id [delete: Cascade]

Ref: pub_memberships.userId > users.id [delete: Cascade]

Ref: pub_memberships.memberGroupId > member_groups.id [delete: Cascade]

Ref: stage_memberships.stageId > stages.id [delete: Cascade]

Ref: stage_memberships.userId > users.id [delete: Cascade]

Ref: stage_memberships.memberGroupId > member_groups.id [delete: Cascade]

Ref: form_memberships.formId > forms.id [delete: Cascade]

Ref: form_memberships.userId > users.id [delete: Cascade]

Ref: form_memberships.memberGroupId > member_groups.id [delete: Cascade]

Ref: form_memberships.pubId > pubs.id [delete: Cascade]

Ref: action_instances.stageId > stages.id [delete: Cascade]

Ref: action_runs.actionInstanceId > action_instances.id [delete: Cascade]

Ref: action_runs.pubId > pubs.id

Ref: action_runs.userId > users.id [delete: Set Null]

Ref: rules.actionInstanceId > action_instances.id [delete: Cascade]

Ref: forms.communityId > communities.id [delete: Cascade]

Ref: forms.pubTypeId > pub_types.id

Ref: form_elements.fieldId > pub_fields.id [delete: Cascade]

Ref: form_elements.formId > forms.id [delete: Cascade]

Ref: form_elements.stageId > stages.id [delete: Set Null]

Ref: api_access_tokens.communityId > communities.id [delete: Cascade]

Ref: api_access_tokens.issuedById > users.id [delete: Set Null]

Ref: api_access_logs.accessTokenId > api_access_tokens.id [delete: Set Null]

Ref: api_access_permissions.apiAccessTokenId > api_access_tokens.id [delete: Cascade]