Description
noneTable properties
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| EventNo | Int | 4 | | no
| yes
| |
| |
| VenueNo | Int | 4 | | yes
|
| |
| |
| Event_Name | Char | 30 | | yes
|
| |
| |
| Event_Date | SmallDateTime | 4 | | yes
|
| |
| |
| Event_Time | DateTime | 8 | | yes
|
| |
| |
| Event_Description | NText | 67106816 | | yes
|
| |
| |
| Ticket_price | Money | 8 | | yes
|
| |
| |
| Event_Photo | Image | 134213632 | | yes
|
| |
| |
Indexes
| name | description | column | comment |
|---|
| Date_Time | index on events | Event_Name, Event_Date |
|
| PRIMARY_KEY | primary key index on events | EventNo |
|
Dependency graph
Sample rows
| EventNo | VenueNo | Event_Name | Event_Date | Event_Time | Event_Description | Ticket_price | Event_Photo |
|---|
| 1
| 5
| Men's Track and Field
| 6/15/1996 12:00:00 AM
| 12/30/1899 10:00:00 AM
| Outdoor arena, one of the most popular events. High speed contenders for this medal round.
| 5
| 0x424D8E6A0000003640028000C50008300010800000586600000000000000
|
| 2
| 3
| 500 meter Men's Speed Skating
| 6/16/1996 12:00:00 AM
| 12/30/1899 8:00:00 AM
| World record for 500 meter speedskating could be set by the hometown favorite.
| 5
| 0x424D82680000003640028000C400083000108000004C6400000000000000
|
| 3
| 5
| 100 Meter Individual Medley
| 6/21/1996 12:00:00 AM
| 12/30/1899 2:00:00 PM
| Consult refund policy for cancellations due to weather.
Semi-Final round, combonation individual
| 7.5
| 0x424D76660000003640028000C00008300010800000406200000000000000
|
| 4
| 2
| Women's Basketball Finals
| 6/21/1996 12:00:00 AM
| 12/30/1899 8:00:00 PM
| Held indoors at Harmon Arena. Last Olympic medal round went to an all-time high scoring game of 127
| 7.5
| 0x424D8E6A0000003640028000C60008300010800000586600000000000000
|
| 5
| 7
| Women's Cycling 20mi
| 6/19/1996 12:00:00 AM
| 12/30/1899 9:00:00 AM
| Consult map of venue (City Route). This event has limited spectator access except in beachfront loc
| 7.5
| 0x424D82680000003640028000C400083000108000004C6400000000000000
|
| 6
| 1
| Men's Gymnastics Finals
| 6/20/1996 12:00:00 AM
| 12/30/1899 9:00:00 AM
| All comps suspended for this event. Contact VIP office for exception requests.
| 12.5
| 0x424D8E6A0000003640028000C50008300010800000586600000000000000
|
| 7
| 1
| Women's Hockey Finals
| 6/20/1996 12:00:00 AM
| 12/30/1899 11:00:00 AM
| Limited seating due to arena reconfiguration.
| 12.5
| 0x424DBE670000003640028000C20008200010800000886300000000000000
|
| 8
| 3
| Women's High Dive Finals
| 6/19/1996 12:00:00 AM
| 12/30/1899 10:00:00 PM
| World premiere event. All comps are suspended.
| 7.5
| 0x424D82680000003640028000C100083000108000004C6400000000000000
|
| 9
| 1
| Karate Finals
| 6/21/1996 12:00:00 AM
| 12/30/1899 4:00:00 PM
| Possible venue change due to weather.
| 7.5
| 0x424D8E6A0000003640028000C50008300010800000586600000000000000
|
| 10
| 8
| Kayak Level IV Finals
| 6/20/1996 12:00:00 AM
| 12/30/1899 4:00:00 PM
| River access is restricted. Advise spectators of access points.
| 5
| 0x424D8E6A0000003640028000C80008300010800000586600000000000000
|
Code
CREATE TABLE [events]
(
[EventNo] INT NOT NULL,
[VenueNo] INT,
[Event_Name] CHAR (30) CODE PAGE 1252,
[Event_Date] SMALLDATETIME,
[Event_Time] DATETIME,
[Event_Description] NTEXT,
[Ticket_price] MONEY,
[Event_Photo] IMAGE,
CONSTRAINT [PRIMARY_KEY] PRIMARY KEY ([EventNo])
);
ALTER TABLE [events]
ALTER COLUMN [EventNo] INT NOT NULL IDENTITY (24, 1);
CREATE INDEX [Date_Time] ON [events] ([Event_Name] ,[Event_Date]);