A table stores the information of an application in rows, each row holding one or more pieces of information in its [[Invantive Studio/Repository/Applications/Table Columns|columns]], such as all relevant information on a person. The tables of an application are listed under the application as "Data Objects"; each table holds the folders "Columns", "Indexes", "Referential Constraints", "Attribute Rules", "Used by Business Objects" and "Used by Referential Constraints". The tables of Invantive Estate: ![[20261004-studio-tables.png]] The options of a table decide whether it is created in the database, whether it keeps [[Invantive Studio/Repository/Concepts/History|history]], whether it takes part in [[Invantive Studio/Repository/Concepts/Partition|partitioning]] and which rights the roles of the application get on it. A table usually has a [[Invantive Studio/Repository/Concepts/Business Object|business object]] of the same name through which its rows are read and changed. ## Fields The details of a table show these fields: - "Application Code": Unique alphanumeric code of the application. - "Code": Unique alphanumeric code. - "Name": Name of the table. - "Legacy Name": Original name of the table in a legacy system from which it was migrated to Invantive Producer. - "Default Reference Columns": Columns of the table that are shown where another row refers to it. - "Default Select Columns": Columns of the table that are selected by default. - "Label Singular": Label of the table for one row, as a resource code. - "Label Plural": Label of the table for several rows, as a resource code. - "Label Singular as Reference": Label singular when referenced. - "Label Plural as Reference": Label plural when referenced. - "Create": Whether the table will be created. - "Autocompleted": Whether this table was added by autocomplete. - "Interface": Whether this table is used to load/extract data from the actual application. - "Maintain History": Whether history will be maintained. - "Derived": Whether the contents of this table are fully derived from data in other tables. - "Show History": Whether history will be shown. - "Partition": Whether the contents of this table are to be partitioned. - "Number of Rows": Expected number of rows, used for sizing. - "Definition": Functional definition of what a row of the table holds. - "Example": Functional example. - "Documentation": Documentation on the table. - "Grant Select": Whether the user may select. - "Grant Insert": Whether the user may insert. - "Grant Update": Whether the user may update. - "Grant Delete": Whether the user may delete. - "Attach Documents": Whether documents can be attached to business objects of this type. - "Data Category": Category on how the table is populated. - "Icon (URL)": URL for the icon of this table. ## Tabs The summary window of a table shows its related rows on these tabs: - [[Invantive Studio/Repository/Applications/Applications|Application]] - [[Invantive Studio/Repository/Applications/Table Columns|Table Columns]] - [[Invantive Studio/Repository/Applications/Indexes|Indexes]] - [[Invantive Studio/Repository/Applications/Attribute Rules|Attribute Rules]] - [[Invantive Studio/Repository/Applications/View Elements|View Elements]] - [[Invantive Studio/Repository/Applications/Referential Constraints|Referential Constraints]]