Description
noneTable properties
| name | value |
|---|
| name | customer |
| created | 5/3/2009 12:00:00 AM |
| row count | 28 |
| Maximum size of a single row | 134 bytes |
Columns
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|
| customer_num | serial | | 4 | | no
| yes
| |
|
| |
| fname | char | | 15 | | yes
|
| |
|
| |
| lname | char | | 15 | | yes
|
| |
|
| |
| company | char | | 20 | | yes
|
| |
|
| |
| address1 | char | | 20 | | yes
|
| |
|
| |
| address2 | char | | 20 | | yes
|
| |
|
| |
| city | char | | 15 | | yes
|
| |
|
| |
| state | char | | 2 | | yes
|
| |
|
| |
| zipcode | char | | 5 | | yes
|
| |
|
| |
| phone | char | | 18 | | yes
|
| |
|
| |
Indexes
| name | description | column | comment |
|---|
| 100_1 | non-clustered index | customer_num |
|
| zip_ix | non-clustered index | zipcode |
|
Referenced by
Foreign key graph
Sample rows
| customer_num | fname | lname | company | address1 | address2 | city | state | zipcode | phone |
|---|
| 101
| Ludwig
| Pauli
| All Sports Supplies
| 213 Erstwild Court
|
| Sunnyvale
| CA
| 94086
| 408-789-8075
|
| 102
| Carole
| Sadler
| Sports Spot
| 785 Geary St
|
| San Francisco
| CA
| 94117
| 415-822-1289
|
| 103
| Philip
| Currie
| Phil's Sports
| 654 Poplar
| P. O. Box 3498
| Palo Alto
| CA
| 94303
| 415-328-4543
|
| 104
| Anthony
| Higgins
| Play Ball!
| East Shopping Cntr.
| 422 Bay Road
| Redwood City
| CA
| 94026
| 415-368-1100
|
| 105
| Raymond
| Vector
| Los Altos Sports
| 1899 La Loma Drive
|
| Los Altos
| CA
| 94022
| 415-776-3249
|
| 106
| George
| Watson
| Watson & Son
| 1143 Carver Place
|
| Mountain View
| CA
| 94063
| 415-389-8789
|
| 107
| Charles
| Ream
| Athletic Supplies
| 41 Jordan Avenue
|
| Palo Alto
| CA
| 94304
| 415-356-9876
|
| 108
| Donald
| Quinn
| Quinn's Sports
| 587 Alvarado
|
| Redwood City
| CA
| 94063
| 415-544-8729
|
| 109
| Jane
| Miller
| Sport Stuff
| Mayfair Mart
| 7345 Ross Blvd.
| Sunnyvale
| CA
| 94086
| 408-723-8789
|
| 110
| Roy
| Jaeger
| AA Athletics
| 520 Topaz Way
|
| Redwood City
| CA
| 94062
| 415-743-3611
|
Code
create table "informix".customer
(
customer_num serial not null ,
fname char(15),
lname char(15),
company char(20),
address1 char(20),
address2 char(20),
city char(15),
state char(2),
zipcode char(5),
phone char(18),
primary key (customer_num)
);
revoke all on "informix".customer from "public" as "informix";
create index "informix".zip_ix on "informix".customer (zipcode)
using btree ;