• 0 Posts
  • 7 Comments
Joined 3 months ago
cake
Cake day: March 24th, 2024

help-circle






  • records can’t be duplicated in the database, the activity id is a unique key:

    lemmy=# \d sent_activity
                                                   Table "public.sent_activity"
               Column            |           Type           | Collation | Nullable |                  Default
    -----------------------------+--------------------------+-----------+----------+-------------------------------------------
     id                          | bigint                   |           | not null | nextval('sent_activity_id_seq'::regclass)
     ap_id                       | text                     |           | not null |
     data                        | json                     |           | not null |
     sensitive                   | boolean                  |           | not null |
     published                   | timestamp with time zone |           | not null | now()
     send_inboxes                | text[]                   |           | not null |
     send_community_followers_of | integer                  |           |          |
     send_all_instances          | boolean                  |           | not null |
     actor_type                  | actor_type_enum          |           | not null |
     actor_apub_id               | text                     |           |          |
    Indexes:
        "sent_activity_pkey" PRIMARY KEY, btree (id)
        "sent_activity_ap_id_key" UNIQUE CONSTRAINT, btree (ap_id)