Description
noneTable properties
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| ResNo | Int | 4 | | no
| yes
| |
| |
| EventNo | Int | 4 | | yes
|
| |
| |
| CustNo | Int | 4 | | yes
|
| |
| |
| NumTickets | Int | 4 | | yes
|
| |
| |
| Amt_Paid | Money | 8 | | yes
|
| |
| |
| Pay_Method | Char | 10 | | yes
|
| |
| |
| Card_No | Char | 20 | | yes
|
| |
| |
| Card_Exp | SmallDateTime | 4 | | yes
|
| |
| |
| Pay_Notes | NText | 67106816 | | yes
|
| |
| |
| Purge_Date | SmallDateTime | 4 | | yes
|
| |
| |
| Paid | Bit | 1 | | yes
|
| |
| |
Indexes
| name | description | column | comment |
|---|
| EventNo | index on reservat | EventNo |
|
| CustNo | index on reservat | CustNo |
|
| PRIMARY_KEY | primary key index on reservat | ResNo |
|
Dependency graph
Sample rows
| ResNo | EventNo | CustNo | NumTickets | Amt_Paid | Pay_Method | Card_No | Card_Exp | Pay_Notes | Purge_Date | Paid |
|---|
| 9
| 2
| 14
| 4
| 20
| VISA
| 770557078235538241
| 11/30/1996 12:00:00 AM
| NULL
| 6/30/1996 12:00:00 AM
| True
|
| 10
| 8
| 9
| 3
| 22.5
| WILL CALL
| 762723745540848772
| 12/31/1997 12:00:00 AM
| NULL
| 6/30/1996 12:00:00 AM
| True
|
| 11
| 3
| 22
| 5
| 37.5
| VISA
| 458102658420801135
| 11/30/1996 12:00:00 AM
| NULL
| 6/30/1996 12:00:00 AM
| True
|
| 12
| 16
| 12
| 8
| 100
| DINERS
| 054431138151737113
| 1/31/1900 12:00:00 AM
| NULL
| 6/30/1996 12:00:00 AM
| True
|
| 13
| 13
| 19
| 8
| 60
| VISA
| 532646180165820277
| 11/30/1996 12:00:00 AM
| NULL
| 6/30/1996 12:00:00 AM
| True
|
| 14
| 9
| 15
| 6
| 45
| WILL CALL
| 652814106880136747
| 2/1/1998 12:00:00 AM
| NULL
| 6/30/1996 12:00:00 AM
| True
|
| 15
| 8
| 6
| 7
| 52.5
| DINERS
| 256335038564203717
| 12/31/1997 12:00:00 AM
| NULL
| 6/30/1996 12:00:00 AM
| True
|
| 16
| 11
| 26
| 8
| 40
| DINERS
| 614661703465623212
| 11/30/1996 12:00:00 AM
| NULL
| 6/30/1996 12:00:00 AM
| True
|
| 17
| 13
| 20
| 6
| 45
| DINERS
| 481853161235181753
| 6/1/1999 12:00:00 AM
| NULL
| 6/30/1996 12:00:00 AM
| True
|
| 18
| 7
| 30
| 3
| 37.5
| DINERS
| 251371585235815854
| 11/30/1996 12:00:00 AM
| NULL
| 6/30/1996 12:00:00 AM
| True
|
Code
CREATE TABLE [reservat]
(
[ResNo] INT NOT NULL,
[EventNo] INT,
[CustNo] INT,
[NumTickets] INT,
[Amt_Paid] MONEY,
[Pay_Method] CHAR (10) CODE PAGE 1252,
[Card_No] CHAR (20) CODE PAGE 1252,
[Card_Exp] SMALLDATETIME,
[Pay_Notes] NTEXT,
[Purge_Date] SMALLDATETIME,
[Paid] BIT,
CONSTRAINT [PRIMARY_KEY] PRIMARY KEY ([ResNo])
);
ALTER TABLE [reservat]
ALTER COLUMN [ResNo] INT NOT NULL IDENTITY (109, 1);
CREATE INDEX [EventNo] ON [reservat] ([EventNo]);
CREATE INDEX [CustNo] ON [reservat] ([CustNo]);