“Sampling for tests” (Nissan)

erDiagram ord { int id PK int Vin PK int OrderNumber PK int FinalDeliveryDealerCode FK int VehOrdID string NscCode string ProdnOrderTypecode string VehOrderClasstypeCode string VehOrderClassCode string ColourCode string NSCModelGroupCode string VehOrderSourceCode string BuyerCode string NSCLocalVehicleCode string OrderCreatedDate string UserID string PlacementDealerCode string AttachementTypeCode string VehOrderDeliveryStatusCode string DistributionZoneCode string NoShortTermReservationExpCode string ShortTermReservationExpTime string AllDealerVisibility string DutyPayment string MaximumStockLimit string NSCImposedOrder string OrderAdvDel string RequiredDelDateRevision string TransferSwap string DeliveryOrderInformed string CancellationDate string ConfirmedEarlyDate string ConfirmedLateDate string CustomerRequiredDate string DealerRequestedDate string ProdnStartDate string RequiredDate string RevisedEarlyDate string RevisedLateDate string VehOrderReleaseDate string ReOptimisationTargetDate string AttachmentBlockOverride string NSCMaximumStockLimit string NonAttachmentReasonCode string VehOrderStatusCode string LanguageCodeHandbook string AttachedSupplyCurrentStatus string VehOrderPayMethodCode string achievPointCodeAttached string FinalDeliveryDealerAddr string LocationDealerAddr string NDSDeliveryDealerAddr string VehicleSaleCampaignCode string DeliveryRouteCode string PiCode string FinalDeliveryDealerCode string LocationDealerCode string NDSDeliveryDealerCode string DealerInternalReference string SalespersonID string EIModelGroup string EIModelVariant string EISpecDestCode string EINMLSpecCode string EIColourCode string CustomerName string CutomerContactDetails string DealerComment string NSCComment string ProdnStDateFixedPeriod string VehicleOrderDeliveryStatusKPI string ProductionPeriod string DeliveredOK string ActualDeliveryDate string ActualDeliveryDateSQL string ActualLeadTime string QuotedLeadTime string ASAP string vehOrderClassTypeCodeChange string InvalidOrder string OrigConfirmedDelDateEarly string ReportingModelGroup string FleetCode string DealerCommitmentToCustDate string CommitmentDateRequired string MassVehOrderReferenceNo string CustomerContractDate string CustomerContractNumber string InitialDeliveryDateLate string CopiedFromOrder string TiEarlyOverRideCode string IncentiveAuditRequired string AuditTriggerDate string QAReleaseDateReference string ProductionStartDateFixedPeriod string ArchivedDate string VehOrdClassInitial string DefleetDate string DefleetOrderClass } vin { int id PK int Vin PK int orderNumber PK string RetailResponsabilityDealer FK string DATE int Mois int Annee string Genre string Genre_UE string Marque string Type string Energie string Carosserie int Puissance_fiscale int Code_Region int Code_Concession int Code_Departement int Code_Canton int Code_Commune string Commune int Code_CSP_Proprietaire string Code_APE int Numero_SIREN int Annee_carte_grise int Mois_carte_grise int Jour_carte_grise string Lettres_immatriculation string Numero_immatriculation string Plaque_immatriculation string Code_Constructeur_VIN string Type_VIN string Numero_de_serie string Modele string Categorie_clientele string DATE_ARRETE int VOLUME int JO int Date_Immatriculation } vme { int id PK int VIN PK string ORDER-NO PK int CAMPAIGN PK int OFFER PK int DEALER FK int NSC int BRANCH int PAYMENT-REF int CURRENT_PAYMENT string PAYMENT_STATUS string CRITERIA string PAY string MULTIPLIER string AMEND_DESCRIPTION int USER_ID string OFFER_TYPE string CATEGORY string MODEL_GROUP string LVC string ORDER_CLASS string ICSC string FLEET string CUSTOMER_NAME string DEALER_GROUP_CODE string PAYMENT_DEALER string RETAIL_PRICE string PAYMENT_TYPE string COLOUR_SURCHARGE string BASE_PRICE string SAP_GL_ACCT_CODE string SAP_ACC_DOC_NO string SAP_ORDER_CODE string REPORT_NO string CREATE_REASON string SALES_ORDER string OWNER_CODE string OWNER_CAT string DOC_TYPE string DOC_NO string COMPANY_CODE string MATERIAL_NO string COST_CENTER string GL_ACCOUNT string INCENTIVE_TYPE string PAYMENT_PT string PAYEE_TYPE string PAY_CREATION_DATE string TIMESTAMP string CUST_CONT_DATE string RETAIL_DATE string STATUS_CHANGE_DATE string CREATE_TIME string WHOLESALE_TIME string REG_DATE string DEFLEET_DATE string SAP_BILLING_DOC_NO string MODEL_VARIANT string DEFLEET_VOC string WHOLESALE_PRICE } log { int id PK int VehicleIdentifier PK int DealerCodeRetail PK string LogisticsBuisnessType string Datecreated string CreateTimestamp string CreateModule string CountryCode string DistributionNodetype string ShortName string FinancialOwnerCategoryCurrent string FinancialOwnerCategoryNext int CreateuserID string VehiculeAppliedStatus string ManualProcess string FinancialChangeOwner string PositveMovement string NegativeMovement string DateCreatedSQL string ChangeOfOwnershipTimestamp int NSCCode string DealerCodeRetailResponsible string DealerDeliveryAddrNoRetail string Movement string Transactiontype string TransTypeRuleused } cpe { int id PK int CAMPAIGN PK int NSC int BRANCH string DESCRIPTION string ADOPT_DATE string ABOLISH_DATE string CAMPAIGN_STATUS_CODE string UPDATE_USER_ID string UPDATE_TIMESTAMP } ofe { int id PK int CAMPAIGN PK int OFFER PK int NSC int BRANCH string OFFER_TYPE string CATEGORY_CODE string DEALER_DESC string INTERNAL_DESC string SAP_INTERNAL_CODE string PAYMENT_POINT_CODE string PAYEE_TYPE_CODE string PAYMENT_TYPE_CODE string VOLUME_CODE string FLEET_CODE string DISCOUNT_GRADE string DEALER_SELC string DISP_DEALER string SPECIAL_AGRMNT string SPECIAL_AGRMNT_LIMIT string SPECIAL_AGRMNT_USAGE string VOLUME_OFFER string MIN_DEPNDT_VOL_OFFER string OFFER_STATUS_CODE string UPDATE_USERID string UPDATE_TIMESTAMP string DISP_PAY_VAL_TO_DEALER string AVLB_AT_DE_FLEET string NORMAL_OFFER string CALC_VOL_ACV_PERCNT string DE_CNFRM_T_C_MANDETORY string RBU_APPROVAL_TIMESTAMP string RBU_APPROVAL_USERID } cpn { int id PK int CAMPAIGN PK int OFFER PK int NSC string BRANCH int CAMPAIGN string CAMPAIGN_Desc int OFFER string OFFER_Desc int Num_CAMPAIGN_OFFER string OFFER_CATEGORY } aaa { int id PK string VIN PK string DATE int Mois int Annee string Genre string Genre_UE string Marque string Type string Energie string Carosserie int Puissance_Fiscale int Code_Region int Code_Concession int Code_Departement int Code_Canton int Code_Commune string Commune int Code_CSP_proprietaire string Code_APE int Numero_SIREN int Annee_carte_grise int Mois_carte_grise int Jour_carte_grise string Lettres_immatriculation string Numero_immatriculation string Plaque_immatriculation string Code_constructeurVIN string Type_VIN string Numero_de_serie string Modele string Categorie_clientele string Date_ARRETE int VOLUME int JO string Date_Immatriculation } imm { int id PK int VIN PK string DATE string Genre string Marque string Type string Energie string Carosserie int PTR int ChargeUtile_PlacesAssises int Puissance_Fiscale int Code_region int Code_sous_region int Code_concession int Code_departement int Code_Canton int Code_Commune string Commune string Code_CSP_Proprietaire string Code_APE int Numero_SIREN int Annee_carte_grise int Mois_carte_grise int Jour_carte_grise string Lettres_immatriculation string Numero_immatriculation string Code_constructeur_VIN string Type_VIN string Numero_de_serie string Modele int Annee_1ere_mise_en_circulation int Mois_1ere_mise_en_circulation int Annee_carte_grise_precedente int Mois_carte_grise_precedente int Code_Departement_precedent string Categorie_Clientele string DATE_ARRETE int VOLUME int JO string Date_Immatriculation_VO } apv { int id PK int VIN PK int Dealer_Code FK string Product_Type string Customer_Type int Code_Site int Model string Term_months string UP_TO_MILEAGE string Date_of_Contract_Subscription } rci { int id PK int VIN PK string Lib_modele_simplifie string Lib_long_modele string Numero_chassis string Numero_contrat string Gestion_Pregestion string An_Mois_Date_Offre_Prealable string An_Mois_Entree_en_Gestion string Nom_affaire string Produit_financier string Loyers_Offerts string Code_Bareme string Reporting float Mt_Part_Fab_Ht string Remuneration string PROMO float Mt_Loyer } cre { int id PK int Code_5_chiffres PK int Dealer string Type_of_outlet string Sales_region int Sales_Zone_District string ZM string Directeur_Regional string Main_Dealer_NPP_Code int Contrat int Parent_Main_dealer_Code string Network_Unique_Identifier int Code string Activity string Categories string Aftersales_Categories string Group_NPP_Code string Parent_Group_Code string Sector string Company_name string Trading_name string Address string Address2 int PostCode string City string Alt_Address string Alt_Address2 int Alt_PostCode string Alt_City string Phone string Fax string EV_Type string Buisness_Center string Used_Vehicles_Program string NHPC string NRC string Bodyshop_Paint string StandAlone_MultiBrand string Solus_NonSolus string Area_Type string Company_form int Official_Commercial_registered_ID int Official_Commercial_registered_ID2 string Legal_Registration_place } der { int id PK int Code PK string Type string Derogation_rule string FR string Comment string Validator1 string Mail string Sale_earned_or_lost string VIN_or_FRN string DEALER string EMAIL1 string EMAIL2 string EMAIL3 string ZONE string DELIVERY_DATE string CUSTOMER_NAME string COMMENTS string VALUE string ATTACHEMENTS string VOC string Customer_contract_Date string Margin_transfer string registration_Date string Retail_Date string Loyalty_Trade } mail { int id PK int Dealer int Dealer_Code PK string mails string Commentaire string Dealer_Group int Zone string ZM } derogations_detail { int id PK int derogation_number PK int VIN PK } ord ||--|| vin : FinalDeliveryDealerCode vin ||--|{ vme : RetailResponsabilityDealer_and_Vin vme }|--|| mail : DEALER mail ||--|{ cre : Dealer_Code vme ||--|{ log : VIN vin ||--|| imm : Vin vme ||--|| imm : VIN vme }|--|| cpe : CAMPAIGN ofe ||--|{ vme : CAMPAIGN_and_OFFER cpn ||--|{ vme : CAMPAIGN_and_OFFER der ||--|{ derogations_detail : i derogations_detail ||--|| rci : VIN derogations_detail ||--|| aaa : VIN derogations_detail ||--|| apv : VIN derogations_detail ||--|| imm : VIN derogations_detail ||--|| vme : VIN