actor.usr_message_limited (view)
|
This is a database view, not a base table. It has no triggers, indexes, or FK constraints of its own. Querying this view may be more efficient than joining the underlying tables directly. |
Columns
| Column | Type | Nullable | Notes |
|---|---|---|---|
id |
|
Yes |
|
usr |
|
Yes |
|
title |
|
Yes |
|
message |
|
Yes |
|
create_date |
|
Yes |
|
deleted |
|
Yes |
|
read_date |
|
Yes |
|
sending_lib |
|
Yes |
|
pub |
|
Yes |
|
stop_date |
|
Yes |
|
editor |
|
Yes |
|
edit_date |
|
Yes |
View Definition
SELECT usr_message.id,
usr_message.usr,
usr_message.title,
usr_message.message,
usr_message.create_date,
usr_message.deleted,
usr_message.read_date,
usr_message.sending_lib,
usr_message.pub,
usr_message.stop_date,
usr_message.editor,
usr_message.edit_date
FROM actor.usr_message
WHERE usr_message.pub AND NOT usr_message.deleted;