Results 1 to 4 of 4

Thread: Suggest!!

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

    Exclamation Unanswered: Suggest!!

    DROP TABLE IF EXISTS `admin`;
    CREATE TABLE `admin` (
    `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 '',
    PRIMARY KEY (`admin_id`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `auction`;
    CREATE TABLE `auction` (
    `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',
    PRIMARY KEY (`auctn_id`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `auction_bids`;
    CREATE TABLE `auction_bids` (
    `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',
    PRIMARY KEY (`bid_id`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `billing_info`;
    CREATE TABLE `billing_info` (
    `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',
    PRIMARY KEY (`bill_id`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `cc_info`;
    CREATE TABLE `cc_info` (
    `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',
    PRIMARY KEY (`cc_id`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `contacts`;
    CREATE TABLE `contacts` (
    `cont_id` varchar(10) NOT NULL default '0',
    `contact_name` varchar(50) NOT NULL default '0',
    PRIMARY KEY (`cont_id`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `contacts_detl`;
    CREATE TABLE `contacts_detl` (
    `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',
    PRIMARY KEY (`cont_detl_id`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `feedback`;
    CREATE TABLE `feedback` (
    `feed_id` int(10) NOT NULL auto_increment,
    `name` varchar(50) NOT NULL default '0',
    `comments` text NOT NULL,
    PRIMARY KEY (`feed_id`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `feturd_optn`;
    CREATE TABLE `feturd_optn` (
    `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',
    PRIMARY KEY (`feturd_id`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `item`;
    CREATE TABLE `item` (
    `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',
    PRIMARY KEY (`item_id`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `itm_catgry`;
    CREATE TABLE `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`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `itm_feturd`;
    CREATE TABLE `itm_feturd` (
    `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`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `member`;
    CREATE TABLE `member` (
    `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 '',
    PRIMARY KEY (`mem_id`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `pymnt_plan`;
    CREATE TABLE `pymnt_plan` (
    `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 '',
    PRIMARY KEY (`plan_id`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `shpng_type`;
    CREATE TABLE `shpng_type` (
    `shpng_id` varchar(10) NOT NULL default '0',
    `shpng_desc` varchar(50) NOT NULL default '0',
    PRIMARY KEY (`shpng_id`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `site_customize`;
    CREATE TABLE `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`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `ticket`;
    CREATE TABLE `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`)
    ) TYPE=MyISAM;
    DROP TABLE IF EXISTS `transaction`;
    CREATE TABLE `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`)
    ) TYPE=MyISAM;

    This is something which I think need suggestions what else can be added to it to increase the fucntionality of the programe.. This is database for auction managment system... kind of a bidding system... reponse with suggestion behighly appreciated.

  2. #2
    Join Date
    Feb 2004
    Posts
    78
    That depends on the needs of your client. Working out a properly normalized schema based on the needs is what people get paid a lot for. Are you going to pay anyone to help you with this? Do you have use case scenerios? Clear cut definations of what the system is supposed to do?

  3. #3
    Join Date
    Sep 2003
    Location
    So. Cal. USA
    Posts
    142
    Hi, Shani! I also would suggest describing what you are showing us rather than just throwing your setup code out there, e.g.

    "I am developing an auction management system w/10 tables... 2 for auction item info, 1 for billing, 2 for user/login.... , etc. The bidding will be online via a web browser and items are pre-submitted using a web form. The admin approves the item for auction and then..."

    --ST

  4. #4
    Join Date
    Aug 2004
    Posts
    4
    hello
    depending on your needs this can become a huge database, for example in site_customize you could add many more things like specific metatags, titles, descriptions for each page etc

Posting Permissions

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