aggregateordertypes

7 rows


Description

Lookup table for Aggregate Order Types. Table is referenced by the AggregateDatasets table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
aggregateordertypeid serial 10 √ nextval('ndb.seq_aggregateordertypes_aggregateordertypeid'::regclass)
aggregatedatasets.aggregateordertypeid fk_aggregatedatasets_aggregateordertypes C

An arbitrary Aggregate Order Type identification number.

aggregateordertype varchar 64 null

The Aggregate Order Type.

notes text 2147483647 √ null

Free form notes or comments about the Aggregate Order Type.

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
aggregateordertypes_pkey Primary key Asc aggregateordertypeid

Relationships