lib

Core libraries for Radroots
git clone https://radroots.dev/git/lib.git
Log | Files | Refs | README | LICENSE

0004_trade_product.up.sql (709B)

      1 CREATE TABLE IF NOT EXISTS trade_product (
      2     id CHAR(36) PRIMARY KEY NOT NULL UNIQUE CHECK(length(id) = 36),
      3     created_at DATETIME NOT NULL CHECK(length(created_at) = 24),
      4     updated_at DATETIME NOT NULL CHECK(length(updated_at) = 24),
      5     key TEXT NOT NULL,
      6     category TEXT NOT NULL,
      7     title TEXT NOT NULL,
      8     summary TEXT NOT NULL,
      9     process TEXT NOT NULL,
     10     lot TEXT NOT NULL,
     11     profile TEXT NOT NULL,
     12     year INTEGER NOT NULL,
     13     qty_amt INTEGER NOT NULL,
     14     qty_unit CHAR(4) NOT NULL,
     15     qty_label TEXT,
     16     qty_avail INTEGER,
     17     price_amt REAL NOT NULL,
     18     price_currency CHAR(3) NOT NULL,
     19     price_qty_amt INTEGER NOT NULL,
     20     price_qty_unit CHAR(4) NOT NULL,
     21     notes TEXT
     22 );