Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| material_num | serial | 10 | √ | nextval('material_material_num_seq'::regclass) |
|
|
||||
| material_code | varchar | 255 | null |
|
|
|||||
| material_name | varchar | 255 | null |
|
|
|||||
| status | int4 | 10 | √ | 1 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| material_pkey | Primary key | Asc | material_num |
| material_material_code_Idx | Must be unique | Asc | material_code |
| material_material_name_Idx | Must be unique | Asc | material_name |
| uc_material_code | Must be unique | Asc | material_code |
| uc_material_name | Must be unique | Asc | material_name |
Relationships
Close relationships within degrees of separation
