asdasd

Tables (15)

attribute_definition

  • id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.id — NOT NULL
  • object_definition_id — uuid — Foreign key → object_definition.id — NOT NULL
  • api_slug — text — NOT NULL
  • name — text — NOT NULL
  • type — text — NOT NULL
  • is_required — boolean — NOT NULL
  • is_unique — boolean — NOT NULL
  • is_multi_value — boolean — NOT NULL
  • is_system — boolean — NOT NULL
  • is_archived — boolean — NOT NULL
  • config_json — jsonb
  • default_value_json — jsonb
  • sort_order — int — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

attribute_option

  • id — uuid — Primary key — NOT NULL
  • attribute_definition_id — uuid — Foreign key → attribute_definition.id — NOT NULL
  • label — text — NOT NULL
  • value — text — NOT NULL
  • color — text
  • sort_order — int — NOT NULL
  • is_archived — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL

list_attribute_definition

  • id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.id — NOT NULL
  • list_definition_id — uuid — Foreign key → list_definition.id — NOT NULL
  • api_slug — text — NOT NULL
  • name — text — NOT NULL
  • type — text — NOT NULL
  • is_required — boolean — NOT NULL
  • config_json — jsonb
  • sort_order — int — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

list_definition

  • id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.id — NOT NULL
  • object_definition_id — uuid — Foreign key → object_definition.id — NOT NULL
  • api_slug — text — NOT NULL
  • name — text — NOT NULL
  • is_archived — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

list_entry

  • id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.id — NOT NULL
  • list_definition_id — uuid — Foreign key → list_definition.id — NOT NULL
  • record_id — uuid — Foreign key → record.id — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

list_entry_value

  • id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.id — NOT NULL
  • list_entry_id — uuid — Foreign key → list_entry.id — NOT NULL
  • list_attribute_definition_id — uuid — Foreign key → list_attribute_definition.id — NOT NULL
  • text_value — text
  • number_value — numeric
  • date_value — date
  • timestamp_value — timestamptz
  • boolean_value — boolean
  • option_value — text
  • json_value — jsonb
  • currency_code — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

object_definition

  • id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.id — NOT NULL
  • api_slug — text — NOT NULL
  • singular_name — text — NOT NULL
  • plural_name — text — NOT NULL
  • kind — text — NOT NULL
  • standard_type — text
  • icon — text
  • is_active — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

record

  • id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.id — NOT NULL
  • object_definition_id — uuid — Foreign key → object_definition.id — NOT NULL
  • title — text — NOT NULL
  • created_by_user_id — uuid
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz
  • deleted_by_user_id — uuid
  • trash_expires_at — timestamptz

record_activity

  • id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.id — NOT NULL
  • record_id — uuid — Foreign key → record.id — NOT NULL
  • activity_type — text — NOT NULL
  • source_type — text
  • source_id — uuid
  • title — text — NOT NULL
  • summary — text
  • body — text
  • occurred_at — timestamptz — NOT NULL
  • metadata_json — jsonb
  • created_at — timestamptz — NOT NULL

record_note

  • id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.id — NOT NULL
  • record_id — uuid — Foreign key → record.id — NOT NULL
  • created_by_user_id — uuid
  • title — text
  • body — text — NOT NULL
  • is_private — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

record_relationship

  • id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.id — NOT NULL
  • relationship_definition_id — uuid — Foreign key → relationship_definition.id — NOT NULL
  • source_record_id — uuid — Foreign key → record.id — NOT NULL
  • target_record_id — uuid — Foreign key → record.id — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

record_value

  • id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.id — NOT NULL
  • record_id — uuid — Foreign key → record.id — NOT NULL
  • attribute_definition_id — uuid — Foreign key → attribute_definition.id — NOT NULL
  • text_value — text
  • number_value — numeric
  • date_value — date
  • timestamp_value — timestamptz
  • boolean_value — boolean
  • option_id — uuid — Foreign key → attribute_option.id
  • json_value — jsonb
  • currency_code — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

relationship_definition

  • id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.id — NOT NULL
  • source_object_definition_id — uuid — Foreign key → object_definition.id — NOT NULL
  • target_object_definition_id — uuid — Foreign key → object_definition.id — NOT NULL
  • api_slug — text — NOT NULL
  • name — text — NOT NULL
  • source_cardinality — text — NOT NULL
  • target_cardinality — text — NOT NULL
  • is_bidirectional — boolean — NOT NULL
  • is_archived — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

view_definition

  • id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.id — NOT NULL
  • target_type — text — NOT NULL
  • object_definition_id — uuid — Foreign key → object_definition.id
  • list_definition_id — uuid — Foreign key → list_definition.id
  • name — text — NOT NULL
  • layout_type — text — NOT NULL
  • filter_json — jsonb
  • sort_json — jsonb
  • visible_attribute_ids_json — jsonb
  • group_by_attribute_id — uuid
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

workspace

  • id — uuid — Primary key — NOT NULL
  • owner_user_id — uuid — NOT NULL
  • name — text — NOT NULL
  • default_locale — text — NOT NULL
  • default_currency_code — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL