Andi Hubel saerdnaer
saerdnaer
/ chaos.pgsql
Last active
June 30, 2024 22:19
— forked from FelixHenninger/chaos.sql
Inventory database proposal
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- modified from SQLite to PostgreSQL, --Andi 2024-07-01 | |
| -- Common metadata ------------------------------------------------------------- | |
| -- Units | |
| CREATE TABLE units ( | |
| id INTEGER PRIMARY KEY NOT NULL, | |
| -- Metadata | |
| name VARCHAR NOT NULL UNIQUE, |