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