pulse_card


Description

{“what”:“关联一次脉冲与一张卡片的连接记录,含展示顺序和导出开关。”,“why”:“没有它则无法知道哪些卡片属于哪个脉冲及其顺序。”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.288328258+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“自增整数主键,唯一标识一行关联记录。”,“why”:“无它则无法稳定引用或更新单条关联。”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.303005503+00:00”}

pulse_id int4 10 null
pulse.id fk_pulse_card_ref_pulse_id C

{“what”:“所属脉冲的ID,引用pulse表的主键。”,“why”:“无它则不知道卡片属于哪个脉冲。”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.316429066+00:00”}

card_id int4 10 null
report_card.id fk_pulse_card_ref_card_id C

{“what”:“关联的卡片ID,引用card表的主键。”,“why”:“无它则不知道脉冲包含哪些卡片。”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.339452082+00:00”}

position int4 10 null

{“what”:“卡片在脉冲内的显示顺序,从0或1开始递增。”,“why”:“无它则卡片顺序不确定,展示混乱。”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.355057224+00:00”}

include_csv bool 1 false

{“what”:“是否在导出中包含CSV格式,默认否。”,“why”:“无它则无法控制导出格式,用户选择丢失。”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.369564589+00:00”}

include_xls bool 1 false

{“what”:“是否在导出中包含XLS格式,默认否。”,“why”:“无它则无法控制导出格式,用户选择丢失。”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.388740333+00:00”}

dashboard_card_id int4 10 √ null
report_dashboardcard.id fk_pulse_card_ref_pulse_card_id C

{“what”:“关联的仪表盘卡片ID,可能引用dashboard_card表。”,“why”:“无它则无法关联到仪表盘卡片,可能用于跳转或引用。”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.411302501+00:00”}

entity_id bpchar 21 √ null

{“what”:“关联的实体标识符,可能是UUID或字符串。”,“why”:“无它则无法确定具体实体,可能用于多态关联。”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.434676088+00:00”}

format_rows bool 1 √ true

{“what”:“是否格式化行,默认启用。”,“why”:“无它则无法控制行格式,影响显示效果。”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.452545227+00:00”}

pivot_results bool 1 √ false

{“what”:“是否对结果进行透视,默认关闭。”,“why”:“无它则无法控制结果透视,影响数据展示方式。”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.465975398+00:00”}

Indexes

Constraint Name Type Sort Column(s)
pulse_card_pkey Primary key Asc id
idx_pulse_card_card_id Performance Asc card_id
idx_pulse_card_dashboard_card_id Performance Asc dashboard_card_id
idx_pulse_card_pulse_id Performance Asc pulse_id
pulse_card_entity_id_key Must be unique Asc entity_id

Relationships