Paste number 58571: miker_: belated proposed schema

Paste number 58571: miker_: belated proposed schema
Pasted by: dbs
7 months, 4 weeks ago
#openils-evergreen | Context in IRC logs
Paste contents:
Raw Source | XML | Display As
-- Provides an i18n-able name for a lasso of org_units...
CREATE TABLE actor.lasso_org (
        id                SERIAL        PRIMARY KEY,
        name                TEXT        NOT NULL UNIQUE
);

-- Maps org_units to a named lasso...
CREATE TABLE actor.lasso_org_map (
        lasso_id        INT NOT NULL REFERENCES actor.lasso_org (id),
        org_unit        INT        NOT NULL REFERENCES actor.org_unit (id)
);

This paste has no annotations.

Colorize as:
Show Line Numbers

Lisppaste pastes can be made by anyone at any time. Imagine a fearsomely comprehensive disclaimer of liability. Now fear, comprehensively.