illbatch_statuses

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null

Status ID

name VARCHAR 100 null

Name of status

code VARCHAR 20 null
illbatches.status_code illbatches_sfk N

Unique, immutable code for status

is_system BIT 0 null

Is this status required for system operation

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
u_illbatchstatuses__code Must be unique Asc code

Relationships