oid_prefixes

10 rows


Description

This table contains OID prefixes for different communities or organizations. The application or administrator changing this table has to make sure that only one record is set to active.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('tdh_sys.oid_prefixes_id_seq'::regclass)
prefix bpchar 8 null
organization text 2147483647 null
active bool 1 null

Indexes

Constraint Name Type Sort Column(s)
pkey_tdh_is_oid_prefixes_id Primary key Asc id
in_tdh_is_oid_prefixes_active Performance Asc active
in_tdh_is_oid_prefixes_id Must be unique Asc id

Relationships