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