maludb_core.malu$memory
app@127.0.0.1:5432/maludbmaludb_core.malu$memory
Inspect rows, columns, and indexes using PostgreSQL catalog metadata.
| # | Column | Type | Nullable | Default | Description |
|---|---|---|---|---|---|
| 1 | memory_id |
bigint (int8) | NO | nextval('"malu$memory_memory_id_seq"'::regclass) |
|
| 2 | owner_schema |
name | NO | "current_schema"() |
|
| 3 | memory_kind |
text | NO | |
|
| 4 | title |
text | YES | |
|
| 5 | summary |
text | YES | |
|
| 6 | payload_jsonb |
jsonb json | NO | '{}'::jsonb |
|
| 7 | occurred_at |
timestamp with time zone (timestamptz) | YES | |
|
| 8 | occurred_until |
timestamp with time zone (timestamptz) | YES | |
|
| 9 | recorded_at |
timestamp with time zone (timestamptz) | NO | now() |
|
| 10 | sensitivity |
text | NO | 'internal'::text |
|
| 11 | lifecycle_state |
text | NO | 'active'::text |
|
| 12 | consolidated_into_memory_id |
bigint (int8) | YES | |
|
| 13 | created_at |
timestamp with time zone (timestamptz) | NO | now() |
|
| 14 | updated_at |
timestamp with time zone (timestamptz) | NO | now() |
|
| 15 | event_time |
timestamp with time zone (timestamptz) | YES | |
|
| 16 | valid_time_start |
timestamp with time zone (timestamptz) | YES | now() |
|
| 17 | valid_time_end |
timestamp with time zone (timestamptz) | YES | |
|
| 18 | transaction_time_start |
timestamp with time zone (timestamptz) | NO | now() |
|
| 19 | transaction_time_end |
timestamp with time zone (timestamptz) | YES | |
|
| 20 | source_time |
timestamp with time zone (timestamptz) | YES | |
|
| 21 | verification_time |
timestamp with time zone (timestamptz) | YES | |
|
| 22 | stale_after |
timestamp with time zone (timestamptz) | YES | |
|
| 23 | valid_time_range |
tstzrange | YES | tstzrange(valid_time_start, valid_time_end, '[)'::text) |
|
| 24 | transaction_time_range |
tstzrange | YES | tstzrange(transaction_time_start, transaction_time_end, '[)'::text) |
|
| 25 | fts_tsv |
tsvector vector | YES | ((setweight(to_tsvector('english'::regconfig, ((COALESCE(title, ''::text) || ' '::text) || COALESCE(memory_kind, ''::text))), 'A'::"char") || setweight(to_tsvector('english'::regconfig, COALESCE(summary, ''::text)), 'B'::"char")) || setweight(jsonb_to_tsvector('english'::regconfig, COALESCE(payload_jsonb, '{}'::jsonb), '["string"]'::jsonb), 'B'::"char")) |
|
| 26 | issue_closed_at |
timestamp with time zone (timestamptz) | YES | |