R/db_describe_equipment.R
db_describe_equipment.RdAdd a piece of equipment to the equipment table
db_describe_equipment(db, equip_name, serial_no, model_name, vendor, owner_first, equipment_type = "Sensor", owner_last = NULL, owner_email = NULL, manufacturer = NULL, purchase_date = Sys.Date())
| db | database connection |
|---|---|
| equip_name | a unique short code name of the instrument |
| serial_no | serial number of equipment |
| model_name | model name of equipment |
| vendor | organization that sold the product |
| owner_first | first name of person who owns equipment |
| equipment_type | type of equipment from controlled vocabulary defaults to sensor |
| owner_last | last name of person who owns equipment, required if the person is not in the people table already |
| owner_email | email of person who owns equipment, required if the person is not in the people table arelady |
| manufacturer | company that makes the model of the equipment, required if the model is not in the equipmentmodels table |
| purchase_date | date that the equipment was purchased, defaults to current date |
TRUE if successful
Other describe functions: db_describe_annotation,
db_describe_method,
db_describe_organization,
db_describe_person,
db_describe_site,
db_describe_variable
# db <- create_sqlite() # OR # db <- connect_sqlite() # db_describe_equipment(db, "unit1", "001", "model1", # "vendor name", "Wendy", "Sensor", "Wetland", "ww email", "hobo")