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 54707_SA.VELI 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.event 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 ARCHIGRAPH.A_Access ARCHIGRAPH.A_Aggregation ARCHIGRAPH.A_ApplicationComponent ARCHIGRAPH.A_ApplicationFunction ARCHIGRAPH.A_ApplicationInterface ARCHIGRAPH.A_ApplicationService ARCHIGRAPH.A_Assignment ARCHIGRAPH.A_Association ARCHIGRAPH.A_BusinessActor ARCHIGRAPH.A_BusinessEvent ARCHIGRAPH.A_BusinessObject ARCHIGRAPH.A_BusinessProcess ARCHIGRAPH.A_BusinessRole ARCHIGRAPH.A_Composition ARCHIGRAPH.A_Constraint ARCHIGRAPH.A_DataObject ARCHIGRAPH.A_Deliverable ARCHIGRAPH.A_DistributionNetwork ARCHIGRAPH.A_Driver ARCHIGRAPH.A_Equipment ARCHIGRAPH.A_Facility ARCHIGRAPH.A_Flow ARCHIGRAPH.A_Gap ARCHIGRAPH.A_Goal ARCHIGRAPH.A_Influence ARCHIGRAPH.A_Junction ARCHIGRAPH.A_Material ARCHIGRAPH.A_Node ARCHIGRAPH.A_Outcome ARCHIGRAPH.A_Plateau ARCHIGRAPH.A_Principle ARCHIGRAPH.A_Realization ARCHIGRAPH.A_Requirement ARCHIGRAPH.A_Serving ARCHIGRAPH.A_Specialization ARCHIGRAPH.A_Stakeholder ARCHIGRAPH.A_SystemSoftware ARCHIGRAPH.A_TechnologyFunction ARCHIGRAPH.A_TechnologyInterface ARCHIGRAPH.A_TechnologyProcess ARCHIGRAPH.A_TechnologyService ARCHIGRAPH.A_Triggering ARCHIGRAPH.A_WorkPackage C_BERT.Opdracht C_GHULAMI.FELICITATIE C_JEAN.DEMO C_JELLE.Felicitatie C_MARGOTWR.Felicitatie C_MARGOTWR.Personeel C_MARGOTWR.Persoon C_MARK.DEMO C_MARK.INFO C_MARK.INFOO C_MARK.NAAM C_MARK1.EMAIL C_MARK1.NAAM C_NIGEL.FELICITATIE C_NIGEL.OPDRACHT DATAFUEL.AuTotaal DATAFUEL.Autoverbruik DBO.A_Element DBO.A_Relation 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 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 54707_SA.VELI 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.event 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 ARCHIGRAPH.A_Access ARCHIGRAPH.A_Aggregation ARCHIGRAPH.A_ApplicationComponent ARCHIGRAPH.A_ApplicationFunction ARCHIGRAPH.A_ApplicationInterface ARCHIGRAPH.A_ApplicationService ARCHIGRAPH.A_Assignment ARCHIGRAPH.A_Association ARCHIGRAPH.A_BusinessActor ARCHIGRAPH.A_BusinessEvent ARCHIGRAPH.A_BusinessObject ARCHIGRAPH.A_BusinessProcess ARCHIGRAPH.A_BusinessRole ARCHIGRAPH.A_Composition ARCHIGRAPH.A_Constraint ARCHIGRAPH.A_DataObject ARCHIGRAPH.A_Deliverable ARCHIGRAPH.A_DistributionNetwork ARCHIGRAPH.A_Driver ARCHIGRAPH.A_Equipment ARCHIGRAPH.A_Facility ARCHIGRAPH.A_Flow ARCHIGRAPH.A_Gap ARCHIGRAPH.A_Goal ARCHIGRAPH.A_Influence ARCHIGRAPH.A_Junction ARCHIGRAPH.A_Material ARCHIGRAPH.A_Node ARCHIGRAPH.A_Outcome ARCHIGRAPH.A_Plateau ARCHIGRAPH.A_Principle ARCHIGRAPH.A_Realization ARCHIGRAPH.A_Requirement ARCHIGRAPH.A_Serving ARCHIGRAPH.A_Specialization ARCHIGRAPH.A_Stakeholder ARCHIGRAPH.A_SystemSoftware ARCHIGRAPH.A_TechnologyFunction ARCHIGRAPH.A_TechnologyInterface ARCHIGRAPH.A_TechnologyProcess ARCHIGRAPH.A_TechnologyService ARCHIGRAPH.A_Triggering ARCHIGRAPH.A_WorkPackage C_BERT.Opdracht C_GHULAMI.FELICITATIE C_JEAN.DEMO C_JELLE.Felicitatie C_MARGOTWR.Felicitatie C_MARGOTWR.Personeel C_MARGOTWR.Persoon C_MARK.DEMO C_MARK.INFO C_MARK.INFOO C_MARK.NAAM C_MARK1.EMAIL C_MARK1.NAAM C_NIGEL.FELICITATIE C_NIGEL.OPDRACHT DATAFUEL.AuTotaal DATAFUEL.Autoverbruik DBO.A_Element DBO.A_Relation 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

Check constraint

SQL Query