Skip to content

xpms.playbook_column

TableRow level security on

The Playbook column map (canon/map/playbook-columns.yaml): every column of every sheet with one disposition.

Primary key: sheet_name, ordinal

Columns of xpms.playbook_column
ColumnTypeNullableDescription
sheet_namexpms.canon_textNoSheet.References xpms.playbook_sheet.sheet_name
ordinalintegerNoColumn position, 1 for A.
letterxpms.canon_codeNoColumn letters.
headerxpms.canon_textYesHeader text; NULL for Cover Page columns, which have no header row.
column_keyxpms.canon_codeNosnake_case key of the column.
dispositionxpms.canon_codeNofield, computed or presentation.
targetxpms.canon_textYesschema.table.column the column lands in or feeds.
data_typexpms.canon_codeYesData type of the target field.
notexpms.canon_textYesTransform, source formula or presentation reason.