api.total_info_view
Description
total_info_view web view
Table Definition
CREATE VIEW total_info_view AS (
WITH l AS (
SELECT count(*) AS logs
FROM api.logbook
), s AS (
SELECT count(*) AS stays
FROM api.stays
), m AS (
SELECT count(*) AS moorages
FROM api.moorages
)
SELECT l.logs,
s.stays,
m.moorages
FROM l,
s,
m
)
Columns
| Name | Type | Default | Nullable |
|---|---|---|---|
| logs | bigint | true | |
| moorages | bigint | true | |
| stays | bigint | true |
Referenced Tables
| Name | Columns | Comment | Type |
|---|---|---|---|
| api.logbook | 42 | Stores generated logbook | BASE TABLE |
| api.stays | 14 | Stores generated stays | BASE TABLE |
| api.moorages | 13 | Stores generated moorages | BASE TABLE |
Relations
erDiagram
"api.total_info_view" {
bigint logs ""
bigint moorages ""
bigint stays ""
}
Generated by tbls