CREATE TABLE ebay_auction_scheduler (
    "ebay_scheduler_id" serial             -- System generated unique ID; serialized, incrementing unique row value.
         PRIMARY KEY,
    "company_id" int NOT NULL
        REFERENCES company_master (company_id),   -- References company_master.company_id
    "employee_id" int                           -- References employee_master.employee_id (Entered by)
        REFERENCES employee_master (employee_id),
    "first_listing_time" timestamp,             -- A timestamp for when the schedule starts running; this is used as a reference for the first instance of this auction.  It's a point in time reference for determining when the auction was initially listed on eBay but you need to verify this date with ebay_auction_post_log and/or ebay_auction_master to verify the event actually happened.
    "next_listing_time" timestamp,              -- A timestamp indicating the next time (approximately) the auction will be listed.  This is referenced by the Venture ebay listing agent.
    "item_code" varchar(32)
        NOT NULL,           -- References item_master.item_code
    "title" varchar(55),                        -- eBay API specific: Auction title.  No HTML or high ASCII.  As defined in the eBay API specification.
    "subtitle" varchar(55),                         -- eBay API specific: Auction subtitle.  No HTML or high ASCII. As defined in the eBay API specification.
    "listing_type" varchar(20),         -- eBay API specific: Listing Type (Chinese, Dutch, etc).  As defined in the eBay API specification.
    "listing_duration" varchar(10),       -- eBay API specific: Length of Listing. Usually 'Days_X'.  As defined in the eBay API specification.
    "primary_category_id" int,                  -- eBay API specific: eBay category number.  Reference ebay_category_master.category_id.  A properly configured Venture system refreshes the ebay_category_master daily.
    "secondary_category_id" int,                -- eBay API specific: Optional secondary eBay category.  Reference ebay_category_master.category_id.  A properly configured Venture system refreshes the ebay_category_master daily.  The secondary category effectively lists the item twice on eBay and resulting fees are typically doubled.  Refer to eBay API and/or listing guidelines for more information regarding fees.
    "store_category" int,                       -- eBay API specific: eBay Stores category.  If the seller's account includes a store subscription, a valid store category will list the item in the store as part of any listing service.  Sellers with stores may also list exclusively in stores but still retain the required primary_category field.
    "quantity" int,                             -- eBay API specific: Number of units of given item code made available for sale or auction.  This field is dependent on the listing_type as defined in the eBay API specification.
    "start_price" numeric(12,2),                -- eBay API specific: Starting Price: minimum bid amount or the fixed price for buy-it-now and eBay store listings as defined in the eBay API specification.
    "buy_it_now_price" numeric(12,2),           -- eBay API specific: Buy it now price: if listing an auction item with an overriding buy-it-now option, this value indicates the sale price as defined in the eBay API specification.
    "reserve_price" numeric(12,2),              -- eBay API specific: Reserve price: if listing an auction with a minimum (unpublished) reserve price, this value indicates the minimum bid for successful auction close as defined in the eBay API specification.
    "second_chance" numeric(15,2),              -- eBay API specific: Second chance dollar amount threshold: this is not an eBay API value but rather a set dollar amount at which Venture will create a second chance offer for any bidder meeting this minimum bid amount if the second chance service is enabled in Venture's processEbayAuctions program.  Bids equal or greater to the amount listed in second_chance have an opportunity to buy the item provided enough free stock is available.
    "location" varchar(45),                     -- eBay API specific:  Location text: eBay value for the location of the item.  This location appears in the eBay listing : eBay value for the location of the item.
    "show_gallery" BOOLEAN,                     -- eBay API specific: This listing enhancement service from eBay includes a thumbnail image of the item in the ebay search results (see the image list dialog by right-clicking the photo in the Venture client to define which image should appear).  This is an add-on service and there are fees associated with it.
    "bold_title" BOOLEAN,                       -- eBay API specific: If true, bolds the text in the ebay search results.  This is an add-on service from eBay and there are fees associated with using it.
    "featured" BOOLEAN,                         -- eBay API specific: The featured listing flag moves the listing to the top of eBay search results.  This is an add-on service from eBay and there are fees associated with using it.
    "highlight" BOOLEAN,                        -- eBay API specific: The highlighted listing flag highlights the table row in the ebay search results.  This is an add-on service from eBay and there are fees associated with using it.
    "home_page_featured" BOOLEAN,               -- eBay API specific: The home page featured flag publishes the item on the front page of ebay.  This is an add-on service from eBay and there are fees associated with using it.
    "shipping_type" varchar(10),        -- eBay API specific: The shipping type is a reference to build shipping methods that are sent to the eBay API as aggregated XML.  The aggregated XML contains the shipping type, cost if applicable, source zip code, package dimensions, weight, etc.  This field is not directly reference by the eBay API.  Possible values include but are not limited to sellerPays, flatRate, ebayCalc, venCalc.
    "shipping_cost" numeric(12,2),        -- eBay API specific: This field is not directly reference by the eBay API.  It is part of an XML description.  It is valid for flat rate shipping & handling costs.
    "ship_from_zipcode" varchar(5),             -- eBay API specific:  If using the ebay shipping calculator option, this field identifies the source location of the shipping.
    "shipping_package" varchar(30),             -- eBay API specific:  If using the ebay shipping calculator, this option identified the shipping package code:
                                --   Letter, LargeEnvelope, PackageThickEnvelope
                        --  USPSLargePack, VeryLargePack)
    "weight_major" int,                         -- eBay API specific: If using the ebay shipping calculator, this is the weight major field.  This identifies the weight in pounds as an integer.  See weight_minor to define ounces.
    "weight_minor" numeric(4,2),                -- eBay API specific: If using the ebay shipping calculator, this is the weight minor field.  This identified the weight in ounces secondary to the weight_major pounds.  It is not a stand alone weight measurement unless weight_major is zero.
    "listing_fee" numeric(6,2)
        DEFAULT 0,             -- eBay API specific:   eBay listing fee field returned from the eBay API. 
    "interval_type" varchar(10),        -- Schedule specifc: Type of recurrance (daily|weekly|monthly|x_days|NULL).  This is used to trigger the next_listing_time.
    "day_of_week" integer,      -- Schedule specifc: Which day of the week (weekly type) 0-6 (0:Sunday).  This is used to trigger the next_listing_time.
    "day_interval" integer,   -- Schedule specifc: Number of days between listings ('x_days' type).  This is used to trigger the next_listing_time.
    "schedule_status" varchar(10),    -- Schedule specifc: Schedule status (PENDinG|STOPPED|RUNNinG).  Short description of this schedule's status.
    "number_posted" integer DEFAULT 0,  -- Schedule specifc: Counts number of postings.  Increments upon each successful listing if using the Venture listing agent.
    "post_limit" integer,         -- Schedule specifc: Limit to the number of postings.  The Venture listing agent will refuse to list this item if the post limit is equal to or greater than the post_limit.

FOREIGN KEY (company_id,item_code)
REFERENCES item_master (company_id,item_code)
ON UPDATE cascade
ON DELETE cascade
);