paste #PkK
:
Table "public.table_mutation"
Column | Type | Collation | Nullable | Default
---------------------+--------------------------+-----------+----------+--------------------------------------------
id | bigint | | not null | nextval('table_mutation_id_seq'::regclass)
transaction_at | timestamp with time zone | | not null |
action_at | timestamp with time zone | | not null |
txid | bigint | | |
action | text | | not null |
administrator_id | integer | | |
pg_username | text | | |
pg_application_name | text | | |
table_name | text | | not null |
entity_id | text | | |
mutations | hstore | | |
schema | text | | |
Indexes:
"table_mutation_pkey" PRIMARY KEY, btree (id)
"table_mutation_idx" btree (schema, table_name, entity_id, transaction_at DESC)
Check constraints:
"table_mutation_action_check" CHECK (action = ANY (ARRAY['I'::text, 'D'::text, 'U'::text]))
TABLE "public.table_mutation" COLUMN | TYPE | COLLATION | Nullable | DEFAULT
---------------------+--------------------------+-----------+----------+--------------------------------------------
id | bigint | | NOT NULL | nextval('table_mutation_id_seq'::regclass) transaction_at | timestamp with time zone | | NOT NULL | action_at | timestamp with time zone | | NOT NULL | txid | bigint | | | action | text | | NOT NULL | administrator_id | integer | | | pg_username | text | | | pg_application_name | text | | | table_name | text | | NOT NULL | entity_id | text | | | mutations | hstore | | | SCHEMA | text | | | Indexes: "table_mutation_pkey" PRIMARY KEY, btree (id) "table_mutation_idx" btree (SCHEMA, table_name, entity_id, transaction_at DESC) CHECK constraints: "table_mutation_action_check" CHECK (action = ANY (ARRAY['I'::text, 'D'::text, 'U'::text]))
-- Formatted by pgFormatter::Beautify