pmhrs.sql

  create table admins (
    id uuid not null,
    name text not null,
    email text not null,
    encrypted_password  text not null,
    reset_password_token text not null,
    reset_password_sent_at timestamp,
    remember_created_at timestamp,
    sign_in_count integer not null,
    current_sign_in_at timestamp,
    last_sign_in_at timestamp,
    current_sign_in_ip inet,
    last_sign_in_ip inet,
    confirmation_token text,
    confirmed_at timestamp,
    confirmation_sent_at timestamp,
    unconfirmed_email text,
    failed_attempts integer not null,
    unlock_token text,
    locked_at timestamp,
    created_at timestamp not null,
    updated_at timestamp not null
  );


  create table hospitals (
    id uuid,
    name text,
    location text,
    level text,
    address text,
    created_at timestamp not null,
    updated_at timestamp not null,
    ref text not null
  );


  create table med_tests (
    id uuid,
    record_id uuid,
    test text,
    result text,
    created_at timestamp not null,
    updated_at timestamp not null
  );

  create table medications (
    id uuid,
    record_id uuid,
    medication text,
    created_at timestamp not null,
    updated_at timestamp not null
  );

The SQL database schema for PMHRS.