Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| code | VARCHAR | 80 | null |
|
|
|||||||||
| description | VARCHAR | 200 | √ | null |
|
|
||||||||
| can_be_added_manually | TINYINT | 3 | 1 |
|
|
|||||||||
| credit_number_enabled | BIT | 0 | 0 |
|
|
Is autogeneration of credit number enabled for this credit type |
||||||||
| is_system | BIT | 0 | 0 |
|
|
|||||||||
| archived | BIT | 0 | 0 |
|
|
boolean flag to denote if this till is archived or not |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | code |
Relationships
Close relationships within degrees of separation
