Description
noneTable properties
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| VenueNo | Int | 4 | | no
| yes
| |
| |
| Venue | Char | 30 | | yes
|
| |
| |
| Capacity | Int | 4 | | yes
|
| |
| |
| Venue_Map | Image | 134213632 | | yes
|
| |
| |
| Remarks | NText | 67106816 | | yes
|
| |
| |
Indexes
| name | description | column | comment |
|---|
| PRIMARY_KEY | primary key index on venues | VenueNo |
|
Dependency graph
Sample rows
| VenueNo | Venue | Capacity | Venue_Map | Remarks |
|---|
| 2
| Memorial Stadium
| 360
| 0x424D42CE0000003640028000A100C100010800000CCA00CEE00C4E000000
| Standard bleacher seating -- sides only. Special cushion seating will be provided for VIP/comp sect
|
| 3
| Main Auditorium
| 2010
| 0x424DFE660000007600028000A100C100010400000886600000000000000
| Advise hearing-impaired guests to select seats in the rear, due to acoustic problems.
|
| 4
| Coliseum
| 12500
| 0x424DC6D90000003640028000A100CC0001080000090D500CEE00C4E000000
| Partially covered venue. Cancellations are possible due to inclement weather.
|
| 5
| Frye Track
| 1400
| 0x424D42CE0000003640028000A100C100010800000CCA00000000000000
| Track & field events will use a modified configuration with limited seating.
|
| 6
| Guillermo Field
| 2200
| 0x424D42CE0000003640028000A100C100010800000CCA00000000000000
| Track & field events will use a modified configuration with limited seating.
|
| 7
| Memorial Stadium
| 1000
| 0x424DFE660000007600028000A100C100010400000886600000000000000
| Acoustics are best in sections A through C, mezannine level.
|
| 8
| Special City Route
| 15000
| 0x424DFE660000007600028000A100C100010400000886600000000000000
| Advise spectators of limited access at SAG stops S5 and S5
|
| 9
| Ayung River
| 500
| 0x424DB6350000007600028000B90008E00010400000403500000000000000
| Severe access problems, except for Falls park.
|
| 10
| County Line Beach
| 240
| 0x424D42CE0000003640028000A100C100010800000CCA00000000000000
| Advise spectators of access route: parking only in Zuma Beach P1 lot.
|
| 11
| Parker Aquatic Ctr
| 420
| 0x424D42CE0000003640028000A100C100010800000CCA00000000000000
| Purple section is bleachers only. Advise guests accordingly.
|
Code
CREATE TABLE [venues]
(
[VenueNo] INT NOT NULL,
[Venue] CHAR (30) CODE PAGE 1252,
[Capacity] INT,
[Venue_Map] IMAGE,
[Remarks] NTEXT,
CONSTRAINT [PRIMARY_KEY] PRIMARY KEY ([VenueNo])
);
ALTER TABLE [venues]
ALTER COLUMN [VenueNo] INT NOT NULL IDENTITY (12, 1);