Loading...
Loading...
This example channel depends on a database to store resource information. It is setup to support PostgreSQL or SQL Server, though you can modify the code templates to support others. Once you create a schema (e.g. "fhirdb"), here are the other create statements you need:
CREATE SEQUENCE resource_sequence
INCREMENT 1
START 1;
CREATE TABLE resource
(
sequence_id bigint NOT NULL DEFAULT nextval('resource_sequence'::regclass),
name character varying(255) NOT NULL,
id character varying(255) NOT NULL,
version integer NOT NULL,
data xml,
mimetype character varying(255),
last_modified timestamp with time zone DEFAULT now(),
deleted boolean,
request_method character varying,
request_url character varying,
CONSTRAINT resource_pkey PRIMARY KEY (sequence_id),
CONSTRAINT resource_unq UNIQUE (name, id, version)
);CREATE TABLE resource_sequence
(
id BIGINT NOT NULL
);
INSERT INTO resource_sequence VALUES (1);
CREATE TABLE resource
(
sequence_id BIGINT NOT NULL,
name NVARCHAR(255) NOT NULL,
id NVARCHAR(255) NOT NULL,
version INTEGER NOT NULL,
data XML,
mimetype NVARCHAR(255),
last_modified DATETIMEOFFSET DEFAULT CURRENT_TIMESTAMP,
deleted BIT,
request_method NVARCHAR(MAX),
request_url NVARCHAR(MAX),
CONSTRAINT resource_pkey PRIMARY KEY (sequence_id),
CONSTRAINT resource_unq UNIQUE (name, id, version)
);