Table

cm_co_extended_attributes

Description

Per-CO extended attribute definitions

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement

 

co_id

integer, foreign key

CO Record ID

cm_cos:id

 

name

varchar(64)

Database column name for attribute

 

 

display_name

varchar(64)

Display name for attribute

 

 

type

varchar(32)

Database type for attribute

  • INTEGER
  • TIMESTAMP
  • VARCHAR(32)

Once set, type cannot be changed

index

boolean

Create database index for attribute

  • true: Index
  • false: Do not index

 

  • No labels