Source-derived document; reported behaviour, inference and evidence gaps are identified in the text.

Return to: C06 — Conceptual Information Model — topic detail

System catalog attributes

Data: System catalog attributes

syscolatt.unl contains pipe-delimited table and column records with numeric attributes, flags, and optional conditions. Customer city is shown with numeric attributes 1 and 0 followed by four n flags. Orders includes order number, order date, purchase-order number, and shipping instructions with numeric attributes including 2, 3, 4, and 12. Items includes item number, order number, stock number, manufacturer code, quantity, and total price, with first numeric attributes 5 through 10 and an additional total-price record with attribute 14. E0009

The item total-price records include conditional entries: one has second numeric attribute 5 with condition >=500, while another has second numeric attribute 4 with condition <500. Stock description and unit price have first numeric attributes 11 and 13 and second numeric attribute 4. These catalog labels describe fields and conditions; they do not, by themselves, establish application state transitions. E0009