Home

JSON Structure for database

Library Table {
    _id: string;
    _rev?: string;
    libraryName: string;
    librarian: string;
    assistant: string;
    street: string;
    district: string;
    city: string;
    county: string;
    state: string; // default to WI
    zip: number;
    email: string;
    phoneNumber: string; // but display as (XXX)-XXX-XXXX
    extension: string;
    level: string;
    size: number;
    dateNextContact?: string; // todo - ??? or date
    notes?: Notes 1..*
    user._id: string;
    message: string
    dateCreated: string; // todo - ??? or date
    totalSales?: number;
    lastSale?: number;
    dateLastSale?: string; // todo - ??? or date
    dateUpdated: string; // todo - ??? or date
    assignedRep: user.first_name;
}

User Table {
    _id: string;
    _rev: string;
    firstName: string;
    lastName: string;
    password: string;
    email: string;
    dateCreated: string;
    dateUpdated: string;
    role: admin | user; (both are strings)
    events:[]
}

A role can be either:

1. admin: string;
2. user: string;

A note structure:

id: number;
message: string;
dateCreated: string;
author: string;

An event structure:

id: number;
name: string;
startDate: isoDate;
endDate?: isoDate;
libraryId: string;
hasContacted: boolean;
dateCreated: string;
dateUpdated: string;

Reference to the MasterDB: https://docs.google.com/spreadsheets/d/1dX9iQwnSj3fp_In-mPyLDKHry5mSe1DdSpvJNV3SvO8/edit#gid=811740251