Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| bag_id | bpchar | 6 | √ | to_char(nextval('bag_id_seq'::regclass), '"BAG"-FM00'::text) |
|
|
|||||
| manufacturer | varchar | 32 | null |
|
|
||||||
| age | varchar | 16 | null |
|
|
||||||
| material | varchar | 16 | null |
|
|
||||||
| thickness | int4 | 10 | null |
|
|
||||||
| dimensions | varchar | 16 | null |
|
|
||||||
| resealable | bool | 1 | false |
|
|
||||||
| thick | bool | 1 | false |
|
|
||||||
| acid | bool | 1 | false |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| bags_pkey | Primary key | Asc | bag_id |
| bags_key | Must be unique | Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc | manufacturer + age + material + thickness + dimensions + resealable + thick + acid |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| bags_bag_id_check | ((bag_id ~ '^BAG-\d{2}$'::text)) |
| bags_dimensions_check | (((dimensions)::text ~ '^((\d+) |(\d+\/\d+) |(\d+) (\d+\/\d+) )x( (\d+)| (\d+\/\d+)| (\d+) (\d+\/\d+))$'::text)) |
| bags_thickness_check | ((thickness > 0)) |
Relationships
Close relationships within degrees of separation
