dear admin

Thanks for Birthday wishes...,

I need a little help regarding the database of auctions web site.

your early reply will be appreciable...

thanks n best regards.

Zeeshan Aqeel

Do you have an actual question that belongs in this forum?

I mean I need help making a database for an auction site

Would you like someone to do it for you?
Do you have a specific question you are stuck with?
Do you have a programming/scripting language in mind?
Have you looked at using PHP/MySQL together to do this?
Have you searched the web to see if anyone has already posted on using a scripting language/database combination to do such a thing?
Also change your thread title so folks have an idea of what you need help with.

A bit of work on your end may actually get you started rather than asking a blanket question without any effort on your behalf.

Thanks alot guelphdad.

First of all sorry for the blank question, actually at that time i thought that somebody will send me the database structure who did it before...but i was wrong.

Anyways, Actually i want to develop Auctions web-based Application using PHP/MySql combination, and now i have desgined the database with my own, here is the schema, so please check it and may be there is something missing or needs to be changed, so please inform me, or ask me related to this (i means discuss to accomplished this), and thanks in advance... hope u will be help me, as u did it upto now....

Here is the schema...

#
# Table structure for table 'admin'
#

`admin`
PRIMARY KEY (`admin_id`)
`admin_id` varchar(10) NOT NULL default '0',
`fname` varchar(50) NOT NULL default '0',
`lname` varchar(50) NOT NULL default '0',
`address` varchar(50) NOT NULL default '0',
`street` varchar(50) NOT NULL default '0',
`city` varchar(50) NOT NULL default '0',
`state` varchar(50) NOT NULL default '0',
`country` varchar(50) NOT NULL default '0',
`zipcode` varchar(10) NOT NULL default '0',
`password` varchar(10) NOT NULL default '0',
`email` varchar(50) NOT NULL default '0',
`phone` int(10) NOT NULL default '0',
`fax` int(10) NOT NULL default '0',
`mobile` int(10) NOT NULL default '0',
`doj` timestamp(4) NOT NULL,
`secret_qtn` tinytext NOT NULL,
`secret_ans` tinytext NOT NULL,
`status` varchar(20) NOT NULL default '',
#
# Table structure for table 'auction'
#
`auction`
PRIMARY KEY (`auctn_id`)
`auctn_id` varchar(10) NOT NULL default '0',
`start_date` varchar(50) NOT NULL default '0',
`end_date` varchar(50) NOT NULL default '0',
`item_id` varchar(50) NOT NULL default '0',
`status` varchar(50) NOT NULL default '0',

#
# Table structure for table 'auction_bids'
#
`auction_bids`
PRIMARY KEY (`bid_id`)
`bid_id` varchar(10) NOT NULL default '0',
`auctn_id` varchar(50) NOT NULL default '0',
`mem_id` varchar(50) NOT NULL default '0',
`amount` varchar(50) NOT NULL default '0',
`date_time` varchar(50) NOT NULL default '0',

#
# Table structure for table 'billing_info'
#
`billing_info`
PRIMARY KEY (`bill_id`)
`bill_id` varchar(10) NOT NULL default '0',
`mem_id` varchar(50) NOT NULL default '0',
`fname` varchar(50) NOT NULL default '0',
`lname` varchar(50) NOT NULL default '0',
`address` varchar(50) NOT NULL default '0',
`street` varchar(50) NOT NULL default '0',
`country` varchar(50) NOT NULL default '0',
`zipcode` varchar(50) NOT NULL default '0',

#
# Table structure for table 'cc_info'
#
`cc_info`
PRIMARY KEY (`cc_id`)
`cc_id` varchar(10) NOT NULL default '0',
`mem_id` varchar(50) NOT NULL default '0',
`fname` varchar(50) NOT NULL default '0',
`lname` varchar(50) NOT NULL default '0',
`address` varchar(50) NOT NULL default '0',
`street` varchar(50) NOT NULL default '0',
`country` varchar(50) NOT NULL default '0',
`zipcode` varchar(50) NOT NULL default '0',
`ccno` varchar(50) NOT NULL default '0',
`***` varchar(50) NOT NULL default '0',
`expry_mnth` varchar(50) NOT NULL default '0',
`expry_year` varchar(50) NOT NULL default '0',

#
# Table structure for table 'contacts'
#
`contacts`
PRIMARY KEY (`cont_id`)
`cont_id` varchar(10) NOT NULL default '0',
`contact_name` varchar(50) NOT NULL default '0',

#
# Table structure for table 'contacts_detl'
#
`contacts_detl`
PRIMARY KEY (`cont_detl_id`)
`cont_detl_id` varchar(10) NOT NULL default '0',
`cont_id` varchar(50) NOT NULL default '0',
`department` varchar(50) NOT NULL default '0',
`designation` varchar(50) NOT NULL default '0',
`email` varchar(50) NOT NULL default '0',
`phone` varchar(50) NOT NULL default '0',
`fax` varchar(50) NOT NULL default '0',

#
# Table structure for table 'feedback'
#
`feedback`
PRIMARY KEY (`feed_id`)
`feed_id` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '0',
`comments` text NOT NULL,

#
# Table structure for table 'feturd_optn'
#
`feturd_optn`
PRIMARY KEY (`feturd_id`)
`feturd_id` varchar(10) NOT NULL default '0',
`optn_desc` varchar(50) NOT NULL default '0',
`price` varchar(50) NOT NULL default '0',
`status` varchar(50) NOT NULL default '0',
`expry_mnth` varchar(50) NOT NULL default '0',
`expry_year` varchar(50) NOT NULL default '0',

#
# Table structure for table 'item'
#
`item`
PRIMARY KEY (`item_id`)
`item_id` varchar(10) NOT NULL default '0',
`item_desc` varchar(50) NOT NULL default '0',
`catgry_id` varchar(50) NOT NULL default '0',
`price` int(10) NOT NULL default '0',
`pic_url` varchar(50) NOT NULL default '0',
`qty` int(10) NOT NULL default '0',
`incrmnt_price` int(10) NOT NULL default '0',
`status` varchar(50) NOT NULL default '0',
`max_price` int(10) NOT NULL default '0',
`shpng_type` varchar(50) NOT NULL default '0',

#
# Table structure for table 'itm_catgry'
#
`itm_catgry`
`catgry_id` varchar(10) NOT NULL default '0',
`catgry_desc` varchar(50) NOT NULL default '0',
`status` varchar(50) NOT NULL default '0',
PRIMARY KEY (`catgry_id`)

#
# Table structure for table 'itm_feturd'
#
`itm_feturd`
PRIMARY KEY (`itm_feturd_id`)
`itm_feturd_id` varchar(10) NOT NULL default '0',
`feturd_id` varchar(50) NOT NULL default '0',
`item_id` varchar(50) NOT NULL default '0',
PRIMARY KEY (`itm_feturd_id`)

#
# Table structure for table 'member'
#
`member`
PRIMARY KEY (`mem_id`)
`mem_id` varchar(10) NOT NULL default '0',
`fname` varchar(50) NOT NULL default '0',
`lname` varchar(50) NOT NULL default '0',
`address` varchar(50) NOT NULL default '0',
`street` varchar(50) NOT NULL default '0',
`city` varchar(50) NOT NULL default '0',
`state` varchar(50) NOT NULL default '0',
`country` varchar(50) NOT NULL default '0',
`zipcode` varchar(10) NOT NULL default '0',
`password` varchar(10) NOT NULL default '0',
`email` varchar(50) NOT NULL default '0',
`phone` int(10) NOT NULL default '0',
`fax` int(10) NOT NULL default '0',
`mobile` int(10) NOT NULL default '0',
`plan_id` int(5) NOT NULL default '0',
`doj` timestamp(4) NOT NULL,
`secret_qtn` text NOT NULL,
`secret_ans` text NOT NULL,
`pymnt_status` int(5) NOT NULL default '0',
`status` varchar(20) NOT NULL default '',

#
# Table structure for table 'pymnt_plan'
#
`pymnt_plan`
PRIMARY KEY (`plan_id`)
`plan_id` varchar(10) NOT NULL default '0',
`plan_name` varchar(50) NOT NULL default '0',
`price` int(10) NOT NULL default '0',
`status` varchar(50) NOT NULL default '0',
`no_of_lstng` int(10) NOT NULL default '0',
`expry_mnth` varchar(10) NOT NULL default '',
`expry_year` varchar(10) NOT NULL default '',

#
# Table structure for table 'shpng_type'
#
`shpng_type`
PRIMARY KEY (`shpng_id`)
`shpng_id` varchar(10) NOT NULL default '0',
`shpng_desc` varchar(50) NOT NULL default '0',

#
# Table structure for table 'site_customize'
#
`site_customize`
`cust_id` varchar(10) NOT NULL default '0',
`font_color` varchar(50) NOT NULL default '0',
`font_style` varchar(50) NOT NULL default '0',
`font_name` varchar(50) NOT NULL default '0',
`font_size` varchar(50) NOT NULL default '0',
`header` varchar(50) NOT NULL default '0',
`footer` varchar(50) NOT NULL default '0',
`history` varchar(50) NOT NULL default '0',
`faqs` varchar(50) NOT NULL default '0',
`privacy_policy` varchar(50) NOT NULL default '0',
PRIMARY KEY (`cust_id`)

#
# Table structure for table 'ticket'
#
`ticket`
`tkt_id` varchar(10) NOT NULL default '0',
`mem_id` varchar(50) NOT NULL default '0',
`comments` varchar(50) NOT NULL default '0',
PRIMARY KEY (`tkt_id`)

#
# Table structure for table 'transaction'
#
`transaction`
`trans_id` varchar(10) NOT NULL default '0',
`mem_id` varchar(50) NOT NULL default '0',
`trans_type` varchar(50) NOT NULL default '0',
`amount` varchar(50) NOT NULL default '0',
`date_time` varchar(50) NOT NULL default '0',
`remarks` varchar(50) NOT NULL default '0',
`status` varchar(50) NOT NULL default '0',
PRIMARY KEY (`trans_id`)