stores_demo - cust

Description

none

Table properties

name	value
name	cust_calls
created	5/3/2009 12:00:00 AM
row count	7
Maximum size of a single row	6,677 bytes

Columns

column	datatype	bytes	nulls	PK	FK
customer_num	integer	4	yes	composite PK	customer.customer_num
call_dtime	datetime	3080	yes	composite PK
user_id	char	32	yes
call_code	char	1	yes		call_type.call_code
call_descr	char	240	yes
res_dtime	datetime	3080	yes
res_descr	char	240	yes

Indexes

name	description	column
107_18	non-clustered index	customer_num, call_dtime
107_19	non-clustered index	customer_num
107_20	non-clustered index	call_code

References

name
call_type
customer

Foreign key graph

call_typecustomercust_calls

Foreign keys

name	column	comment
r107_19	customer_num
r107_20	call_code

Sample rows

customer_num	call_dtime	user_id	call_code	call_descr	res_dtime	res_descr
106	6/12/1998 8:20:00 AM	maryj	D	Order was received, but two of the cans of ANZ tennis balls within the case were empty	6/12/1998 8:25:00 AM	Authorized credit for two cans to customer, issued apology. Called ANZ buyer to report the QA proble
110	7/7/1998 10:24:00 AM	richc	L	Order placed one month ago (6/7) not received.	7/7/1998 10:30:00 AM	Checked with shipping (Ed Smith). Order sent yesterday- we were waiting for goods from ANZ. Next tim
119	7/1/1998 3:00:00 PM	richc	B	Bill does not reflect credit from previous order	7/2/1998 8:21:00 AM	Spoke with Jane Akant in Finance. She found the error and is sending new bill to customer
121	7/10/1998 2:05:00 PM	maryj	O	Customer likes our merchandise. Requests that we stock more types of infant joggers. Will call back	7/10/1998 2:06:00 PM	Sent note to marketing group of interest in infant joggers
127	7/31/1998 2:30:00 PM	maryj	I	Received Hero watches (item # 304) instead of ANZ watches		Sent memo to shipping to send ANZ item 304 to customer and pickup HRO watches. Should be done tomorr
116	11/28/1997 1:34:00 PM	mannyn	I	Received plain white swim caps (313 ANZ) instead of navy with team logo (313 SHM)	11/28/1997 4:47:00 PM	Shipping found correct case in warehouse and express mailed it in time for swim meet.
116	12/21/1997 11:24:00 AM	mannyn	I	Second complaint from this customer! Received two cases right-handed outfielder gloves (1 HRO) inste	12/27/1997 8:19:00 AM	Memo to shipping (Ava Brown) to send case of left-handed gloves, pick up wrong case; memo to billing

Code

create table "informix".cust_calls 
  (
    customer_num integer,
    call_dtime datetime year to minute,
    user_id char(32) 
        default user,
    call_code char(1),
    call_descr char(240),
    res_dtime datetime year to minute,
    res_descr char(240),
    primary key (customer_num,call_dtime) 
  );
revoke all on "informix".cust_calls from "public" as "informix";




alter table "informix".cust_calls add constraint (foreign key 
    (customer_num) references "informix".customer );
alter table "informix".cust_calls add constraint (foreign key 
    (call_code) references "informix".call_type );

stores_demo - tables - cust_calls

Description

Table properties

Columns

Indexes

References

Foreign key graph

Foreign keys

Sample rows

Code