Table: CUSTOMER
 Index > Table Index > CUSTOMER
 
Description:
 
No description available.
 
Columns
 
Field Name Data Type Allow Null Character Set Default
CUST_NO INT No
CUSTOMER VARCHAR(25) No NONE
CONTACT_FIRST VARCHAR(15) Yes NONE
CONTACT_LAST VARCHAR(20) Yes NONE
PHONE_NO VARCHAR(20) Yes NONE
ADDRESS_LINE1 VARCHAR(30) Yes NONE
ADDRESS_LINE2 VARCHAR(30) Yes NONE
CITY VARCHAR(25) Yes NONE
STATE_PROVINCE VARCHAR(15) Yes NONE
COUNTRY VARCHAR(15) Yes NONE
POSTAL_CODE VARCHAR(12) Yes NONE
ON_HOLD CHAR(1) Yes NONE DEFAULT NULL
 
Indices
 
Index Name FieldName Unique Active Descending Description
CUSTNAMEX CUSTOMER No Yes No No description available.
CUSTREGION CITY No Yes No No description available.
COUNTRY No Yes No No description available.
 
Permissions:
 
User Select Insert Delete Update Reference
User: PUBLIC Yes Yes Yes Yes Yes
User: SYSDBA Yes Yes Yes Yes Yes
 
 
Dependent Objects
 
Object Type Name Field
Trigger CHECK_10 ON_HOLD
Trigger CHECK_27 ON_HOLD, CUST_NO
Trigger CHECK_28 ON_HOLD, CUST_NO
Trigger CHECK_9 ON_HOLD
Procedure MAIL_LABEL ADDRESS_LINE1, ADDRESS_LINE2, CITY, CONTACT_LAST, CONTACT_FIRST, COUNTRY, POSTAL_CODE, STATE_PROVINCE, CUSTOMER, CUST_NO
Trigger SET_CUST_NO CUST_NO
Procedure SHIP_ORDER ON_HOLD, CUST_NO
 
Created using FBDoc