Skip to content

Instantly share code, notes, and snippets.

@Adron
Last active May 29, 2017 22:16
Show Gist options
  • Select an option

  • Save Adron/402a5e4b5e11554f72a663416ac6d92c to your computer and use it in GitHub Desktop.

Select an option

Save Adron/402a5e4b5e11554f72a663416ac6d92c to your computer and use it in GitHub Desktop.
Example data diluvium schema JSON. (Early example)
[
{
"schema": "relational",
"database": "postgresql",
"connection": [
{
"connectionData": "stringForConnectionEtc",
"username": "theUser",
"password": "thePassword",
"otherConnectionParam": "TheOtherValue"
}
],
"structure": [
{
"table": "Users",
"generate": "4234908",
"columns": [
{"name": "id", "type": "uuid"},
{"name": "firstname", "type": "firstname"},
{"name": "lastname", "type": "lastname"},
{"name": "email_address", "type": "email"}
]
},
{
"table": "Addresses",
"generate": "2323498",
"columns": [
{"name": "id", "type": "uuid"},
{"name": "userFkId", "type": "uuid", "keyParentTable": "Users", "keyParentColumn": "id"},
{"name": "street", "type": "address"},
{"name": "city", "type": "city"},
{"name": "state", "type": "state"},
{"name": "postalcode", "type": "zip"}
]
},
{
"table": "Transactions",
"generate": "1432434908",
"columns": [
{ "name": "id", "type": "uuid" },
{"name": "userFkId", "type": "uuid", "keyParentTable": "Users", "keyParentColumn": "id"},
{ "name": "transaction", "type": "money" },
{ "name": "stamp", "type": "date" }
]
}
]
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment