asset.active_copy_alert (view)

↑ asset schema

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

Column	Type	Nullable
id	`bigint`	Yes
alert_type	`integer`	Yes
copy	`bigint`	Yes
temp	`boolean`	Yes
create_time	`timestamp with time zone`	Yes
create_staff	`bigint`	Yes
note	`text`	Yes
ack_time	`timestamp with time zone`	Yes
ack_staff	`bigint`	Yes

bigint

Yes

alert_type

integer

Yes

copy

bigint

Yes

temp

boolean

Yes

create_time

timestamp with time zone

Yes

create_staff

bigint

Yes

note

text

Yes

ack_time

timestamp with time zone

Yes

ack_staff

bigint

Yes

View Definition

 SELECT copy_alert.id,
    copy_alert.alert_type,
    copy_alert.copy,
    copy_alert.temp,
    copy_alert.create_time,
    copy_alert.create_staff,
    copy_alert.note,
    copy_alert.ack_time,
    copy_alert.ack_staff
   FROM asset.copy_alert
  WHERE copy_alert.ack_time IS NULL;