Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
customer_type_extid | VARCHAR2 | 255 | Customer type external ID | ||||
customer_type_id | NUMBER | 39 | 0 | Customer type ID | |||
date_last_modified | TIMESTAMP | Date last modified | |||||
isinactive | VARCHAR2 | 3 | Item is inactive | ||||
name | VARCHAR2 | 31 | Name | ||||
parent_id | NUMBER | 39 | 0 | Child of |
PK Column Name |
---|
customer_type_id |
FK Name | PK Column Name | FK Table Name | FK Column Name | Key Seq |
---|---|---|---|---|
Customers_customer_types_fk | customer_type_id | Customers | customer_type_id | 1 |