the description for this gist

100%

the description for this gist

✓ Published0🌍 Public

Last edited Oct 14, 2015

Created on Oct 14, 2015

This gist provides a schema definition for a database table named `subscriptions_capturing_transaction`, detailing the columns, types, and constraints for storing subscription transaction data. The schema is written in the `.skema` format, a structured JSON-like syntax for defining database tables. It includes fields for transaction details such as amount, currency, card information, and status, as well as configuration options like increment, timestamp, and soft delete. The implementation appears to use a custom schema parser or generator that interprets the `skema` format to create the database structure.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist be32a2ac117700d3dbde6b0824367ba5

This example demonstrates how to create a simple database table visualization from a SQL schema definition. The code defines a `Demo` table with three columns—`ID`, `Key`, and `Value`—and shows how to map those column types and constraints into a visual entity-relationship style diagram. Using the provided `CREATE TABLE` statement as the data source, the visualization renders each column as a node, with the primary key and nullable attributes indicated through distinct visual encodings. The implementation leverages `d3.forceSimulation` for the node layout and `d3.geoPath` for any geometric rendering, while relying on standard DOM elements for interactivity. No additional behavior beyond the table’s structural representation is implied.

HHugoberry

53% match

Loading thumbnail…

testschema

This example visualizes the structure of a JSON Schema for a data catalogue, showing how metadata fields like table name, description, columns, and data format connect. The visualization is generated from a `testschema.json` file, which defines the schema’s properties and their types. It renders the schema’s hierarchy and relationships, using the JSON structure to map out the nested objects and enumerations. The code leverages standard JavaScript libraries to parse and display the schema, making the metadata’s organization immediately apparent through a graphical layout.

RRobinL

51% match

Loading thumbnail…

Gist db8c3f8fda7a4d6857a10214268a0047

This example demonstrates a JSON schema that defines the structure of a calendar event, specifying properties such as start and end dates, summary, location, and description. It shows the required fields and data formats needed to represent an event, likely for use in a scheduling or event-management interface. The schema itself is the core artifact, using standard JSON Schema draft 2020-12 conventions. No external visualization libraries are employed; the example focuses purely on the data contract. The rendering approach is not depicted, as the code provides only the schema definition.

MMoritzStefaner

50% match

Loading thumbnail…

Gist 860389

This example visualizes the schema of a phpBB posts database table, showing its columns, data types, and indexing structure. It uses a custom layout to represent each field as a node, with primary key and foreign key relationships highlighted through color and grouping. The visualization is rendered using D3.js, likely with `d3.forceSimulation` or a similar layout algorithm, and the underlying data is read directly from the SQL `CREATE TABLE` statement in the gist file. The code parses the schema definitions to generate the graph, mapping attributes like keys and full-text indexes visually.

TTBD

50% match

Loading thumbnail…

Gist afa06f80766db293173c0b14dbdd4ee1

This Gist defines a JSON schema for a fish observation dataset, detailing fields for operation IDs, station locations, sampling dates, and species abundance metrics. The schema enforces data quality through constraints like required surface area, coordinate ranges for the Lambert-93 projection, and enumerated sampling methods. It specifies types and validation rules for each attribute, including the species-specific count columns, supporting a structured analysis of ecological data from French water bodies.

TThomasG77

49% match

Loading thumbnail…

A schema for uploading MOT test data, as suggested in the user guide with the exception of the `SET storage_engine=MyISAM` which is there to allow the `ENABLE KEYS\DISABLE KEYS` mechanism used in the large table uploads. Also the field `RFRINSPMANDESC TEXT(500) #Variation from suggested schema due to 1074 error` is suggested as `char` in the user guide but for my MySQL setup this exceeds the allowed size for char.

This schema defines the relational structure for importing UK MOT test data, showing the primary tables for test results, test items, item details, item groups, and failure locations. It demonstrates the use of MySQL DDL with explicit primary keys, composite indexes, and the MyISAM storage engine to enable bulk-loading optimizations. The code highlights practical deviations from the official user guide, such as using `TEXT(500)` for inspection descriptions instead of an oversized `CHAR`, accommodating MySQL’s row-size limits while preserving data integrity.

IIanHopkinson

48% match

Loading thumbnail…

Tabel Kvanto

This example displays a summary table of transaction statistics, comparing accepted, declined, and refunded amounts and counts for today, yesterday, and the last month. The code fetches transaction data from a remote API, deduplicates entries by order ID, and aggregates the values into a tabular layout. Users can click on column headers to sort rows, with D3’s `select` and `csv` functions rendering the table and toggling ascending or descending sort order via CSS classes. The visualization uses D3 v6 and relies on a custom HTTP request to retrieve the JSON data.

Llarsboergo

48% match

Loading thumbnail…

Gist e9eac02df35654daa5d0

This example demonstrates a minimal data pipeline that reads JSON data and inserts it into a local SQLite database. The script, `jsonToSqlite.py`, loads a JSON file containing a list of objects, extracts the first object’s `"foo"` and `"bar"` fields, and writes those two values as a single row into a table named `table_name`. It uses the standard `json` module for parsing and `sqlite3` for database operations, creating a table and inserting the data with a parameterized `execute` call. The visualization shows only the code structure, not a graphical output, highlighting the simple ETL pattern of extracting, transforming, and loading data.

CCBasis

47% match