AUCTION
AUCTION holds auction details. AUCTION is new in March 2003 to support SRA Inter-Temporal Linking.
Package
IRAUCTION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| AUCTIONID |
varchar(30)  |
varchar(30) |
Unique id for each auction date |
| AUCTIONDATE |
datetime(3) |
datetime2(0) |
Auction date |
| NOTIFYDATE |
datetime(3) |
datetime2(0) |
- |
| STARTDATE |
datetime(3) |
datetime2(0) |
Open date for bidding |
| ENDDATE |
datetime(3) |
datetime2(0) |
Close date for bidding |
| DESCRIPTION |
varchar(100) |
varchar(100) |
Description of an auction |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
- |
| AUTHORISEDBY |
varchar(30) |
varchar(30) |
- |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
- |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AUCTION_LCX |
nonclustered |
LASTCHANGED |
| AUCTION_PK |
clustered, unique, primary key |
AUCTIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_AUCTION_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_AUCTION |
clustered, unique, primary key |
AUCTIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AUCTION_LCX |
nonclustered |
LASTCHANGED |
| AUCTION_PK |
clustered, unique, primary key |
AUCTIONID |