← All articles

Tables & field types — Name tables and fields so they read like English

Names are the one thing in a workspace that's hard to change later — every report, rollup, and AI prompt refers to your tables and fields by name, so a clean name keeps everything downstream clean. Four rules keep them honest: • Tables are plural nouns. Customers, Deals, Bookings — so one record reads naturally as "a Customer." • Fields are descriptive singular phrases. Just Email, not cust_email — the table already supplies the scope. • No abbreviations. Spell it out: Expected close, not Exp Cls. It saves more time than it costs. • Relation fields name the other side, not the action. The field on Deals that points at Companies is simply Company — not company_id or linked_company. The payoff is readability: "Sum of Amount across Deals where Stage is Closed Won" is a sentence you can trust; SUM(deal_amt) WHERE stg = 'CW' is a guess at meaning. Watch for names that signal a deeper problem — Status1 / Status2 usually wants two real names like Stage and Health, and a Misc or Other field is often a sign you need a new table or to split an existing one.
Nothing here answered it? Ask us directly — we usually reply within one working day.

Made with RowFold