Database

Region:

Canada (Central)

License Model:

general-public-license

Database Instance Name:

overdose-prevention-inst

Database Name:

overdose_prevention_database

Backup Retention Period:

1 day

Port:

3306

Storage:

20 GiB

Tables:

CREATE TABLE Site (
  sid int PRIMARY KEY,
  name varchar(100) NOT NULL,
  phone_number varchar(11),
  hours varchar(1000),
  street varchar(100) NOT NULL,
  postal_code varchar(6) NOT NULL,
  cid int NOT NULL,
  province varchar(100) NOT NULL,
  country varchar(100) NOT NULL,
  service varchar(100) NOT NULL,
  lat varchar(20) NOT NULL,
  lon varchar(20) NOT NULL,
  description varchar(5000) NOT NULL,
  FOREIGN KEY (cid) REFERENCES City(cid)
);

Where service is one of 'Safe Injection', 'Replacement', 'Supervised Consumption', 'Detox', 'Nurse', 'Mobile Unit'

CREATE TABLE City (
  cid int PRIMARY KEY,
  city varchar(100),
  lat varchar(20) NOT NULL,
  lon varchar(20) NOT NULL
);