@conserv/mnmx-io-db NPM | npm.io

0.1.375 • Published 10 months ago

Install

Weekly downloads

-

License

SEE LICENSE IN .....

Repository

Last release

10 months ago

Database scripts

This package contains all the scripts to start postgres, create the DB schema, load dummy dev data, and bulid Sequelize models. If you run them in order:

postgres-start.sh
postgres-create.sh
create-test-data.sh
build-models.sh

you will end up with a working dev DB populated with dummy data.

Executable scripts

postgres-start.sh - starts Postgres installed by Homebrew
postgres-create.sh - creates the DB structure inside the target schema
create-test-data.sh - loads the dev testing data set
build-models.sh - build the Sequelize models

SQL scripts

mnmx-console.sql - the console db schema
test-data.sql - the dev testing data set

v2 changes:

Adds UUIDs to columns. Here's some SQL to add a UUID column to a table:

ALTER TABLE customer ADD COLUMN uuid uuid DEFAULT uuid_generate_v1() NOT NULL;

TODO: Add phone numbers for SMS alerts to user table TODO: Create a table for triggered alerts to live in TODO: Create a structure for trigger responses. For example, SMS, email, web hook, create a task in a workflow, etc TODO: Create a structure for facility floorplans with pointers to images, description, name, etc.

pg pg-hstore sequelize

conserv-datasource

10 months ago

10 months ago

10 months ago

10 months ago

10 months ago

10 months ago

10 months ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

2 years ago

2 years ago

2 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

5 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago

6 years ago