namespace wcftest.orm
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    public partial class Amazon_Product
    {
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
        public Amazon_Product()
        {
            Amazon_Product_ItemValue = new HashSet<Amazon_Product_ItemValue>();
        }

        [Key]
        public int AmazonProduct_Id { get; set; }

        public int? StoreInfo_Id { get; set; }

        [Required]
        [StringLength(500)]
        public string StoreName { get; set; }

        [StringLength(50)]
        public string AmazonParentAsin { get; set; }

        public long? AmazonProductId { get; set; }

        public long? Product_Id { get; set; }

        [StringLength(50)]
        public string ProductCode { get; set; }

        [StringLength(3500)]
        public string ProductName { get; set; }

        [StringLength(3500)]
        public string ProductSpec { get; set; }

        [StringLength(40)]
        public string SKU { get; set; }

        [StringLength(24)]
        public string StandardProductID { get; set; }

        [StringLength(5)]
        public string StandardProductIDType { get; set; }

        [StringLength(100)]
        public string Color { get; set; }

        [StringLength(100)]
        public string Size { get; set; }

        [StringLength(24)]
        public string UPC { get; set; }

        [StringLength(20)]
        public string EAN { get; set; }

        [StringLength(20)]
        public string ISBN { get; set; }

        [StringLength(500)]
        public string AmazonProductTitle { get; set; }

        [StringLength(50)]
        public string Brand { get; set; }

        [StringLength(50)]
        public string Manufacturer { get; set; }

        [StringLength(100)]
        public string MfrPartNumber { get; set; }

        [StringLength(50)]
        public string Designer { get; set; }

        [StringLength(2000)]
        public string Description { get; set; }

        public int? AmazonType_Id { get; set; }

        [StringLength(50)]
        public string AmazonTypeName { get; set; }

        [Column(TypeName = "date")]
        public DateTime? LaunchDate { get; set; }

        [Column(TypeName = "date")]
        public DateTime? DiscontinueDate { get; set; }

        [Column(TypeName = "date")]
        public DateTime? ReleaseDate { get; set; }

        [StringLength(100)]
        public string ExternalProductUrl { get; set; }

        [StringLength(20)]
        public string OffAmazonChannel { get; set; }

        [StringLength(20)]
        public string OnAmazonChannel { get; set; }

        [StringLength(3)]
        public string CurrencyCode { get; set; }

        public decimal? MSRP { get; set; }

        [Column(TypeName = "money")]
        public decimal? RegularPrice { get; set; }

        [Column(TypeName = "money")]
        public decimal? ListingPrice { get; set; }

        public DateTime? ListingPriceStartDate { get; set; }

        public DateTime? ListingPriceEndDate { get; set; }

        [Column(TypeName = "money")]
        public decimal? ShippingPrice { get; set; }

        [StringLength(50)]
        public string FulfillmentCenterID { get; set; }

        public int? Quantity { get; set; }

        [StringLength(50)]
        public string SwitchFulfillmentTo { get; set; }

        [StringLength(100)]
        public string ConditionType { get; set; }

        [StringLength(1000)]
        public string ConditionNote { get; set; }

        public int? MaxOrderQuantity { get; set; }

        public int? MaxAggregateShipQuantity { get; set; }

        public int? ItemPackageQuantity { get; set; }

        public int? NumberOfItems { get; set; }

        [StringLength(50)]
        public string ProductTaxCode { get; set; }

        public int? SerialNumberRequired { get; set; }

        public int? IsGiftWrapAvailable { get; set; }

        public int? IsGiftMessageAvailable { get; set; }

        [StringLength(100)]
        public string PromotionKeywords { get; set; }

        public int? IsDiscontinuedByManufacturer { get; set; }

        [StringLength(20)]
        public string DeliveryChannel { get; set; }

        public decimal? ShippingWeight { get; set; }

        [StringLength(10)]
        public string ShippingWeightUnitOfMeasure { get; set; }

        public decimal? Length { get; set; }

        public decimal? Width { get; set; }

        public decimal? Height { get; set; }

        [StringLength(10)]
        public string UnitOfMeasure { get; set; }

        public decimal? Weight { get; set; }

        [StringLength(10)]
        public string WeightUnitOfMeasure { get; set; }

        [StringLength(2000)]
        public string BulletPoint { get; set; }

        public long? RecommendedBrowseNode1 { get; set; }

        [StringLength(100)]
        public string RecommendedBrowseNodeName1 { get; set; }

        public long? RecommendedBrowseNode2 { get; set; }

        [StringLength(100)]
        public string RecommendedBrowseNodeName2 { get; set; }

        [StringLength(100)]
        public string UsedFor { get; set; }

        [StringLength(200)]
        public string ItemType { get; set; }

        [StringLength(100)]
        public string OtherItemAttributes { get; set; }

        [StringLength(100)]
        public string TargetAudience { get; set; }

        [StringLength(50)]
        public string SubjectContent { get; set; }

        [StringLength(100)]
        public string SearchTerms { get; set; }

        [StringLength(50)]
        public string PlatinumKeywords { get; set; }

        public int? Memorabilia { get; set; }

        public int? Autographed { get; set; }

        [StringLength(100)]
        public string MerchantCatalogNumber { get; set; }

        public decimal? PackageLength { get; set; }

        public decimal? PackageWidth { get; set; }

        public decimal? PackageHeight { get; set; }

        [StringLength(10)]
        public string PackageDimensionUnitOfMeasure { get; set; }

        public decimal? PackageWeight { get; set; }

        [StringLength(10)]
        public string PackageWeightUnitOfMeasure { get; set; }

        public int? Prop65 { get; set; }

        [StringLength(100)]
        public string CPSIAWarning { get; set; }

        [StringLength(100)]
        public string CPSIAWarningDescription { get; set; }

        [StringLength(100)]
        public string TSDWarning { get; set; }

        [StringLength(100)]
        public string TSDAgeWarning { get; set; }

        [StringLength(300)]
        public string TSDLanguage { get; set; }

        public int? Priority { get; set; }

        public int? BrowseExclusion { get; set; }

        public int? RecommendationExclusion { get; set; }

        [StringLength(50)]
        public string RegisteredParameter { get; set; }

        public int? Enable { get; set; }

        public string Remark { get; set; }

        public int? OrderNo { get; set; }

        public int? CreateID { get; set; }

        [StringLength(50)]
        public string Creator { get; set; }

        public DateTime? CreateDate { get; set; }

        public int? ModifyID { get; set; }

        [StringLength(50)]
        public string Modifier { get; set; }

        public DateTime? ModifyDate { get; set; }

        public string ExpandFields { get; set; }

        public virtual Amazon_StoreInfo Amazon_StoreInfo { get; set; }

        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<Amazon_Product_ItemValue> Amazon_Product_ItemValue { get; set; }
    }
}