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_aggregateordertypesC

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