flexfile_spec: File specification for the FlexFile

In Technomics/readflexfile: Read FlexFile data

File specification for the FlexFile

Description

A list containing two data frames: fields and tables.

Usage

flexfile_spec

Format

An object of class list of length 2.

tables

tables is a data frame with 29 rows and 7 variables:

table

The table name in the specification

entity

The entity name in the specification

snake_table

A snake_case version of table

type

Either submission or enum

is_scalar

Boolean whether the table is a list of scalars or a data table

excel_3part

The "part" in the 3-Part Template

excel_3part_table

The table name in the 3-Part Template

fields

fields is a data frame with 171 rows and 10 variables:

table

The table name in the specification

field

The field name in the specification

snake_name

A snake_case version of field

safe_name

A database-safe version of field

type

SQL data type for the field

pk

Boolean if the field is a primary key

fk_table

Foreign key constraint table, if applicable

fk_field

Foreign key constraint field, if applicable

optional

Boolean if the field is optional or not

excel_3part_name

The field name in the 3-Part Template

See Also

Other Data Specs: maintrepair_spec, quantity_spec, techdatareport_spec

Technomics/readflexfile documentation built on Jan. 10, 2024, 6:25 p.m.