SQL Query

Execute queries for retrieving from the database.

  • Select tables
  • Select views
  • Select joins etc
  • You can also execute statements



Result

in the table below:
Rows: 621
Colums: 6

table_schematable_namecolumn_nameordinal_positionis_nullabledata_type
albertoA_Accessgraph_id_9FB1618645054E85A150670A28EFD29D1NObigint
albertoA_Access$edge_id_683AA93C85CE415C8C76C569BED546D72NOnvarchar
albertoA_Accessfrom_obj_id_34C4C8EB553B443AAFF5A59B8CF9B0703NOint
albertoA_Accessfrom_id_B42BA8459F734FC69475BF5F20A054AF4NObigint
albertoA_Access$from_id_F4A07D9032C64EE187E98770ADB3305C5YESnvarchar
albertoA_Accessto_obj_id_9EDEB32F3B2B4256963639C133A50AC76NOint
albertoA_Accessto_id_6565DDD164B84314A7F6C7A29B52084A7NObigint
albertoA_Access$to_id_6A974B8676194EC1AA24FA0CD9EC54798YESnvarchar
albertoA_Accessname9YESvarchar
albertoA_Accessversion10YESvarchar
albertoA_Accessnote11YEStext
albertoA_Aggregationgraph_id_4588440ADDC84E5680AADE4495EBB47D1NObigint
albertoA_Aggregation$edge_id_C825D58825D54D0097E393C11168EC8B2NOnvarchar
albertoA_Aggregationfrom_obj_id_3AEC0CD8030B470DB452DC03B368AABF3NOint
albertoA_Aggregationfrom_id_CD8FF6B53F50458A9C2E87548596F2344NObigint
albertoA_Aggregation$from_id_19412487A8394F6589520E9BB835ED795YESnvarchar
albertoA_Aggregationto_obj_id_6A04E091E0E94C8998BC89A2977FE1E06NOint
albertoA_Aggregationto_id_4D61EA7CFAB5494494830CB17A76589D7NObigint
albertoA_Aggregation$to_id_622FE64650FC48A09E10B9A61BA4C2878YESnvarchar
albertoA_Aggregationname9YESvarchar
albertoA_Aggregationversion10YESvarchar
albertoA_Aggregationnote11YEStext
albertoA_ApplicationComponentgraph_id_E2F2DAECACFE48B3B9170F5648E535AD1NObigint
albertoA_ApplicationComponent$node_id_993FE0FC7E2A44D89C78E6A452F1172C2NOnvarchar
albertoA_ApplicationComponentID3NOint
albertoA_ApplicationComponentname4YESvarchar
albertoA_ApplicationComponentnote5YEStext
albertoA_ApplicationComponentversion6YESvarchar
albertoA_ApplicationComponentsynonyms7YESvarchar
albertoA_ApplicationFunctiongraph_id_13719E6E03154FE78D0C1B8197E1FE321NObigint
albertoA_ApplicationFunction$node_id_A9AAD9D0F11440329C529409F2C908FC2NOnvarchar
albertoA_ApplicationFunctionID3NOint
albertoA_ApplicationFunctionname4YESvarchar
albertoA_ApplicationFunctionnote5YEStext
albertoA_ApplicationFunctionversion6YESvarchar
albertoA_ApplicationFunctionsynonyms7YESvarchar
albertoA_ApplicationInterfacegraph_id_D24615F6BF1145F4856E64D46FAEEE711NObigint
albertoA_ApplicationInterface$node_id_BD79522222604BE3B1C295DEC72726FD2NOnvarchar
albertoA_ApplicationInterfaceID3NOint
albertoA_ApplicationInterfacename4YESvarchar
albertoA_ApplicationInterfacenote5YEStext
albertoA_ApplicationInterfaceversion6YESvarchar
albertoA_ApplicationInterfacesynonyms7YESvarchar
albertoA_ApplicationServicegraph_id_B821D47DB9F94E52BB9679DC102B26E01NObigint
albertoA_ApplicationService$node_id_B237F72BC7754DF0906B67020395E99C2NOnvarchar
albertoA_ApplicationServiceID3NOint
albertoA_ApplicationServicename4YESvarchar
albertoA_ApplicationServicenote5YEStext
albertoA_ApplicationServiceversion6YESvarchar
albertoA_ApplicationServicesynonyms7YESvarchar
albertoA_Assignmentgraph_id_E25183804D0E42E8B65D7A09B1A221A61NObigint
albertoA_Assignment$edge_id_B353221D4E3248FB85BF44875AD9D3E32NOnvarchar
albertoA_Assignmentfrom_obj_id_5FB3E1E5DAA34AB5A2F702D300078B6D3NOint
albertoA_Assignmentfrom_id_7BC6DACDD4F64D7A80185471B31011E24NObigint
albertoA_Assignment$from_id_30A75AF52DC64E74843E0E7D1088F2F45YESnvarchar
albertoA_Assignmentto_obj_id_8620B7BF93844A7FB6DBB2BDC318CE046NOint
albertoA_Assignmentto_id_3B3828B344264B9E9BABC2B8622A17D37NObigint
albertoA_Assignment$to_id_DE6F378776A8477396EF510A529BB96D8YESnvarchar
albertoA_Assignmentname9YESvarchar
albertoA_Assignmentversion10YESvarchar
albertoA_Assignmentnote11YEStext
albertoA_Associationgraph_id_66477A7D1E5741BC8AC594938F215ABA1NObigint
albertoA_Association$edge_id_26CEDB249DCD4B7AB8A351D0E70CA7C72NOnvarchar
albertoA_Associationfrom_obj_id_E27D4BF4881F40749551504B476725323NOint
albertoA_Associationfrom_id_30B32300E2F54FF2B68C5F5FA0B44EFF4NObigint
albertoA_Association$from_id_3BC25A492F544128B89A1CB4D9CD8ECC5YESnvarchar
albertoA_Associationto_obj_id_2B774D47952E4921809D0584814134AD6NOint
albertoA_Associationto_id_200DBCB765104B7E877237AE7E3B99D27NObigint
albertoA_Association$to_id_8197E2273F684BB3A82A23395EB450FD8YESnvarchar
albertoA_Associationname9YESvarchar
albertoA_Associationversion10YESvarchar
albertoA_Associationnote11YEStext
albertoA_BusinessActorgraph_id_809F78A1A43D459CA46F46F65AA3FC151NObigint
albertoA_BusinessActor$node_id_C6BD02C874D0471E9C2CF3A007C90FAA2NOnvarchar
albertoA_BusinessActorID3NOint
albertoA_BusinessActorname4YESvarchar
albertoA_BusinessActornote5YEStext
albertoA_BusinessActorversion6YESvarchar
albertoA_BusinessActorsynonyms7YESvarchar
albertoA_BusinessEventgraph_id_5F32FB9F2D3144DA85EE50D4343E80041NObigint
albertoA_BusinessEvent$node_id_5B7544EB206F4E23B1BCB2B090573E732NOnvarchar
albertoA_BusinessEventID3NOint
albertoA_BusinessEventname4YESvarchar
albertoA_BusinessEventnote5YEStext
albertoA_BusinessEventversion6YESvarchar
albertoA_BusinessEventsynonyms7YESvarchar
albertoA_BusinessObjectgraph_id_A7947C478E85411CA8B470A1F47BFE511NObigint
albertoA_BusinessObject$node_id_DECD5E07613B44B199B09700D30140B32NOnvarchar
albertoA_BusinessObjectID3NOint
albertoA_BusinessObjectname4YESvarchar
albertoA_BusinessObjectnote5YEStext
albertoA_BusinessObjectversion6YESvarchar
albertoA_BusinessObjectsynonyms7YESvarchar
albertoA_BusinessProcessgraph_id_3549A0DF89144C0FA13EDDA8A1672C951NObigint
albertoA_BusinessProcess$node_id_261DF46EFEBE4EEFBFF35F442E29AF8D2NOnvarchar
albertoA_BusinessProcessID3NOint
albertoA_BusinessProcessname4YESvarchar
albertoA_BusinessProcessnote5YEStext
albertoA_BusinessProcessversion6YESvarchar
albertoA_BusinessProcesssynonyms7YESvarchar
albertoA_BusinessRolegraph_id_836566ABCD314F3582CA54BE224112D11NObigint
albertoA_BusinessRole$node_id_A3CCFE8E87B244FC82638AD7421661B12NOnvarchar
albertoA_BusinessRoleID3NOint
albertoA_BusinessRolename4YESvarchar
albertoA_BusinessRolenote5YEStext
albertoA_BusinessRoleversion6YESvarchar
albertoA_BusinessRolesynonyms7YESvarchar
albertoA_Compositiongraph_id_9A809F0B5DBB418EB0FF8C68F514180A1NObigint
albertoA_Composition$edge_id_B7936E6C8AAF40C3B6F2112D8A56AFF22NOnvarchar
albertoA_Compositionfrom_obj_id_C4B9D3B2071E4B979337A6371AEB5F123NOint
albertoA_Compositionfrom_id_34DC19420BAC4340A312ABB2384797294NObigint
albertoA_Composition$from_id_36D52A9F539146AA826AA94FFAEFAD2A5YESnvarchar
albertoA_Compositionto_obj_id_087719AF0580473F84317013FA28EB0F6NOint
albertoA_Compositionto_id_E4B6DF5876BF42BE965D68F94FF23A337NObigint
albertoA_Composition$to_id_444162190CEC4CC8A01686A8D24A92BF8YESnvarchar
albertoA_Compositionname9YESvarchar
albertoA_Compositionversion10YESvarchar
albertoA_Compositionnote11YEStext
albertoA_Constraintgraph_id_EB2B03D33E584DFD9FB58DA7AC6156521NObigint
albertoA_Constraint$node_id_FABABD4709824BC4AE3895C8F89BD8CF2NOnvarchar
albertoA_ConstraintID3NOint
albertoA_Constraintname4YESvarchar
albertoA_Constraintnote5YEStext
albertoA_Constraintversion6YESvarchar
albertoA_Constraintsynonyms7YESvarchar
albertoA_DataObjectgraph_id_AE10807656914F08B8950890E218AC7B1NObigint
albertoA_DataObject$node_id_0DDA3CCE29FA409FA610CF52B43172452NOnvarchar
albertoA_DataObjectID3NOint
albertoA_DataObjectname4YESvarchar
albertoA_DataObjectnote5YEStext
albertoA_DataObjectversion6YESvarchar
albertoA_DataObjectsynonyms7YESvarchar
albertoA_Deliverablegraph_id_5EC4CA19722843BB9632B3349767E3941NObigint
albertoA_Deliverable$node_id_F625A807B89A4997B27C6A473B022CF92NOnvarchar
albertoA_DeliverableID3NOint
albertoA_Deliverablename4YESvarchar
albertoA_Deliverablenote5YEStext
albertoA_Deliverableversion6YESvarchar
albertoA_Deliverablesynonyms7YESvarchar
albertoA_DistributionNetworkgraph_id_F9CFCB30F40D419785A493663AD09FD21NObigint
albertoA_DistributionNetwork$node_id_63B0C84252A145EDB7F1E18FAC342A262NOnvarchar
albertoA_DistributionNetworkID3NOint
albertoA_DistributionNetworkname4YESvarchar
albertoA_DistributionNetworknote5YEStext
albertoA_DistributionNetworkversion6YESvarchar
albertoA_DistributionNetworksynonyms7YESvarchar
albertoA_Drivergraph_id_6B7139132D4F4CBEAB0D0CD49AC2A4A31NObigint
albertoA_Driver$node_id_4955C7B800C94778A0F89B648D12279A2NOnvarchar
albertoA_DriverID3NOint
albertoA_Drivername4YESvarchar
albertoA_Drivernote5YEStext
albertoA_Driverversion6YESvarchar
albertoA_Driversynonyms7YESvarchar
albertoA_Equipmentgraph_id_F15EEAC4A79C4C3DB41E7C134602ECB01NObigint
albertoA_Equipment$node_id_FE9A88B848B840DABA50136857E9DF212NOnvarchar
albertoA_EquipmentID3NOint
albertoA_Equipmentname4YESvarchar
albertoA_Equipmentnote5YEStext
albertoA_Equipmentversion6YESvarchar
albertoA_Equipmentsynonyms7YESvarchar
albertoA_Facilitygraph_id_ED78F50C65B9473196932314302FD9721NObigint
albertoA_Facility$node_id_666CB313D13E4DEFBF9350B5B6110EB42NOnvarchar
albertoA_FacilityID3NOint
albertoA_Facilityname4YESvarchar
albertoA_Facilitynote5YEStext
albertoA_Facilityversion6YESvarchar
albertoA_Facilitysynonyms7YESvarchar
albertoA_Flowgraph_id_D91437265C654275A7C5AA061D8091921NObigint
albertoA_Flow$edge_id_E88CD618F7094C4FAFE55415C6FDB9062NOnvarchar
albertoA_Flowfrom_obj_id_7276A407DD624D208CAA03E33710D9933NOint
albertoA_Flowfrom_id_E2A3EEE1BE8B49238CF6C5D77443F1804NObigint
albertoA_Flow$from_id_561193CE6121401696768E63EC32F1325YESnvarchar
albertoA_Flowto_obj_id_F5B16A84E773436E9F65BB83CFBC0D126NOint
albertoA_Flowto_id_7C715BA2800C418783F54E8F1AB675367NObigint
albertoA_Flow$to_id_B5A4B3E658864460B3E42645DE714B208YESnvarchar
albertoA_Flowname9YESvarchar
albertoA_Flowversion10YESvarchar
albertoA_Flownote11YEStext
albertoA_Gapgraph_id_6507CC58B75842D9A58B320B0E5EEA111NObigint
albertoA_Gap$node_id_F6E16A16E12A4F3B9275C06E6C25922B2NOnvarchar
albertoA_GapID3NOint
albertoA_Gapname4YESvarchar
albertoA_Gapnote5YEStext
albertoA_Gapversion6YESvarchar
albertoA_Gapsynonyms7YESvarchar
albertoA_Goalgraph_id_56322A8B5B594B6AA9360D9E587EC1671NObigint
albertoA_Goal$node_id_C4352409C05C40BAB17FE9D78F8C1A8F2NOnvarchar
albertoA_GoalID3NOint
albertoA_Goalname4YESvarchar
albertoA_Goalnote5YEStext
albertoA_Goalversion6YESvarchar
albertoA_Goalsynonyms7YESvarchar
albertoA_Influencegraph_id_8CCE48A0E4D24BAD84ADC07A59F72F2C1NObigint
albertoA_Influence$edge_id_C90105B0D15246979BBFE76BCDB2A4782NOnvarchar
albertoA_Influencefrom_obj_id_25679DC8103A4DC0AD973CF060F2592D3NOint
albertoA_Influencefrom_id_CAC6FC57D4EC45BB872EA3B751FDBF204NObigint
albertoA_Influence$from_id_E444C07FD5AE4B8E8AE9BA0E8401870E5YESnvarchar
albertoA_Influenceto_obj_id_C8159899B64F4BD6996C18DCE093D6C66NOint
albertoA_Influenceto_id_E8008B542B38423A8F381DD52862261A7NObigint
albertoA_Influence$to_id_2AEB0762A4E7419D99697118D392CCD28YESnvarchar
albertoA_Influencename9YESvarchar
albertoA_Influenceversion10YESvarchar
albertoA_Influencenote11YEStext
albertoA_Junctiongraph_id_4A046E2C6442451FA841C349C7601C871NObigint
albertoA_Junction$node_id_B57AFC466BD74B2CA6C80754FC26B0C22NOnvarchar
albertoA_JunctionID3NOint
albertoA_Junctionname4YESvarchar
albertoA_Junctionnote5YEStext
albertoA_Junctionversion6YESvarchar
albertoA_Junctionsynonyms7YESvarchar
albertoA_Materialgraph_id_4BF37BE0D7AA482CB5E8683394BD729B1NObigint
albertoA_Material$node_id_0B5B1638C8D34E4FA371D62491CDA3F52NOnvarchar
albertoA_MaterialID3NOint
albertoA_Materialname4YESvarchar
albertoA_Materialnote5YEStext
albertoA_Materialversion6YESvarchar
albertoA_Materialsynonyms7YESvarchar
albertoA_Nodegraph_id_30AB5B94ED754385B7F544178B9B0D5F1NObigint
albertoA_Node$node_id_F68C4AAC68EB4E5DAAA4FC7B40C0B05C2NOnvarchar
albertoA_NodeID3NOint
albertoA_Nodename4YESvarchar
albertoA_Nodenote5YEStext
albertoA_Nodeversion6YESvarchar
albertoA_Nodesynonyms7YESvarchar
albertoA_Outcomegraph_id_4819972C970440C19A278CC73398F2DB1NObigint
albertoA_Outcome$node_id_36D481BFFD624ABBB780D9127D1974FF2NOnvarchar
albertoA_OutcomeID3NOint
albertoA_Outcomename4YESvarchar
albertoA_Outcomenote5YEStext
albertoA_Outcomeversion6YESvarchar
albertoA_Outcomesynonyms7YESvarchar
albertoA_Plateaugraph_id_08CD4DC842A049F385A4084123B284021NObigint
albertoA_Plateau$node_id_FA3E954EA2CE4FBA807235010395ADAD2NOnvarchar
albertoA_PlateauID3NOint
albertoA_Plateauname4YESvarchar
albertoA_Plateaunote5YEStext
albertoA_Plateauversion6YESvarchar
albertoA_Plateausynonyms7YESvarchar
albertoA_Principlegraph_id_07AFA750F25A4C3CA813EBA34E21C2071NObigint
albertoA_Principle$node_id_9036E1770CE54F89B2C9476FEF981F712NOnvarchar
albertoA_PrincipleID3NOint
albertoA_Principlename4YESvarchar
albertoA_Principlenote5YEStext
albertoA_Principleversion6YESvarchar
albertoA_Principlesynonyms7YESvarchar
albertoA_Realizationgraph_id_5102251C889D4E659C29FBC5020ABC6E1NObigint
albertoA_Realization$edge_id_0A786B21CD2D44B19E1F031DDE018F072NOnvarchar
albertoA_Realizationfrom_obj_id_E742861067504813AD7DD45851B56DEE3NOint
albertoA_Realizationfrom_id_240649939BF0450F9D35785FF765556A4NObigint
albertoA_Realization$from_id_5AC7B8F5F80A45C78407C4691BF548DA5YESnvarchar
albertoA_Realizationto_obj_id_391183A2782C4BBF8199BEE8C5D8AF4E6NOint
albertoA_Realizationto_id_6C6F9D298273428DA80BAB61CC7568247NObigint
albertoA_Realization$to_id_13E268431DCD49419137B23AE136FBFF8YESnvarchar
albertoA_Realizationname9YESvarchar
albertoA_Realizationversion10YESvarchar
albertoA_Realizationnote11YEStext
albertoA_Requirementgraph_id_EDA839C5766B43338094AB02B173B9C21NObigint
albertoA_Requirement$node_id_6B3FFD31BBEF47ED962C305D06A2FF8D2NOnvarchar
albertoA_RequirementID3NOint
albertoA_Requirementname4YESvarchar
albertoA_Requirementnote5YEStext
albertoA_Requirementversion6YESvarchar
albertoA_Requirementsynonyms7YESvarchar
albertoA_Servinggraph_id_E0581D1B22AD47CBBCAFC6D66EA7D02F1NObigint
albertoA_Serving$edge_id_0EDB8BE434884624A8C34B0C821DB8A32NOnvarchar
albertoA_Servingfrom_obj_id_6AF6206E14B946AC9E5FAF790D5380263NOint
albertoA_Servingfrom_id_28ECF294E34E48E197BFBF4B0A069AF54NObigint
albertoA_Serving$from_id_402E5F9CAB864E0FA9323763EB87BEFB5YESnvarchar
albertoA_Servingto_obj_id_D52FF2B18C084E829A28DB5CF281C42A6NOint
albertoA_Servingto_id_8877039ACA3A48669E314E06F20D482E7NObigint
albertoA_Serving$to_id_F0F776CA51434BC49139AFD681B08D2A8YESnvarchar
albertoA_Servingname9YESvarchar
albertoA_Servingversion10YESvarchar
albertoA_Servingnote11YEStext
albertoA_Specializationgraph_id_C218D095CE33426D948449F85EBB07EC1NObigint
albertoA_Specialization$edge_id_E91B3F10491A4899851413672BEE89CD2NOnvarchar
albertoA_Specializationfrom_obj_id_778775201DC04F49A2AC2F3C0898E7F93NOint
albertoA_Specializationfrom_id_E61951E118F541CC987760DB58FE76FD4NObigint
albertoA_Specialization$from_id_985E8FE320B44241B2759D449FDC42375YESnvarchar
albertoA_Specializationto_obj_id_B78DA1831ED942F89A588508BB847CFF6NOint
albertoA_Specializationto_id_2FCFA820DBB4484ABF9D910C45316E417NObigint
albertoA_Specialization$to_id_DD506417533F40FE8AEDE8ED98D777008YESnvarchar
albertoA_Specializationname9YESvarchar
albertoA_Specializationversion10YESvarchar
albertoA_Specializationnote11YEStext
albertoA_Stakeholdergraph_id_71539D892B5341F19EF7716361DE704E1NObigint
albertoA_Stakeholder$node_id_2B85B848C629479E891CD39EAF5690A02NOnvarchar
albertoA_StakeholderID3NOint
albertoA_Stakeholdername4YESvarchar
albertoA_Stakeholdernote5YEStext
albertoA_Stakeholderversion6YESvarchar
albertoA_Stakeholdersynonyms7YESvarchar
albertoA_SystemSoftwaregraph_id_E5F4285CF28C4698AD48D083367183741NObigint
albertoA_SystemSoftware$node_id_1181FCCA29184B9DAE1DD883FEC8A5EA2NOnvarchar
albertoA_SystemSoftwareID3NOint
albertoA_SystemSoftwarename4YESvarchar
albertoA_SystemSoftwarenote5YEStext
albertoA_SystemSoftwareversion6YESvarchar
albertoA_SystemSoftwaresynonyms7YESvarchar
albertoA_TechnologyFunctiongraph_id_4F93B2164D4A46C6ABE72CE18B73F2BB1NObigint
albertoA_TechnologyFunction$node_id_7F6A28111DB7487DB03390B8DE22739D2NOnvarchar
albertoA_TechnologyFunctionID3NOint
albertoA_TechnologyFunctionname4YESvarchar
albertoA_TechnologyFunctionnote5YEStext
albertoA_TechnologyFunctionversion6YESvarchar
albertoA_TechnologyFunctionsynonyms7YESvarchar
albertoA_TechnologyInterfacegraph_id_A0EBE90A254D48979117F2FAD8237BA31NObigint
albertoA_TechnologyInterface$node_id_52753A38DD77439FB0442813A23233052NOnvarchar
albertoA_TechnologyInterfaceID3NOint
albertoA_TechnologyInterfacename4YESvarchar
albertoA_TechnologyInterfacenote5YEStext
albertoA_TechnologyInterfaceversion6YESvarchar
albertoA_TechnologyInterfacesynonyms7YESvarchar
albertoA_TechnologyProcessgraph_id_C2E8B1BA9C5F436A9522305B6416DD2B1NObigint
albertoA_TechnologyProcess$node_id_3B954AD89144424C8D4B39190472F1892NOnvarchar
albertoA_TechnologyProcessID3NOint
albertoA_TechnologyProcessname4YESvarchar
albertoA_TechnologyProcessnote5YEStext
albertoA_TechnologyProcessversion6YESvarchar
albertoA_TechnologyProcesssynonyms7YESvarchar
albertoA_TechnologyServicegraph_id_CA7D8857D2834F19AC4BBB6ECCD3874D1NObigint
albertoA_TechnologyService$node_id_E7E509666B49402480DFCD9B173A59DF2NOnvarchar
albertoA_TechnologyServiceID3NOint
albertoA_TechnologyServicename4YESvarchar
albertoA_TechnologyServicenote5YEStext
albertoA_TechnologyServiceversion6YESvarchar
albertoA_TechnologyServicesynonyms7YESvarchar
albertoA_Triggeringgraph_id_06E55C6B1A5542998196069D55F7CA5C1NObigint
albertoA_Triggering$edge_id_DBC69D7F4B9B4E5987590F58EBB392802NOnvarchar
albertoA_Triggeringfrom_obj_id_1B682D6259504E7CA6247DC5652524BF3NOint
albertoA_Triggeringfrom_id_BFF47ADF999E41E2B84347BE2F8780B54NObigint
albertoA_Triggering$from_id_2C4104FAD8FF4284A3EF06C9A5A1FBBA5YESnvarchar
albertoA_Triggeringto_obj_id_3FAA6E3494D040BDBA184E8990032D3A6NOint
albertoA_Triggeringto_id_59121DF4A07B4838998A57760EF81A5A7NObigint
albertoA_Triggering$to_id_711BB7BEB94A442485DBD30E838A3C258YESnvarchar
albertoA_Triggeringname9YESvarchar
albertoA_Triggeringversion10YESvarchar
albertoA_Triggeringnote11YEStext
albertoA_WorkPackagegraph_id_C49527213D9447B1809AAE256F71D0271NObigint
albertoA_WorkPackage$node_id_F2D880A036F44AE5A9C9C68F3D77FDA92NOnvarchar
albertoA_WorkPackageID3NOint
albertoA_WorkPackagename4YESvarchar
albertoA_WorkPackagenote5YEStext
albertoA_WorkPackageversion6YESvarchar
albertoA_WorkPackagesynonyms7YESvarchar
albertoAnjaniView.FelicitatieFelicitatie_id1NOsmallint
albertoAnjaniView.FelicitatieRelatie_naam2NOnvarchar
albertoAnjaniView.FelicitatieEmailadres3NOvarchar
albertoAnjaniView.FelicitatieReden_felicitatie_14NOnvarchar
albertoAnjaniView.FelicitatieDatum_felicitatie_15NOdate
albertoAnjaniView.FelicitatieReden_felicitatie_26YESnvarchar
albertoAnjaniView.FelicitatieDatum_felicitatie_27YESdate
albertoBestellingBestelling_id1NOint
albertoBestellingBestel_datum2YESdatetime
albertoBestellingBestel_aantal3YESint
albertoBestellingBestel_bedrag4YESdecimal
albertoBestellingPostcode5YESnvarchar
albertoBestellingProduct_categorie6YESvarchar
albertoBestellingvestiging_id7YESint
albertoBezorgerBezorger_id1NOint
albertoBezorgerNaam2NOvarchar
albertoBezorgerVervoermiddel3YESvarchar
albertoBezorgingBezorging_id1NOint
albertoBezorgingAfstand2YESint
albertoBezorgingOppik_datum3YESdatetime
albertoBezorgingAflever_datum4YESdatetime
albertoBezorgingVestiging_bezorger_id5NOint
albertoBezorgingBestelling_id6NOint
albertoBezorgingEvaluatieBezorgingEvaluatie_id1NOint
albertoBezorgingEvaluatieBezorging_id2YESint
albertoBezorgingEvaluatieEvaluatie_Score3YESint
albertoBezorgingEvaluatieOpmerking4YEStext
albertoCitygraph_id_C421B16C84224387B149A7FCB218C47C1NObigint
albertoCity$node_id_3A93ABDBB150483FADA6B453F242CAF12NOnvarchar
albertoCityID3NOint
albertoCityname4YESvarchar
albertoCitystateName5YESvarchar
albertodatamart_besteling_tblGpostcode1NOnvarchar
albertodatamart_besteling_tblGbuurt2YESnvarchar
albertodatamart_besteling_tblGwijk3NOnvarchar
albertodatamart_besteling_tblGgemeente4NOnvarchar
albertodatamart_besteling_tblGProvincie5NOnvarchar
albertodatamart_besteling_tblGregio6YESnvarchar
albertodatamart_besteling_tblDKalenderDatum7NOdate
albertodatamart_besteling_tblDWeekdag8YESnvarchar
albertodatamart_besteling_tblDWeeknummer9NOnvarchar
albertodatamart_besteling_tblDMaand10NOnvarchar
albertodatamart_besteling_tblDJaar11NOnvarchar
albertodatamart_besteling_tblVnaam12NOvarchar
albertodatamart_besteling_tblVPlaats13YESvarchar
albertodatamart_besteling_tblVRegio14YESvarchar
albertodatamart_besteling_tblPCategorie15NOnvarchar
albertodatamart_besteling_tblPGroep16NOnvarchar
albertodatamart_besteling_tblBestel_aantal17YESint
albertodatamart_besteling_tblBestel_bedrag18YESdecimal
albertoDataMart_BestellingBestelling_id1NOint
albertoDataMart_BestellingGeografiepostcode2NOnvarchar
albertoDataMart_BestellingGeografieBuurt3YESnvarchar
albertoDataMart_BestellingGeografieWijk4NOnvarchar
albertoDataMart_BestellingGeografieGemeente5NOnvarchar
albertoDataMart_BestellingGeografieProvincie6NOnvarchar
albertoDataMart_BestellingGeografieRegio7YESnvarchar
albertoDataMart_BestellingDatumKalenderDatum8NOdate
albertoDataMart_BestellingDatumWeekdag9YESnvarchar
albertoDataMart_BestellingDatumWeeknummer10NOnvarchar
albertoDataMart_BestellingDatumMaand11NOnvarchar
albertoDataMart_BestellingDatumJaar12NOnvarchar
albertoDataMart_BestellingVestigingNaam13NOvarchar
albertoDataMart_BestellingVestigingPlaats14YESvarchar
albertoDataMart_BestellingVestigingRegio15YESvarchar
albertoDataMart_BestellingProductCategorie16NOnvarchar
albertoDataMart_BestellingProductGroep17NOnvarchar
albertoDataMart_BestellingBestel_aantal18YESint
albertoDataMart_BestellingBestel_bedrag19YESdecimal
albertoDatamart_BezorgingBestelling_id1NOint
albertoDatamart_BezorgingBestel_datum2YESdatetime
albertoDatamart_BezorgingBestel_aantal3YESint
albertoDatamart_BezorgingBestel_bedrag4YESdecimal
albertoDatamart_BezorgingBestellingPostcode5YESnvarchar
albertoDatamart_BezorgingProduct_categorie6YESvarchar
albertoDatamart_BezorgingBezorging_id7NOint
albertoDatamart_BezorgingAfstand8YESint
albertoDatamart_BezorgingOppik_datum9YESdatetime
albertoDatamart_BezorgingAflever_datum10YESdatetime
albertoDatamart_Bezorgingbezorg_minuten11YESint
albertoDatamart_BezorgingTijd_per_km12YESint
albertoDatamart_BezorgingDatumWeekdag13YESnvarchar
albertoDatamart_BezorgingDatumMaand14YESnvarchar
albertoDatamart_BezorgingDatumJaar15YESnvarchar
albertoDatamart_Bezorgingbezorgernaam16NOvarchar
albertoDatamart_Bezorgingbezorgervervoermiddel17YESvarchar
albertoDatamart_Bezorgingvestigingnaam18NOvarchar
albertoDatamart_Bezorgingvestingpostcode19YESvarchar
albertoDatamart_BezorgingVestigingPlaats20YESvarchar
albertoDatamart_BezorgingVestigingRegio21YESvarchar
albertodatamart_bezorging_tblBestelling_id1NOint
albertodatamart_bezorging_tblBestel_datum2YESdatetime
albertodatamart_bezorging_tblBestel_aantal3YESint
albertodatamart_bezorging_tblBestel_bedrag4YESdecimal
albertodatamart_bezorging_tblBestellingPostcode5YESnvarchar
albertodatamart_bezorging_tblProduct_categorie6YESvarchar
albertodatamart_bezorging_tblBezorging_id7NOint
albertodatamart_bezorging_tblAfstand8YESint
albertodatamart_bezorging_tblOppik_datum9YESdatetime
albertodatamart_bezorging_tblAflever_datum10YESdatetime
albertodatamart_bezorging_tblbezorg_minuten11YESint
albertodatamart_bezorging_tblTijd_per_km12YESint
albertodatamart_bezorging_tblVestiging_bezorger_id13NOint
albertodatamart_bezorging_tblBegin_datum14NOdate
albertodatamart_bezorging_tblEind_datum15YESdate
albertodatamart_bezorging_tblBezorger_id16NOint
albertodatamart_bezorging_tblbezorgernaam17NOvarchar
albertodatamart_bezorging_tblVervoermiddel18YESvarchar
albertodatamart_bezorging_tblVestiging_id19NOint
albertodatamart_bezorging_tblvestigingnaam20NOvarchar
albertodatamart_bezorging_tblvestingpostcode21YESvarchar
albertodatamart_bezorging_tblPlaats22YESvarchar
albertodatamart_bezorging_tblRegio23YESvarchar
albertoDatamart_Bezorging2Bestelling_id1NOint
albertoDatamart_Bezorging2Bestel_datum2YESdatetime
albertoDatamart_Bezorging2Bestel_aantal3YESint
albertoDatamart_Bezorging2Bestel_bedrag4YESdecimal
albertoDatamart_Bezorging2BestellingPostcode5YESnvarchar
albertoDatamart_Bezorging2Product_categorie6YESvarchar
albertoDatamart_Bezorging2Afstand7YESint
albertoDatamart_Bezorging2Oppik_datum8YESdatetime
albertoDatamart_Bezorging2Aflever_datum9YESdatetime
albertoDatamart_Bezorging2bezorg_minuten10YESint
albertoDatamart_Bezorging2Tijd_per_km11YESint
albertoDatamart_Bezorging2DatumWeekdag12YESnvarchar
albertoDatamart_Bezorging2DatumMaand13YESnvarchar
albertoDatamart_Bezorging2DatumJaar14YESnvarchar
albertoDatamart_Bezorging2bezorgernaam15NOvarchar
albertoDatamart_Bezorging2bezorgervervoermiddel16YESvarchar
albertoDatamart_Bezorging2vestigingnaam17NOvarchar
albertoDatamart_Bezorging2vestiginglaats18YESvarchar
albertoDatamart_Bezorging2vestigingregio19YESvarchar
albertoDatamart_Bezorging2geografiebuurt20YESnvarchar
albertoDatamart_Bezorging2geografiegemeente21NOnvarchar
albertoDatamart_Bezorging2geografieprovincie22NOnvarchar
albertoDatamart_Bezorging2geografieregio23YESnvarchar
albertoDimDatumDatum_id1NOint
albertoDimDatumKalenderDatum2NOdate
albertoDimDatumWeekdag3YESnvarchar
albertoDimDatumWeekNummer4NOnvarchar
albertoDimDatumMaand5NOnvarchar
albertoDimDatumJaar6NOnvarchar
albertoDimGeografiePostcode1NOnvarchar
albertoDimGeografieBuurt2YESnvarchar
albertoDimGeografieWijk3NOnvarchar
albertoDimGeografieGemeente4NOnvarchar
albertoDimGeografieProvincie5NOnvarchar
albertoDimGeografieRegio6YESnvarchar
albertoDimKlimaatKlimaat_id1NOdecimal
albertoDimKlimaatDatum_id2NOint
albertoDimKlimaatStationcode3NOvarchar
albertoDimKlimaatTemperatuur4YESint
albertoDimKlimaatNeerslag5YESint
albertoDimKlimaatWindsnelheid6YESint
albertoDimKlimaatWindrichting7YESint
albertoDimProductCategorieProductCategorie_id1NOint
albertoDimProductCategorieProductCategorie2NOnvarchar
albertoDimProductCategorieProductGroep3NOnvarchar
albertoDimVestigingvestiging_id1NOint
albertoDimVestigingnaam2NOvarchar
albertoDimVestigingplaats3YESvarchar
albertoDimVestigingregio4YESvarchar
albertoDouweBestelling_id1NOint
albertoDouweBestel_datum2YESdatetime
albertoDouweBestel_aantal3YESint
albertoDouweBestel_bedrag4YESdecimal
albertoDouwePostcode5YESvarchar
albertoDouweProduct_categorie6YESvarchar
albertoDouweZBestelling_id1NOint
albertoDouweZBestel_datum2YESdatetime
albertoDouweZBestel_aantal3YESint
albertoDouweZBestel_bedrag4YESdecimal
albertoDouweZPostcode5YESvarchar
albertoDouweZProduct_categorie6YESvarchar
albertoEBIStatementStatement_id1NOint
albertoEBIStatementParagraph2NOvarchar
albertoEBIStatementName3NOnvarchar
albertoEBIStatementStatement_Type4NOvarchar
albertoEBIStatementCourse_code5NOvarchar
albertoEBIStatementStatement_cat6NOvarchar
albertoEBIStatementSQL7YESvarchar
albertoEBIStatementDescription8YESvarchar
albertoEBIStatementHelp_URL9YESvarchar
albertoFactBestellingBestelling_id1NOint
albertoFactBestellingBestel_datum_id2YESint
albertoFactBestellingBestel_aantal3YESint
albertoFactBestellingBestel_bedrag4YESdecimal
albertoFactBestellingPostcode5YESnvarchar
albertoFactBestellingProductCategorie_id6YESint
albertoFactBestellingKlimaat_id7YESdecimal
albertoFactBestellingvestiging_id8YESint
albertofriendOfgraph_id_F18AC6863C6F43DDA22F6C4191F150771NObigint
albertofriendOf$edge_id_390674E0333D49209318216B7E7F79B12NOnvarchar
albertofriendOffrom_obj_id_21D1853559E84C95B71B11FBF82E46913NOint
albertofriendOffrom_id_E75872052181455FB6AB179C1AD0CB744NObigint
albertofriendOf$from_id_2C5D8324A47243FCB3EBBF7231BC531C5YESnvarchar
albertofriendOfto_obj_id_C42B7F0B585E436E87863B3ADA1C8B6E6NOint
albertofriendOfto_id_2F7A67CB8B154338996E2CB1F3A91AF77NObigint
albertofriendOf$to_id_BD4A5626CA8341BFA70755C12CFF02298YESnvarchar
albertolikesgraph_id_11662AFD41EA490A918C30222ADC0AE71NObigint
albertolikes$edge_id_D1DBF71B37F5493C86B0CF4FE326347B2NOnvarchar
albertolikesfrom_obj_id_7D23FBFD68484EA09748557168BCCFC13NOint
albertolikesfrom_id_B10F88BC59E444C4B61746CDA0116B1F4NObigint
albertolikes$from_id_9C8D1D1CC1EA4E6B9A5D9B7265B80BAC5YESnvarchar
albertolikesto_obj_id_54CEBC9970194A7CBC6CBCA0BB5C268A6NOint
albertolikesto_id_BCEA3F3C31A94FAFBEAFDF1133A574CB7NObigint
albertolikes$to_id_3929C4B1D7594D6CB8BA9F3440CC6F578YESnvarchar
albertolikesrating9YESint
albertolivesIngraph_id_E6A0DFD2A18D44289BE72F4CBAD4099D1NObigint
albertolivesIn$edge_id_6BB0F927ED664755A650F3E82528B0A42NOnvarchar
albertolivesInfrom_obj_id_C205DE383021444AAF48EF7E8B540F2E3NOint
albertolivesInfrom_id_C75B1151A00C4C52AE868D14AE60D0274NObigint
albertolivesIn$from_id_EB32BB7F8B534F1AB7C730509FBCD6165YESnvarchar
albertolivesInto_obj_id_ED4222AA3A894810BA86BFAF131586086NOint
albertolivesInto_id_D96A9C0971404392A24E69D6C0C247027NObigint
albertolivesIn$to_id_956061890BB0404FB346A307E58574FA8YESnvarchar
albertolocatedIngraph_id_D9962E5E904447EC8C884A78D80C440F1NObigint
albertolocatedIn$edge_id_A31BA50264754FFBB2D363C8F0F4E83A2NOnvarchar
albertolocatedInfrom_obj_id_9EDF65EDE45240969E286D7685C789863NOint
albertolocatedInfrom_id_0C079FCAC6C34D1BA55D49992F75764B4NObigint
albertolocatedIn$from_id_223A799520644A8AA26B72A0DBBA20075YESnvarchar
albertolocatedInto_obj_id_FC9F64A3D1FC4E4F9EAAB4A0693160016NOint
albertolocatedInto_id_AAB87A6D3F944A06B0CB9F75C039B8457NObigint
albertolocatedIn$to_id_366CFB12C24D4CA394C5BA4373668A418YESnvarchar
albertoPersongraph_id_6E22635B3D3C47E2A10D2D8A34D9C9251NObigint
albertoPerson$node_id_36D83712F15B4C3B8DA4B70641F0010C2NOnvarchar
albertoPersonID3NOint
albertoPersonname4YESvarchar
albertoPersoonpersoon_id1NOint
albertoPersoonvoornaam2NOvarchar
albertoPersoonachternaam3NOvarchar
albertoPersoonrelatie_type4NOvarchar
albertoProductVerkoopproductverkoop_id1NOint
albertoProductVerkoopproductcategorie2NOnvarchar
albertoProductVerkoopneerslag3YESint
albertoProductVerkooptemperatuur4YESint
albertoProductVerkoopwindsnelheid5YESint
albertoProductVerkoopverkoopdatum6YESdate
albertoProductVerkoopverkoopaantal7NOint
albertoProductVerkoopverkoopbedrag8YESdecimal
albertoRestaurantgraph_id_D2C3F60990B14A1D8A32244F111032FF1NObigint
albertoRestaurant$node_id_7240D8DB61B244EEB60E7591FD32C3B42NOnvarchar
albertoRestaurantID3NOint
albertoRestaurantname4YESvarchar
albertoRestaurantcity5YESvarchar
albertotemperatuurmetingenid1NOint
albertotemperatuurmetingendatum2NOdate
albertotemperatuurmetingentemperatuur3YESfloat
albertoVerkoopDashboardproductverkoop_id1NOint
albertoVerkoopDashboardproductcategorie2NOnvarchar
albertoVerkoopDashboardneerslag3YESint
albertoVerkoopDashboardtemperatuur4YESint
albertoVerkoopDashboardwindsnelheid5YESint
albertoVerkoopDashboardverkoopdatum6YESdate
albertoVerkoopDashboardverkoopaantal7NOint
albertoVerkoopDashboardverkoopbedrag8YESdecimal
albertoVerkoopDashboardweekdag9YESnvarchar
albertoVerkoopDashboardmaand10YESnvarchar
albertoVerkoopDashboarddatumid11YESint
albertoVerkoopPivotmaand1YESnvarchar
albertoVerkoopPivotweekdag2YESnvarchar
albertoVerkoopPivotverkoopdatum3YESdate
albertoVerkoopPivotIJs4YESdecimal
albertoVerkoopPivotIJstaart5YESdecimal
albertoVerkoopPivotKoffie6YESdecimal
albertoVerkoopPivotSoftijs7YESdecimal
albertoVestigingVestiging_id1NOint
albertoVestigingNaam2NOvarchar
albertoVestigingPostcode3YESvarchar
albertoVestigingPlaats4YESvarchar
albertoVestigingRegio5YESvarchar
albertoVestiging_BezorgerVestiging_bezorger_id1NOint
albertoVestiging_BezorgerVestiging_id2YESint
albertoVestiging_BezorgerBezorger_id3YESint
albertoVestiging_BezorgerBegin_datum4NOdate
albertoVestiging_BezorgerEind_datum5YESdate