Public
PROV-IDEA: SMOP3-ADDColumn

Copy to Clipboard
document
  prefix var <http://openprovenance.org/var#>
  prefix sch2p <http://uml2prov.unirioja.es/ns/sch2p#>
  prefix bitemp <http://openprovenance.org/bitemp#>
  prefix d2p <http://uml2prov.unirioja.es/ns/d2p#>
  prefix o2p <http://uml2prov.unirioja.es/ns/o2p#>
  
  specializationOf(var:newColumnValue, var:newColumn)
  entity(var:inputColumnDef, [sch2p:columnName='var:inColumnName', sch2p:typeName='var:inColumnType'])
  entity(var:previousColumn, [sch2p:columnName='var:pColumnName', prov:type='sch2p:column'])
  entity(var:sourceSchema, [sch2p:schemaName='var:sSchemaName', prov:type='sch2p:schema', bitemp:endValidTime='var:ssEndValidTime', bitemp:endTransTime='var:ssEndTransTime'])
  entity(var:targetTable, [sch2p:tableName='var:tTableName', bitemp:startValidTime='var:ttStartValidTime', prov:type='sch2p:table', bitemp:startTransTime='var:ttStartTransTime'])
  entity(var:inputConstOrFunc, [prov:value='var:inputConstOrFuncValue'])
  entity(var:newColumnValue, [d2p:rowID='var:rowId', bitemp:startValidTime='var:ncvStartValidTime', prov:type='d2p:value', d2p:columnValue='var:columnValue', bitemp:startTransTime='var:ncvStartTransTime'])
  entity(var:previousTable, [sch2p:tableName='var:pTableName', prov:type='sch2p:table'])
  entity(var:sourceTable, [sch2p:tableName='var:sTableName', prov:type='sch2p:table', bitemp:endValidTime='var:stEndValidTime', bitemp:endTransTime='var:stEndTransTime'])
  entity(var:newColumn, [sch2p:columnName='var:nColumnName', sch2p:typeName='var:nColumnType', bitemp:startValidTime='var:ncStartValidTime', prov:type='sch2p:column', bitemp:startTransTime='var:ncStartTransTime'])
  entity(var:previousPrimaryKey, [prov:type='sch2p:pk'])
  entity(var:targetSchema, [sch2p:schemaName='var:tSchemaName', bitemp:startValidTime='var:tsStartValidTime', prov:type='sch2p:schema', bitemp:startTime='var:tsStartTransTime'])
  used(var:smo, var:inputColumnDef, -)
  used(var:smo, var:sourceTable, -)
  used(var:smo, var:inputConstOrFunc, -)
  wasDerivedFrom(var:targetSchema, var:sourceSchema, -, -, -)
  wasDerivedFrom(var:newColumnValue, var:inputConstOrFunc, -, -, -)
  wasDerivedFrom(var:newColumn, var:inputColumnDef, -, -, -)
  wasDerivedFrom(var:targetTable, var:sourceTable, -, -, -)
  wasAssociatedWith(var:smo, var:user, -)
  activity(var:smo, -, -, [o2p:instruction='var:operationInstruction', o2p:executed='var:executed', prov:type='var:operatorName', bitemp:endTransTime='var:endTransTime', bitemp:startTransTime='var:startTransTime'])
  wasInvalidatedBy(var:sourceTable, var:smo, -)
  wasInvalidatedBy(var:sourceSchema, var:smo, -)
  wasGeneratedBy(var:targetTable, var:smo, -)
  wasGeneratedBy(var:targetSchema, var:smo, -)
  wasGeneratedBy(var:newColumnValue, var:smo, -)
  wasGeneratedBy(var:newColumn, var:smo, -)
  agent(var:user)
  hadMember(var:targetSchema, var:targetTable)
  hadMember(var:targetSchema, var:previousTable)
  hadMember(var:targetTable, var:newColumn)
  hadMember(var:targetTable, var:previousPrimaryKey)
  hadMember(var:targetTable, var:previousColumn)
endDocument
        
Download as

PROV-N JSON AdjMatrix
Turtle Trig XML

Export graphic

PDF PNG SVG

Validate Visualisations

Assertions #
specializationOf1
entity11
used3
wasDerivedFrom4
wasAssociatedWith1
activity1
wasInvalidatedBy2
wasGeneratedBy4
agent1
hadMember5