maintrepair_spec: File specification for the M&R Report

In Technomics/readflexfile: Read FlexFile data

File specification for the M&R Report

Description

A list containing two data frames: fields and tables.

Usage

maintrepair_spec

Format

An object of class list of length 2.

tables

tables is a data frame with 6 rows and 5 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

fields

fields is a data frame with 72 rows and 9 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 field is optional or required

See Also

Other Data Specs: flexfile_spec, quantity_spec, techdatareport_spec

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