api.logs_view
Description
Logs web view
Table Definition
CREATE VIEW logs_view AS (
SELECT id,
name,
_from AS "from",
_from_time AS started,
_to AS "to",
_to_time AS ended,
distance,
duration,
_from_moorage_id,
_to_moorage_id,
(user_data -> 'tags'::text) AS tags,
updated_at
FROM api.logbook l
WHERE ((name IS NOT NULL) AND (_to_time IS NOT NULL))
ORDER BY _from_time DESC
)
Columns
| Name | Type | Default | Nullable |
|---|---|---|---|
| _from_moorage_id | integer | true | |
| _to_moorage_id | integer | true | |
| distance | numeric | true | |
| duration | interval | true | |
| ended | timestamp with time zone | true | |
| from | text | true | |
| id | integer | true | |
| name | text | true | |
| started | timestamp with time zone | true | |
| tags | jsonb | true | |
| to | text | true | |
| updated_at | timestamp with time zone | true |
Referenced Tables
| Name | Columns | Comment | Type |
|---|---|---|---|
| api.logbook | 43 | The logbook table stores vessel navigation entries with timestamps, locations, and trip metrics. RLS policies filter by vessel_id automatically. These indexes optimize different query patterns while minimizing storage. | BASE TABLE |
Relations
erDiagram
"api.logs_view" {
integer _from_moorage_id ""
integer _to_moorage_id ""
numeric distance ""
interval duration ""
timestamp_with_time_zone ended ""
text from ""
integer id ""
text name ""
timestamp_with_time_zone started ""
jsonb tags ""
text to ""
timestamp_with_time_zone updated_at ""
}
Generated by tbls