This is a repository for all code related to Geo Trading Cards and Collectables. The major applications and/or components are listed below. Click on a section header below to view more spefic documentation.

The public website for Geo Trading Cards, including an old management section previously used to manage the Google Docs/Sheets that contain some of the inventory.

The database stores all inventory and related sets, insert sets, cards, singles, and so on in a fairly complex and normalized database. The database was originally built in MySQL and was rebuilt and enhanced in MSSQL. A script for creating the full database schema is included within the Git repository, along with some common scripts to help find and maintain inventory, and a history of changes made to the schema. Some scripts for both database technologies are included, but anything related to MySQL is out-of-date at this point.

A small PHP program that can be used to import existing inventory data into the database from "flat" text files. Currently only one format and layout is supported, based on spreadsheets I've been building for years to track my inventory. The format and layout is very specific, and some updates may not be supported, but it will help with the process of importing existing inventory information into the database.

A Windows Forms application used to manage the inventory. This application is in its infancy and cannot do much just yet, but it will grow, and it will use the tSc API (below) to perform CRUD operations on the inventory data and will grow into a fully-fledged collection management tool.

A node.js API used to manage inventory data. This is also in its infancy, but will become the backbone of both the website and the WinAdminUI.