Description
noneTable properties
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| CustNo | Int | 4 | | no
| yes
| |
| |
| Last_Name | Char | 30 | | yes
|
| |
| |
| First_Name | Char | 30 | | yes
|
| |
| |
| VIP_Status | Char | 10 | | yes
|
| |
| |
| Address1 | Char | 40 | | yes
|
| |
| |
| Address2 | Char | 40 | | yes
|
| |
| |
| City | Char | 20 | | yes
|
| |
| |
| State_Prov | Char | 10 | | yes
|
| |
| |
| Post_Code | Char | 10 | | yes
|
| |
| |
| Country | Char | 10 | | yes
|
| |
| |
| Phone | Char | 18 | | yes
|
| |
| |
| Fax | Char | 18 | | yes
|
| |
| |
| EMail | Char | 40 | | yes
|
| |
| |
| Remarks | NText | 67106816 | | yes
|
| |
| |
Indexes
| name | description | column | comment |
|---|
| City | index on custoly | City |
|
| Names | index on custoly | Last_Name, First_Name |
|
| PRIMARY_KEY | primary key index on custoly | CustNo |
|
Dependency graph
Sample rows
| CustNo | Last_Name | First_Name | VIP_Status | Address1 | Address2 | City | State_Prov | Post_Code | Country | Phone | Fax | EMail | Remarks |
|---|
| 1
| Ferguson
| Marilyn
| VIP
| 4-976 Sugarloaf Hwy
| NULL
| Kapaa Kauai
| HI
| 94766
| U.S.A.
| 808-555-0269
| 808-556-0099
| m_ferg@kuai.net
| VIP status since 1995. Check on availability for translations (French, Indonesian)
|
| 2
| Montegiordano
| Donatella
| NULL
| Via Dell'Anguillara 10
| NULL
| Firenze
| FI
| 50122
| Italy
| 39-55-30-20-61
| 39-55-30-20-61
| donatellam@casino.net.it
| Advise early for international travel restrictions.
|
| 3
| Constantinopolous
| Marulla
| NULL
| 1 Neptune Lane
| NULL
| Kato Paphos
| NULL
| NULL
| Cyprus
| 357-6-876708
| 357-6-876000
| marulla@aol.com
| Previous VIP status expired; contact in fall for subscription renewal.
|
| 4
| Parker
| Geoffrina
| VIP Exec
| PO Box 541
| NULL
| New York
| NY
| 10019
| USA
| 212-447-6053
| 212-663-8455
| gp@angel.net
| Travels with pet dog (Rolo). Make travel arrangements accordingly.
|
| 5
| Sawyer
| Thomas L.
| VIP
| 632-1 Third Frydenhoj
| NULL
| Christiansted
| St. Croix
| 00820
| US Virgin
| 809-555-7281
| 809-555-9880
| NULL
| NULL
|
| 6
| Blue
| Jack M.
| VIP
| 23-738 Paddington Lane
| NULL
| Waipahu
| HI
| 99776
| U.S.A.
| 808-555-8904
| 808-499-8000
| jblue@aol.com
| U.S. Olympic Committee
|
| 7
| DuDiver
| Madelline
| VIP
| 32 Main St.
| NULL
| Christiansted
| St. Croix
| 02800
| US Virgin
| 809-555-6864
| 809-555-6864
| mdd122@croix.com
| Possible French translation volunteer. Contact at least six months prior to event.
|
| 8
| O'Parr
| Ruth
| NULL
| PO Box 8745
| NULL
| Kailua-Kona
| HI
| 94756
| U.S.A.
| 808-555-8231
| NULL
| r_oparr@volcano.net
| NULL
|
| 9
| Delgado De Cabeza
| Enrique
| VIP Exec
| Z32 999 #12A-77 A.A.
| NULL
| Bogota
| NULL
| NULL
| Columbia
| 57-1-773421
| 57-1-773000
| eddc@montana.co
| Interests in acquatic events.
|
| 10
| Marmot
| Herbert A.
| VIP Exec
| 872 Queen St.
| NULL
| Kitchener
| Ontario
| G3N 2E1
| Canada
| 519-555-5520
| 519-555-5520
| herbert@yukon.ca
| NULL
|
Code
CREATE TABLE [custoly]
(
[CustNo] INT NOT NULL,
[Last_Name] CHAR (30) CODE PAGE 1252,
[First_Name] CHAR (30) CODE PAGE 1252,
[VIP_Status] CHAR (10) CODE PAGE 1252,
[Address1] CHAR (40) CODE PAGE 1252,
[Address2] CHAR (40) CODE PAGE 1252,
[City] CHAR (20) CODE PAGE 1252,
[State_Prov] CHAR (10) CODE PAGE 1252,
[Post_Code] CHAR (10) CODE PAGE 1252,
[Country] CHAR (10) CODE PAGE 1252,
[Phone] CHAR (18) CODE PAGE 1252,
[Fax] CHAR (18) CODE PAGE 1252,
[EMail] CHAR (40) CODE PAGE 1252,
[Remarks] NTEXT,
CONSTRAINT [PRIMARY_KEY] PRIMARY KEY ([CustNo])
);
ALTER TABLE [custoly]
ALTER COLUMN [CustNo] INT NOT NULL IDENTITY (31, 1);
CREATE INDEX [City] ON [custoly] ([City]);
CREATE INDEX [Names] ON [custoly] ([Last_Name] ,[First_Name]);