Tabel en kolom selectie

Schema en tabelnaam

54707_SA.Assignment 54707_SA.Codelist 54707_SA.FELICITATIE 54707_SA.ImportBRT2020 54707_SA.ImportGEM2020 54707_SA.ImportKNMI2022 54707_SA.ImportPC6GWB2020 54707_SA.Statement ALBERTO.Bestelling ALBERTO.Bezorger ALBERTO.Bezorging ALBERTO.BezorgingEvaluatie ALBERTO.DataMart_Bestelling ALBERTO.Datamart_Bezorging ALBERTO.DimDatum ALBERTO.DimGeografie ALBERTO.DimKlimaat ALBERTO.DimProductCategorie ALBERTO.DimVestiging ALBERTO.EBIStatement ALBERTO.FactBestelling ALBERTO.Felicitatie ALBERTO.Felicitaties ALBERTO.person ALBERTO.person_type ALBERTO.Personen ALBERTO.Persoon ALBERTO.ProductVerkoop ALBERTO.Relatietypes ALBERTO.VerkoopDashboard ALBERTO.VerkoopPivot ALBERTO.Vestiging ALBERTO.Vestiging_Bezorger C_.BezorgerExtra C_BERTJE.BezorgerExtra C_BRAM MEISENBACHER.BezorgerExtra C_BRAM MEISENBACHER.FELICITATIE CORRECT C_BRAM MEISENBACHER.Opdracht C_BRAM MEISENBACHER.Test1View C_GHULAMI.FELICITATIE C_ILSE.Bestelling C_JANOTTO.Felicitatie C_JEAN.DEMO C_JELLE.Felicitatie C_JOSHUA.VERJAARDAGEN C_MARGOTWR.BezorgerExtra C_MARGOTWR.Felicitatie C_MARGOTWR.Personeel C_MARGOTWR.Persoon C_MARGOTWR.Test C_MARGOTWR.Test1View C_MARK.DEMO C_MARK.INFO C_MARK.INFOO C_MARK.NAAM C_MARK1.EMAIL C_MARK1.NAAM C_MENNA.demotable C_MENNA.Felicitatie C_MENNA.Felicitatie_1 C_MENNA.Opdracht C_MENNA.Test C_MISCHA.DEMO C_MISCHA.Opdracht C_MISCHA.Persoon C_NIGEL.FELICITATIE C_NIGEL.OPDRACHT C_ROB.Felicitatie C_ROB.Opdracht C_ROBERTO.Felicitatie C_ROBERTO.Gebruiker C_ROBERTO.VERKOOP C_ROBV.Felicitatie C_ROBVS.BezorgerExtra C_ROBVS.Felicitatie C_SARAH.FELICITATIE DATAFUEL.AuTotaal DATAFUEL.Autoverbruik DBO.sysdiagrams FELICITATIE.Contact FELICITATIE.Contactpersoon FELICITATIE.Contactpersoon_Gebeurtenis FELICITATIE.FelicitatieLijst FELICITATIE.Gebeurtenis NORTHWIND.Alphabetical list of products NORTHWIND.Categories NORTHWIND.Category Sales for 1997 NORTHWIND.Current Product List NORTHWIND.Customer and Suppliers by City NORTHWIND.CustomerCustomerDemo NORTHWIND.CustomerDemographics NORTHWIND.Customers NORTHWIND.Employees NORTHWIND.EmployeeTerritories NORTHWIND.Invoices NORTHWIND.Order Details NORTHWIND.Order Details Extended NORTHWIND.Order Subtotals NORTHWIND.Orders NORTHWIND.Orders Qry NORTHWIND.Product Sales for 1997 NORTHWIND.Products NORTHWIND.Products Above Average Price NORTHWIND.Products by Category NORTHWIND.Quarterly Orders NORTHWIND.Region NORTHWIND.Sales by Category NORTHWIND.Sales Totals by Amount NORTHWIND.Shippers NORTHWIND.Summary of Sales by Quarter NORTHWIND.Summary of Sales by Year NORTHWIND.Suppliers NORTHWIND.Territories RESTAURANTDEMO.City RESTAURANTDEMO.friendOf RESTAURANTDEMO.likes RESTAURANTDEMO.livesIn RESTAURANTDEMO.locatedIn RESTAURANTDEMO.Person RESTAURANTDEMO.Restaurant RESTAURANTDEMO.Restaurantdocument ROBERTOV15.Klanten Schema en tabel combinatie is verplicht

Constraint type

Primaire sleutel

Verwijzende sleutel

Check constraint

Kolomnaam

Verwijzing naar tabel

54707_SA.Assignment 54707_SA.Codelist 54707_SA.FELICITATIE 54707_SA.ImportBRT2020 54707_SA.ImportGEM2020 54707_SA.ImportKNMI2022 54707_SA.ImportPC6GWB2020 54707_SA.Statement ALBERTO.Bestelling ALBERTO.Bezorger ALBERTO.Bezorging ALBERTO.BezorgingEvaluatie ALBERTO.DataMart_Bestelling ALBERTO.Datamart_Bezorging ALBERTO.DimDatum ALBERTO.DimGeografie ALBERTO.DimKlimaat ALBERTO.DimProductCategorie ALBERTO.DimVestiging ALBERTO.EBIStatement ALBERTO.FactBestelling ALBERTO.Felicitatie ALBERTO.Felicitaties ALBERTO.person ALBERTO.person_type ALBERTO.Personen ALBERTO.Persoon ALBERTO.ProductVerkoop ALBERTO.Relatietypes ALBERTO.VerkoopDashboard ALBERTO.VerkoopPivot ALBERTO.Vestiging ALBERTO.Vestiging_Bezorger C_.BezorgerExtra C_BERTJE.BezorgerExtra C_BRAM MEISENBACHER.BezorgerExtra C_BRAM MEISENBACHER.FELICITATIE CORRECT C_BRAM MEISENBACHER.Opdracht C_BRAM MEISENBACHER.Test1View C_GHULAMI.FELICITATIE C_ILSE.Bestelling C_JANOTTO.Felicitatie C_JEAN.DEMO C_JELLE.Felicitatie C_JOSHUA.VERJAARDAGEN C_MARGOTWR.BezorgerExtra C_MARGOTWR.Felicitatie C_MARGOTWR.Personeel C_MARGOTWR.Persoon C_MARGOTWR.Test C_MARGOTWR.Test1View C_MARK.DEMO C_MARK.INFO C_MARK.INFOO C_MARK.NAAM C_MARK1.EMAIL C_MARK1.NAAM C_MENNA.demotable C_MENNA.Felicitatie C_MENNA.Felicitatie_1 C_MENNA.Opdracht C_MENNA.Test C_MISCHA.DEMO C_MISCHA.Opdracht C_MISCHA.Persoon C_NIGEL.FELICITATIE C_NIGEL.OPDRACHT C_ROB.Felicitatie C_ROB.Opdracht C_ROBERTO.Felicitatie C_ROBERTO.Gebruiker C_ROBERTO.VERKOOP C_ROBV.Felicitatie C_ROBVS.BezorgerExtra C_ROBVS.Felicitatie C_SARAH.FELICITATIE DATAFUEL.AuTotaal DATAFUEL.Autoverbruik DBO.sysdiagrams FELICITATIE.Contact FELICITATIE.Contactpersoon FELICITATIE.Contactpersoon_Gebeurtenis FELICITATIE.FelicitatieLijst FELICITATIE.Gebeurtenis NORTHWIND.Alphabetical list of products NORTHWIND.Categories NORTHWIND.Category Sales for 1997 NORTHWIND.Current Product List NORTHWIND.Customer and Suppliers by City NORTHWIND.CustomerCustomerDemo NORTHWIND.CustomerDemographics NORTHWIND.Customers NORTHWIND.Employees NORTHWIND.EmployeeTerritories NORTHWIND.Invoices NORTHWIND.Order Details NORTHWIND.Order Details Extended NORTHWIND.Order Subtotals NORTHWIND.Orders NORTHWIND.Orders Qry NORTHWIND.Product Sales for 1997 NORTHWIND.Products NORTHWIND.Products Above Average Price NORTHWIND.Products by Category NORTHWIND.Quarterly Orders NORTHWIND.Region NORTHWIND.Sales by Category NORTHWIND.Sales Totals by Amount NORTHWIND.Shippers NORTHWIND.Summary of Sales by Quarter NORTHWIND.Summary of Sales by Year NORTHWIND.Suppliers NORTHWIND.Territories RESTAURANTDEMO.City RESTAURANTDEMO.friendOf RESTAURANTDEMO.likes RESTAURANTDEMO.livesIn RESTAURANTDEMO.locatedIn RESTAURANTDEMO.Person RESTAURANTDEMO.Restaurant RESTAURANTDEMO.Restaurantdocument ROBERTOV15.Klanten

Check constraint

SQL Query