ㅁㄴㅇㅁㄴ

Tables (27)

activity_event

  • activity_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → attribute.attribute_id — NOT NULL
  • kind — text — NOT NULL
  • actor_id — uuid — Foreign key → actor.actor_id — NOT NULL
  • occurred_at — timestamptz — NOT NULL
  • recorded_at — timestamptz — NOT NULL
  • list_id — uuid — Foreign key → list_entry.list_id
  • entry_id — uuid — Foreign key → list_entry.entry_id
  • attribute_id — uuid — Foreign key → attribute.attribute_id
  • payload — jsonb — NOT NULL

activity_record

  • workspace_id — uuid — Foreign key → crm_record.record_id — NOT NULL
  • activity_id — uuid — Foreign key → activity_event.activity_id — NOT NULL
  • record_id — uuid — Foreign key → crm_record.record_id — NOT NULL

actor

  • actor_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.workspace_id — NOT NULL
  • actor_type — text — NOT NULL
  • member_id — uuid — Foreign key → workspace_member.workspace_id
  • token_id — uuid — Foreign key → api_token.workspace_id

api_token

  • token_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.workspace_id — NOT NULL
  • label — text — NOT NULL
  • revoked_at — timestamptz

app_user

  • user_id — uuid — Primary key — NOT NULL
  • login_email — text — NOT NULL
  • display_name — text — NOT NULL
  • created_at — timestamptz — NOT NULL

attribute

  • attribute_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → attribute.workspace_id — NOT NULL
  • object_id — uuid — Foreign key → object_definition.workspace_id
  • list_id — uuid — Foreign key → crm_list.list_id
  • api_slug — text — NOT NULL
  • title — text — NOT NULL
  • description — text
  • type — attribute_type — Foreign key → attribute.type — NOT NULL
  • is_required — boolean — NOT NULL
  • is_unique — boolean — NOT NULL
  • is_multiselect — boolean — NOT NULL
  • is_system — boolean — NOT NULL
  • is_writable — boolean — NOT NULL
  • is_archived — boolean — NOT NULL
  • is_default_value_enabled — boolean — NOT NULL
  • default_value — jsonb
  • config — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL

attribute_record_target

  • workspace_id — uuid — Foreign key → object_definition.workspace_id — NOT NULL
  • attribute_id — uuid — Foreign key → attribute.attribute_id — NOT NULL
  • target_object_id — uuid — Foreign key → object_definition.workspace_id — NOT NULL
  • type — attribute_type — Foreign key → attribute.type — NOT NULL

crm_list

  • list_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → actor.actor_id — NOT NULL
  • api_slug — text — NOT NULL
  • name — text — NOT NULL
  • current_object_id — uuid — Foreign key → object_definition.workspace_id — NOT NULL
  • workspace_access — access_level — NOT NULL
  • created_by_actor_id — uuid — Foreign key → actor.actor_id — NOT NULL
  • created_at — timestamptz — NOT NULL

crm_record

  • record_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → actor.actor_id — NOT NULL
  • object_id — uuid — Foreign key → object_definition.workspace_id — NOT NULL
  • created_by_actor_id — uuid — Foreign key → actor.actor_id — NOT NULL
  • created_at — timestamptz — NOT NULL

entry_attribute_value

  • value_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → actor.actor_id — NOT NULL
  • list_id — uuid — Foreign key → attribute.list_id — NOT NULL
  • entry_id — uuid — Foreign key → list_entry.entry_id — NOT NULL
  • attribute_id — uuid — Foreign key — NOT NULL
  • type — attribute_type — Foreign key → attribute.type — NOT NULL
  • payload — jsonb
  • option_id — uuid — Foreign key → select_option.option_id
  • status_id — uuid — Foreign key → status.status_id
  • target_object_id — uuid — Foreign key
  • target_record_id — uuid — Foreign key → crm_record.record_id
  • referenced_actor_id — uuid — Foreign key → actor.actor_id
  • interaction_owner_actor_id — uuid — Foreign key → actor.actor_id
  • created_by_actor_id — uuid — Foreign key → actor.actor_id — NOT NULL
  • active_from — timestamptz — NOT NULL
  • active_until — timestamptz

list_entry

  • entry_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → actor.actor_id — NOT NULL
  • list_id — uuid — Foreign key → crm_list.list_id — NOT NULL
  • parent_object_id — uuid — Foreign key → crm_record.object_id — NOT NULL
  • parent_record_id — uuid — Foreign key → crm_record.record_id — NOT NULL
  • created_by_actor_id — uuid — Foreign key → actor.actor_id — NOT NULL
  • created_at — timestamptz — NOT NULL

list_member_access

  • workspace_id — uuid — Foreign key → workspace_member.workspace_id — NOT NULL
  • list_id — uuid — Foreign key → crm_list.list_id — NOT NULL
  • member_id — uuid — Foreign key → workspace_member.workspace_id — NOT NULL
  • level — access_level — NOT NULL

list_team_access

  • workspace_id — uuid — Foreign key → team.workspace_id — NOT NULL
  • list_id — uuid — Foreign key → crm_list.list_id — NOT NULL
  • team_id — uuid — Foreign key → team.workspace_id — NOT NULL
  • level — access_level — NOT NULL

object_definition

  • object_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.workspace_id — NOT NULL
  • api_slug — text — NOT NULL
  • singular_noun — text — NOT NULL
  • plural_noun — text — NOT NULL
  • is_standard — boolean — NOT NULL
  • is_enabled — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL

record_attribute_value

  • value_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → actor.actor_id — NOT NULL
  • object_id — uuid — Foreign key → attribute.object_id — NOT NULL
  • record_id — uuid — Foreign key → crm_record.record_id — NOT NULL
  • attribute_id — uuid — Foreign key — NOT NULL
  • type — attribute_type — Foreign key → attribute.type — NOT NULL
  • payload — jsonb
  • option_id — uuid — Foreign key → select_option.option_id
  • status_id — uuid — Foreign key → status.status_id
  • target_object_id — uuid — Foreign key
  • target_record_id — uuid — Foreign key → crm_record.record_id
  • referenced_actor_id — uuid — Foreign key → actor.actor_id
  • interaction_owner_actor_id — uuid — Foreign key → actor.actor_id
  • created_by_actor_id — uuid — Foreign key → actor.actor_id — NOT NULL
  • active_from — timestamptz — NOT NULL
  • active_until — timestamptz

saved_view

  • view_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → attribute.workspace_id — NOT NULL
  • object_id — uuid — Foreign key → object_definition.workspace_id
  • list_id — uuid — Foreign key → crm_list.list_id
  • title — text — NOT NULL
  • view_type — text — NOT NULL
  • position — integer — NOT NULL
  • group_attribute_id — uuid — Foreign key → attribute.attribute_id
  • group_attribute_type — attribute_type — Foreign key → attribute.type — NOT NULL
  • display_config — jsonb — NOT NULL
  • filter_ast — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL

select_option

  • option_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → attribute.workspace_id — NOT NULL
  • attribute_id — uuid — Foreign key → attribute.attribute_id — NOT NULL
  • type — attribute_type — Foreign key → attribute.type — NOT NULL
  • title — text — NOT NULL
  • is_archived — boolean — NOT NULL
  • position — integer — NOT NULL

status

  • status_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → attribute.workspace_id — NOT NULL
  • attribute_id — uuid — Foreign key → attribute.attribute_id — NOT NULL
  • type — attribute_type — Foreign key → attribute.type — NOT NULL
  • title — text — NOT NULL
  • is_archived — boolean — NOT NULL
  • target_time_in_status — interval
  • celebration_enabled — boolean — NOT NULL
  • position — integer — NOT NULL

team

  • team_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.workspace_id — NOT NULL
  • name — text — NOT NULL

team_member

  • workspace_id — uuid — Foreign key → workspace_member.workspace_id — NOT NULL
  • team_id — uuid — Foreign key → team.workspace_id — NOT NULL
  • member_id — uuid — Foreign key → workspace_member.workspace_id — NOT NULL

view_column

  • workspace_id — uuid — Foreign key → view_field.field_id — NOT NULL
  • view_id — uuid — Foreign key → view_field.field_id — NOT NULL
  • field_id — uuid — Foreign key → view_field.field_id — NOT NULL
  • position — integer — NOT NULL
  • label_override — text
  • is_visible — boolean — NOT NULL
  • format_config — jsonb — NOT NULL

view_field

  • field_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → saved_view.view_id — NOT NULL
  • view_id — uuid — Foreign key → saved_view.view_id — NOT NULL
  • root_kind — text — NOT NULL

view_field_step

  • step — integer — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → attribute.attribute_id — NOT NULL
  • view_id — uuid — Foreign key → view_field.field_id — NOT NULL
  • field_id — uuid — Foreign key → view_field.field_id — NOT NULL
  • attribute_id — uuid — Foreign key → attribute.attribute_id — NOT NULL

view_kanban_stage

  • workspace_id — uuid — Foreign key → status.status_id — NOT NULL
  • view_id — uuid — Foreign key → saved_view.view_id — NOT NULL
  • status_id — uuid — Foreign key → status.status_id — NOT NULL
  • attribute_id — uuid — Foreign key → status.status_id — NOT NULL
  • position — integer — NOT NULL
  • is_visible — boolean — NOT NULL
  • is_collapsed — boolean — NOT NULL

view_sort

  • priority — integer — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → view_field.field_id — NOT NULL
  • view_id — uuid — Foreign key → view_field.field_id — NOT NULL
  • field_id — uuid — Foreign key → view_field.field_id — NOT NULL
  • direction — text — NOT NULL
  • value_component — text

workspace

  • workspace_id — uuid — Primary key — NOT NULL
  • name — text — NOT NULL
  • created_at — timestamptz — NOT NULL

workspace_member

  • member_id — uuid — Primary key — NOT NULL
  • workspace_id — uuid — Foreign key → workspace.workspace_id — NOT NULL
  • user_id — uuid — Foreign key → app_user.user_id — NOT NULL
  • role — text — NOT NULL
  • is_suspended — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL