| Name | Data type | Not Null? | Primary key? | Default | Comment |
|---|---|---|---|---|---|
| id | integer | Yes | Yes | nextval('record_types_id_seq'::regclass) | Unique identifier |
| link_tbl | character varying(80) | No | No | Record type; CUST = used for customers INV = used for inventory | |
| user_type | character varying(40) | No | No | Type created by user | |
| color_text | bigint | No | No | Text colour | |
| color_back | bigint | No | No | Background colour |
| Name | Type | Definition | Comment |
|---|---|---|---|
| bve_user_type_pkey | Primary key | (id) |