db_init: Initialise database

In PFA-WebApp/DB: Provide an interface to the database backend.

Description

Initialise SQLite database if not present.

Usage

db_init(path = "db/db.sqlite")

Arguments

path	Location at which database is created.

Tables

The database contains the following tables:

• User Table

  • Column	Type
    name	character
    status	character
    password	character

• Type Table

  • Column	Type
    type_id	integer
    type_name	character

• Subtype Table

  • Column	Type
    subtype_id	integer
    type_id	integer
    subtype_name	character
    quantity	integer

• Group Table

  • Column	Type
    group_id	integer
    group_name	character

• Group Type Table

  • Column	Type
    group_id	integer
    type_id	integer

• Circulation Table

  • Column	Type
    name	character
    type_id	integer
    subtype_id	integer
    quantity	integer
    time	character

PFA-WebApp/DB documentation built on Dec. 31, 2020, 3:25 p.m.