ㅁㄴㅇㅁㄴ
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