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