GroverDB uses standard database architecture to develop your database; however, GroverDB is no-code meaning you simply select options - no programming skills required. There are a few concepts and terms, though, that will help you understand how your database is organized.
- Objects: Every noun - a person, place, or thing - can be represented as an object. Customers, products, machines, events are all considered Objects.
- Types: Each Object can be organized under a Type - employees and customers could be placed under a People Type. Types define what data fields (Attributes) and other defining information every Object under that Type will have. Every Object must belong to a Type.
For example, a People Type may be set up to include contact information. Every Object under the People Type will have contact information fields available for input. Types can be thought of as a cooking recipe - they can define how to make a certain kind of food, say a cookie. With one recipe (Type) you can create many different cookies (Objects) but they all share basic attributes that make it a cookie and not another kind of food.
Types may also have Sub-Types. The People Type may have Staff, Customers, and Investors as Sub-Types. Any Attribute that applies to the Type will also apply to all Sub-Types.
- Attributes: Any defining feature that describes an Object is an Attribute. If an Object is a noun, then an Attribute is an adjective. Items such as birthday, product color, or even the product name is considered an Attribute of that Object.
- Status: Every Type can also be defined by a Status. Statuses can be thought of as stages in a process. An employee may be a new hire, in training, full-time, or terminated. Every Object will have a Status. For Objects that don’t logically follow a process, their Status can be set to Active or In-Active.
- Multiple Types: An Object can belong to multiple Types. For example, a person may be under a Board Member Type, a Customer Type and a Founder Type. This would mean the Object would inherit the Statuses and any other features defined by all Types. For example, a pet dog may want to be defined under both the Pet Type and the Canine Type.
- Connections: Objects can be connected to other Objects based on how they’re connected in real life - a product is connected to the customer who ordered it; an employee is connected to an event they attended. Connections are made and viewed using the Connection Viewer.