Desesperanza Db Venezuelan musicDescripción completa
Descrição: Conhecendo o dbaccess
DB listFull description
200 CR+ companies
IT database
Manual Chiller DBDescripción completa
novel
Database ERDFull description
IT database
IT database
IT database
Don Balon is the oldest football (soccer) magazine in Spain. It talks about spanish and international football.Descripción completa
IT databaseFull description
sql dataDescripción completa
Company
Title
Registratio n number
Auction System - Database design Revision
Page
PA1 Author
Subject
1(3)
Update date
Johan Wo lff
2003-04-02
Au c t i o n Sys Sy s t em – Datab Dat abas ase e des d esii g n Overview This document describes the database design of the Pro ject Entropia Auction System.
Tables auction_offer Column auction_offer_id started ends start_price buy_out_price max_bid_price nbr_bids category_id id seller
Descript ion Id of auction group Date and time when auction item was created Date and time when the auction will end The start price selected by the seller Buy out price (-1 if not used) Current highest bid Number of bids (-1 if auction has ended) Id of category inventory item belong to Id of inventory item Id of seller
Primary key is auction_offer_id . Index on seller . This table stores auctions. The term t erm “auction item” is used in the Auction System to describe a auction_offer_id , is received from table stored_events single auction. The id of the auction item, auction_offer_id when a new event is created, i.e. the event id and the auction item id is the same. The event is set to start when the auction is supposed to be closed.
auction_bidding Column auction_offer_id bid_time bidder price status
Type bigint timestamp bigint bigint character(1)
Descript ion Id of auction group Date and time when bid was placed Id of player with the highest bid bid Highest bid in PEC Status of player’s bid
bid_time. Primary key is auction_offer_id and bid_time Index on columns bidder . Foreign key on auction_offer(auction_offer_id).
This table is used both to see s ee which player has the highest bid, and to show the bidding history of an auction item. The status flag can have one of the t he following values: Created
Saved
Printed
Document name
Title
03-02-26 11:44
03-04-08 21:12
14-02-17 18:38
D:\Fraps\Oblivion D:\Fraps\Oblivion 2\Old Auction and Society Documents\auction and society\auction\Dokument\Auction society\auction\Dokument\A uction System DB Design.doc
Auction System – Database design
MA Small v1.7
Page
1 (3)
Company
Title
Registratio n number
Auction System - Database design Revision
Page
PA1 Author
Subject
Johan Wolff
Status H W
D C B S E I
2(3)
Update date
2003-04-02
Description The player has the highest bid (‘H’ = highest) The player does not have the highest bid, but money is still held deposited (‘W’ = waiting) The player does not have the highest bid and the player has received his deposit (‘D’ = deposit) Auction committed, waiting for seller and buyer to log on Buyer has received his item, seller has not received his money Seller has received his money, buyer has not received his item Auction has ended, seller has received his money, and buyer has received his item Auction invalid, the auction has been closed with no bidders
The status flags is used to see if the buyer has received his item, if the seller has received his payment and if the auction is ready for deletion. An auction item can only be deleted from the two tables if the seller and buyer have received the item and money respect ively, and there are no other players with money in deposition, i.e. an auction item can only be deleted if the status is either ‘E’ or ‘I’. The status flags ‘C’, ‘B’, ‘S’ and ‘E’ c an only be set for the highest bid, i.e. the resulting bid of the auction.
inventory_reserved Column id group_id module_id blob_size
Type integer bigint integer integer
Description
Primary key is id . Index on column group_id . Inventory items are moved from table inventory_carried to inventory_reserved when a player creates an auction item.
inventory_reserved_blobs Column id group_id index blob
Type Description integer bigint smallint varchar(8000)
Primary key is id . Index on column group_id .
Created
Saved
Printed
Document name
Title
03-02-26 11:44
03-04-08 21:12
14-02-17 18:38
D:\Fraps\Oblivion 2\Old Auction and Society Documents\auction and society\auction\Dokument\Auction System DB Design.doc
Auction System – Database design
MA Small v1.7
Page
2 (3)
Company
Title
Registratio n number
Auction System - Database design Revision
Page
PA1 Author
Subject
3(3)
Update date
Johan Wolff
2003-04-02
Inventory item blobs are moved from table inventory_carried_blobs to inventory_reserved_blobs when a player creates an auction item.
Database diagram chart auction_bidding
auction_offer PK
auction_offer_id
BIGINT
I1
started ends s tar t_p ri ce buy_out_price max_bid_price nbr_bids c ate gor y_ id id seller
TIMESTAMP TIMESTAMP B IG INT BIGINT BIGINT INTEGER I NT EG ER INTEGER BIGINT
PK PK,FK1
bid_time auction_offer_id
TIMESTAMP BIGINT
I1
bidder price status
BIGINT BIGINT CHARACTER(1)
inventory_reserved
inventory_reserved_blobs
PK
id
INTEGER
PK
id
I1
group_id module_id synchronized blob_size
IN TE GER INTEGER CHARACTER(1) INTEGER
I1
group_id INTEGER i nd ex I NTE GE R blob VARCHAR(8000)
INTEGER
Created
Saved
Printed
Document name
Title
03-02-26 11:44
03-04-08 21:12
14-02-17 18:38
D:\Fraps\Oblivion 2\Old Auction and Society Documents\auction and society\auction\Dokument\Auction System DB Design.doc