Description
noneTable properties
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| VendorNo | Float | 8 | | no
| yes
| |
| |
| VendorName | Char | 30 | | yes
|
| |
| |
| Address1 | Char | 30 | | yes
|
| |
| |
| Address2 | Char | 30 | | yes
|
| |
| |
| City | Char | 20 | | yes
|
| |
| |
| State | Char | 20 | | yes
|
| |
| |
| Zip | Char | 10 | | yes
|
| |
| |
| Country | Char | 15 | | yes
|
| |
| |
| Phone | Char | 15 | | yes
|
| |
| |
| FAX | Char | 15 | | yes
|
| |
| |
| Preferred | Bit | 1 | | yes
|
| |
| |
Indexes
| name | description | column | comment |
|---|
| PRIMARY_KEY | primary key index on vendors | VendorNo |
|
Dependency graph
Sample rows
| VendorNo | VendorName | Address1 | Address2 | City | State | Zip | Country | Phone | FAX | Preferred |
|---|
| 2014
| Cacor Corporation
| 161 Southfield Rd
| NULL
| Southfield
| OH
| 60093
| U.S.A.
| 708-555-9555
| 708-555-7547
| True
|
| 2641
| Underwater
| 50 N 3rd Street
| NULL
| Indianapolis
| IN
| 46208
| U.S.A.
| 317-555-4523
| NULL
| True
|
| 2674
| J.W. Luscher Mfg.
| 65 Addams Street
| NULL
| Berkely
| MA
| 02779
| U.S.A.
| 800-555-4744
| 508-555-8949
| False
|
| 3511
| Scuba Professionals
| 3105 East Brace
| NULL
| Rancho Dominguez
| CA
| 90221
| U.S.A.
| 213-555-7850
| NULL
| True
|
| 3819
| Divers' Supply Shop
| 5208 University Dr
| NULL
| Macon
| GA
| 20865
| U.S.A.
| 912-555-6790
| 912-555-8474
| False
|
| 3820
| Techniques
| 52 Dolphin Drive
| NULL
| Redwood City
| CA
| 94065-1086
| U.S.A.
| 415-555-1410
| 415-555-1276
| False
|
| 4521
| Perry Scuba
| 3443 James Ave
| NULL
| Hapeville
| GA
| 30354
| U.S.A.
| 800-555-6220
| 404-555-8280
| True
|
| 4642
| Beauchat, Inc.
| 45900 SW 2nd Ave
| NULL
| Ft Lauderdale
| FL
| 33315
| U.S.A.
| 305-555-7242
| 305-555-6739
| True
|
| 4651
| Amor Aqua
| 42 West 29th Street
| NULL
| New York
| NY
| 10011
| U.S.A.
| 800-555-6880
| 212-555-7286
| True
|
| 4652
| Aqua Research Corp.
| P.O. Box 998
| NULL
| Cornish
| NH
| 03745
| U.S.A.
| 603-555-2254
| NULL
| True
|
Code
CREATE TABLE [vendors]
(
[VendorNo] FLOAT NOT NULL,
[VendorName] CHAR (30) CODE PAGE 1252,
[Address1] CHAR (30) CODE PAGE 1252,
[Address2] CHAR (30) CODE PAGE 1252,
[City] CHAR (20) CODE PAGE 1252,
[State] CHAR (20) CODE PAGE 1252,
[Zip] CHAR (10) CODE PAGE 1252,
[Country] CHAR (15) CODE PAGE 1252,
[Phone] CHAR (15) CODE PAGE 1252,
[FAX] CHAR (15) CODE PAGE 1252,
[Preferred] BIT,
CONSTRAINT [PRIMARY_KEY] PRIMARY KEY ([VendorNo])
);