Skip to content

Instantly share code, notes, and snippets.

@chrisbodhi
Created February 7, 2023 15:37
Show Gist options
  • Save chrisbodhi/72aa63931eae0b6f3e6a217b96e9ffb1 to your computer and use it in GitHub Desktop.
Save chrisbodhi/72aa63931eae0b6f3e6a217b96e9ffb1 to your computer and use it in GitHub Desktop.
catalog
@prefix : <http://pretend.co/cat/> .
@prefix dwec-database: <https://dwec.data.world/v0/database-types/> .
@prefix dct: <http://purl.org/dc/terms/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix dcat: <http://www.w3.org/ns/dcat#> .
@prefix foaf: <http://xmlns.com/foaf/0.1/> .
@prefix dwec: <https://dwec.data.world/v0/> .
@prefix csvw: <http://www.w3.org/ns/csvw#> .
@prefix dwec-jdbc: <https://dwec.data.world/v0/jdbc-types/> .
:col.derby_db_id.bazinga.namespace
a dwec:DatabaseColumn ;
dct:identifier "NAMESPACE" ;
dct:isPartOf :tbl.derby_db_id.bazinga ;
csvw:name "NAMESPACE" ;
dwec:columnIndex "1"^^xsd:int ;
dwec:columnSize "100"^^xsd:int ;
dwec:columnTypeName "VARCHAR" ;
dwec:jdbcType dwec-jdbc:VARCHAR .
:tsc.derby_db_id.fubar
a csvw:Schema ;
csvw:column ( :col.derby_db_id.fubar.fuid :col.derby_db_id.fubar.fudate :col.derby_db_id.fubar.funame ) ;
csvw:primaryKey "FUID" .
:col.derby_db_id.bazoom.local
a dwec:DatabaseColumn ;
dct:identifier "LOCAL" ;
dct:isPartOf :tbl.derby_db_id.bazoom ;
csvw:name "LOCAL" ;
dwec:columnIndex "3"^^xsd:int ;
dwec:columnSize "100"^^xsd:int ;
dwec:columnTypeName "VARCHAR" ;
dwec:jdbcType dwec-jdbc:VARCHAR .
:col.derby_db_id.bazoom.fuid
a dwec:DatabaseColumn ;
dct:identifier "FUID" ;
dct:isPartOf :tbl.derby_db_id.bazoom ;
csvw:name "FUID" ;
dwec:columnIndex "4"^^xsd:int ;
dwec:columnSize "10"^^xsd:int ;
dwec:columnTypeName "INTEGER" ;
dwec:jdbcType dwec-jdbc:INTEGER .
:tbl.derby_db_id.bazoom
a dwec:DatabaseTable ;
dct:identifier "BAZOOM" ;
dct:isPartOf :db.derby_db_id ;
dct:title "BAZOOM" ;
csvw:tableSchema :tsc.derby_db_id.bazoom .
:cat.derby_warehouse.rec.339f32c81a9cbce6f4e7e5bcf57113a7
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :tbl.derby_db_id.zoomfu .
:col.derby_db_id.zoomfu.id
a dwec:DatabaseColumn ;
dct:identifier "ID" ;
dct:isPartOf :tbl.derby_db_id.zoomfu ;
csvw:name "ID" ;
dwec:columnIndex "1"^^xsd:int ;
dwec:columnSize "10"^^xsd:int ;
dwec:columnTypeName "INTEGER" ;
dwec:jdbcType dwec-jdbc:INTEGER .
:cat.derby_warehouse.rec.8e124e865f3819b245400d2655bd3e3f
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :col.derby_db_id.barfu.barid .
:col.derby_db_id.fubar.fuid
a dwec:DatabaseColumn ;
dct:identifier "FUID" ;
dct:isPartOf :tbl.derby_db_id.fubar ;
csvw:name "FUID" ;
dwec:columnIndex "1"^^xsd:int ;
dwec:columnSize "10"^^xsd:int ;
dwec:columnTypeName "INTEGER" ;
dwec:jdbcType dwec-jdbc:INTEGER .
:tsc.derby_db_id.zoomfu
a csvw:Schema ;
csvw:column ( :col.derby_db_id.zoomfu.id :col.derby_db_id.zoomfu.funame ) .
:cat.derby_warehouse.rec.571fe5f9c263a13929f8aa977703e5d2
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :col.derby_db_id.bazinga.namespace .
:cat.derby_warehouse.rec.bf8b261fb939896c42d7960a20efb2eb
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :col.derby_db_id.zoomfu.id .
:col.derby_db_id.fubar.fudate
a dwec:DatabaseColumn ;
dct:identifier "FUDATE" ;
dct:isPartOf :tbl.derby_db_id.fubar ;
csvw:name "FUDATE" ;
dwec:columnIndex "2"^^xsd:int ;
dwec:columnSize "10"^^xsd:int ;
dwec:columnTypeName "DATE" ;
dwec:jdbcType dwec-jdbc:DATE .
:col.derby_db_id.bazoom.namespace
a dwec:DatabaseColumn ;
dct:identifier "NAMESPACE" ;
dct:isPartOf :tbl.derby_db_id.bazoom ;
csvw:name "NAMESPACE" ;
dwec:columnIndex "2"^^xsd:int ;
dwec:columnSize "100"^^xsd:int ;
dwec:columnTypeName "VARCHAR" ;
dwec:jdbcType dwec-jdbc:VARCHAR .
:tbl.derby_db_id.barfu
a dwec:DatabaseTable ;
dct:identifier "BARFU" ;
dct:isPartOf :db.derby_db_id ;
dct:title "BARFU" ;
csvw:tableSchema :tsc.derby_db_id.barfu .
:col.derby_db_id.fubar.funame
a dwec:DatabaseColumn ;
dct:identifier "FUNAME" ;
dct:isPartOf :tbl.derby_db_id.fubar ;
csvw:name "FUNAME" ;
dwec:columnIndex "3"^^xsd:int ;
dwec:columnSize "256"^^xsd:int ;
dwec:columnTypeName "VARCHAR" ;
dwec:jdbcType dwec-jdbc:VARCHAR .
:tsc.derby_db_id.bazinga
a csvw:Schema ;
csvw:column ( :col.derby_db_id.bazinga.namespace :col.derby_db_id.bazinga.local ) ;
csvw:primaryKey ( "NAMESPACE" "LOCAL" ) .
:col.derby_db_id.bazinga.local
a dwec:DatabaseColumn ;
dct:identifier "LOCAL" ;
dct:isPartOf :tbl.derby_db_id.bazinga ;
csvw:name "LOCAL" ;
dwec:columnIndex "2"^^xsd:int ;
dwec:columnSize "100"^^xsd:int ;
dwec:columnTypeName "VARCHAR" ;
dwec:jdbcType dwec-jdbc:VARCHAR .
:cat.derby_warehouse.rec.ca8fb6b47c0744ff118b6546efc3ad22
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :col.derby_db_id.barfu.fuid .
:col.derby_db_id.bazoom.id
a dwec:DatabaseColumn ;
dct:identifier "ID" ;
dct:isPartOf :tbl.derby_db_id.bazoom ;
csvw:name "ID" ;
dwec:columnIndex "1"^^xsd:int ;
dwec:columnSize "10"^^xsd:int ;
dwec:columnTypeName "INTEGER" ;
dwec:jdbcType dwec-jdbc:INTEGER .
:tsc.derby_db_id.bazoom
a csvw:Schema ;
csvw:column ( :col.derby_db_id.bazoom.id :col.derby_db_id.bazoom.namespace :col.derby_db_id.bazoom.local :col.derby_db_id.bazoom.fuid ) ;
csvw:foreignKey [ a csvw:ForeignKey ;
csvw:columnReference ( "NAMESPACE" "LOCAL" ) ;
csvw:reference [ a csvw:TableReference ;
csvw:columnReference ( "NAMESPACE" "LOCAL" ) ;
csvw:resource :tbl.derby_db_id.bazinga
]
] ;
csvw:foreignKey [ a csvw:ForeignKey ;
csvw:columnReference "FUID" ;
csvw:reference [ a csvw:TableReference ;
csvw:columnReference "FUID" ;
csvw:resource :tbl.derby_db_id.fubar
]
] ;
csvw:primaryKey "ID" .
:db.derby_db_id a dwec:Database ;
dct:identifier "derby_db_id" ;
dct:title "derby_db_id" ;
csvw:table :tbl.derby_db_id.zoomfu , :tbl.derby_db_id.bazinga , :tbl.derby_db_id.bazoom , :tbl.derby_db_id.fubar , :tbl.derby_db_id.barfu ;
dwec:databaseConnection [ a dwec:DatabaseConnectionInfo ;
dwec:databaseName "memory:demo" ;
dwec:databasePort "16661"^^xsd:int ;
dwec:databaseServer "localhost" ;
dwec:jdbcUrl <jdbc:x://localhost:16661/placeholder>
] ;
dwec:databaseType dwec-database:mysql .
:cat.derby_warehouse.rec.29d8d33bb740dd9fb2d034ff0bc86b01
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :tbl.derby_db_id.bazoom .
:cat.derby_warehouse.rec.441e9bbdd549cf403ada27846ba8d507
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :tbl.derby_db_id.bazinga .
:cat.derby_warehouse.rec.c9b8ef0a7428f68cc42d156c246874b0
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :db.derby_db_id .
:cat.derby_warehouse a dwec:Catalog ;
dct:identifier "derby_warehouse" ;
dct:issued "2009-04-21T00:00:00.000Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> ;
dct:modified "2011-03-11T00:00:00.000Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> ;
dcat:record :cat.derby_warehouse.rec.8e124e865f3819b245400d2655bd3e3f , :cat.derby_warehouse.rec.98d0fe319752b57a8a5e889e09623a76 , :cat.derby_warehouse.rec.bf8b261fb939896c42d7960a20efb2eb , :cat.derby_warehouse.rec.2d59ac3a934885dc80da4752c99acfa2 , :cat.derby_warehouse.rec.c9b8ef0a7428f68cc42d156c246874b0 , :cat.derby_warehouse.rec.549afcf31c6d49c84f904debdee549c6 , :cat.derby_warehouse.rec.26cddea3b564223e2efc9d46827cd677 , :cat.derby_warehouse.rec.ca8fb6b47c0744ff118b6546efc3ad22 , :cat.derby_warehouse.rec.9bffd5e1067649e9b4e5cc93efb61b45 , :cat.derby_warehouse.rec.3f222bd9fe0d14aa704c315f14dd529e , :cat.derby_warehouse.rec.441e9bbdd549cf403ada27846ba8d507 , :cat.derby_warehouse.rec.e783b281a706ffc5e5da50a368228263 , :cat.derby_warehouse.rec.571fe5f9c263a13929f8aa977703e5d2 , :cat.derby_warehouse.rec.339f32c81a9cbce6f4e7e5bcf57113a7 , :cat.derby_warehouse.rec.4c98026c182b21bbf4e7087e2f8b8ed3 , :cat.derby_warehouse.rec.29d8d33bb740dd9fb2d034ff0bc86b01 , :cat.derby_warehouse.rec.0841d438e747920ecb80611e3636186f , :cat.derby_warehouse.rec.14fd2db9451b97d33ce14ef5c33560eb , :cat.derby_warehouse.rec.a40cfd2d9353b5d4731cdb34e942507f .
:cat.derby_warehouse.rec.549afcf31c6d49c84f904debdee549c6
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :tbl.derby_db_id.fubar .
:cat.derby_warehouse.rec.98d0fe319752b57a8a5e889e09623a76
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :col.derby_db_id.fubar.fudate .
:cat.derby_warehouse.rec.2d59ac3a934885dc80da4752c99acfa2
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :col.derby_db_id.bazoom.fuid .
:tsc.derby_db_id.barfu
a csvw:Schema ;
csvw:column ( :col.derby_db_id.barfu.barid :col.derby_db_id.barfu.fuid ) ;
csvw:foreignKey [ a csvw:ForeignKey ;
csvw:columnReference "FUID" ;
csvw:reference [ a csvw:TableReference ;
csvw:columnReference "FUID" ;
csvw:resource :tbl.derby_db_id.fubar
]
] .
:cat.derby_warehouse.rec.3f222bd9fe0d14aa704c315f14dd529e
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :col.derby_db_id.fubar.fuid .
:cat.derby_warehouse.rec.0841d438e747920ecb80611e3636186f
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :tbl.derby_db_id.barfu .
:cat.derby_warehouse.rec.a40cfd2d9353b5d4731cdb34e942507f
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :col.derby_db_id.bazoom.local .
:cat.derby_warehouse.rec.9bffd5e1067649e9b4e5cc93efb61b45
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :col.derby_db_id.bazinga.local .
:col.derby_db_id.barfu.fuid
a dwec:DatabaseColumn ;
dct:identifier "FUID" ;
dct:isPartOf :tbl.derby_db_id.barfu ;
csvw:name "FUID" ;
dwec:columnIndex "2"^^xsd:int ;
dwec:columnSize "10"^^xsd:int ;
dwec:columnTypeName "INTEGER" ;
dwec:jdbcType dwec-jdbc:INTEGER .
:col.derby_db_id.barfu.barid
a dwec:DatabaseColumn ;
dct:identifier "BARID" ;
dct:isPartOf :tbl.derby_db_id.barfu ;
csvw:name "BARID" ;
dwec:columnIndex "1"^^xsd:int ;
dwec:columnSize "10"^^xsd:int ;
dwec:columnTypeName "INTEGER" ;
dwec:jdbcType dwec-jdbc:INTEGER .
:cat.derby_warehouse.sch.memory-demo.app
a dwec:DatabaseSchema ;
dct:identifier "APP" ;
dct:isPartOf :db.derby_db_id .
:cat.derby_warehouse.rec.4c98026c182b21bbf4e7087e2f8b8ed3
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :col.derby_db_id.zoomfu.funame .
:tbl.derby_db_id.fubar
a dwec:DatabaseTable ;
dct:identifier "FUBAR" ;
dct:isPartOf :db.derby_db_id ;
dct:title "FUBAR" ;
csvw:tableSchema :tsc.derby_db_id.fubar .
:cat.derby_warehouse.rec.e783b281a706ffc5e5da50a368228263
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :col.derby_db_id.bazoom.namespace .
:tbl.derby_db_id.zoomfu
a dwec:DatabaseView ;
dct:identifier "ZOOMFU" ;
dct:isPartOf :cat.derby_warehouse.sch.memory-demo.app ;
dct:title "ZOOMFU" ;
csvw:tableSchema :tsc.derby_db_id.zoomfu .
:cat.derby_warehouse.rec.14fd2db9451b97d33ce14ef5c33560eb
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :col.derby_db_id.fubar.funame .
:tbl.derby_db_id.bazinga
a dwec:DatabaseTable ;
dct:identifier "BAZINGA" ;
dct:isPartOf :db.derby_db_id ;
dct:title "BAZINGA" ;
csvw:tableSchema :tsc.derby_db_id.bazinga .
:cat.derby_warehouse.rec.26cddea3b564223e2efc9d46827cd677
a dcat:CatalogRecord ;
dct:issued "2009-04-21T00:00:00.000Z"^^xsd:dateTime ;
dct:modified "2011-03-11T00:00:00.000Z"^^xsd:dateTime ;
foaf:primaryTopic :col.derby_db_id.bazoom.id .
:col.derby_db_id.zoomfu.funame
a dwec:DatabaseColumn ;
dct:identifier "FUNAME" ;
dct:isPartOf :tbl.derby_db_id.zoomfu ;
csvw:name "FUNAME" ;
dwec:columnIndex "2"^^xsd:int ;
dwec:columnSize "256"^^xsd:int ;
dwec:columnTypeName "VARCHAR" ;
dwec:jdbcType dwec-jdbc:VARCHAR .
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment