Results 1 to 5 of 5

Thread: Need help

  1. #1
    Join Date
    Sep 2003
    Location
    Pakistan, Karachi
    Posts
    22

    Exclamation Unanswered: Need help

    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

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    Do you have an actual question that belongs in this forum?

  3. #3
    Join Date
    Sep 2003
    Location
    Pakistan, Karachi
    Posts
    22
    Quote Originally Posted by guelphdad
    Do you have an actual question that belongs in this forum?
    I mean I need help making a database for an auction site

  4. #4
    Join Date
    Mar 2004
    Posts
    480
    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.

  5. #5
    Join Date
    Sep 2003
    Location
    Pakistan, Karachi
    Posts
    22

    Need Help

    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',
    `cvv` 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`)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •