Database entity is key element in all relational database. CentriQS Configurator enables you to perform database that have one individualized entity to possess specific company requires otherwise several custom agencies connected with for every most other getting appointment complex business requirements. Also you can incorporate their custom database organization having in a position-produced task administration service.
What is Database Organization?
Databases entity is a thing, people, place, tool, object otherwise any item from the which the study are seized and you will kept in the type of functions, workflow and tables. When you find yourself workflow and you will tables is recommended to possess databases organization, features are essential (due to the fact organization instead attributes isn’t an organization).
Organization Qualities
Organization property is a characteristic of your own organization nonetheless sometimes it is hard to say if or not database product will likely be an entity or a home. For this purpose, you will want to ponder: “Is the items from priple, ‘email is actually regarding direct appeal to own ‘email address databases, but when you manage a beneficial ‘consumer database, ‘buyers is the database organization, when you find yourself ‘email is consumers possessions.
The entity functions can be portray database organization matchmaking, we.e. connect one to entity to a different organization. Such as for instance, organization ‘Jobs can have assets ‘Buyer one to refers to the entity ‘Consumer with the intention that once you would a separate work you could potentially shed on the selection of readers and pick an individual to have and this one work is over.
Organization Tables
Organization desk is a kind of sandwich-organization within the main entity (while the entity table has its own functions). Such as, entity ‘Buy with eg attributes since Acquisition ID, Buy Go out, an such like. have table ‘Products which has its own characteristics such as for instance Equipment Name, Quantity, Speed, etcetera.
As well as sometimes it is tough to decide whether there’s a need to carry out organization dining table or add multiple functions to help you the fresh new entity in itself. Such as for example, to possess entity ‘Get in touch with you need to need target advice that includes characteristics ‘Roadway, ‘Town, ‘County, etcetera. When the for every contact has only you to target, next such features can fall under entity, whenever you are in the event the contact might have multiple tackles, these types of features is fall into organization desk.
Entity Workflow
Entity workflow is a kind of an entity lifecycle and this consists regarding says, transitions and you can reasons why organization transits from 1 condition to a different. For example, when users change the condition away from entity ‘Task out of ‘In progress to ‘Signed they can select one of the offered factors: ‘Completed otherwise ‘Cancelled.
Also workflow possess methods performed of the CentriQS immediately when transition amongst the says happens. Like, in the event your condition of entity ‘Chance will get altered from ‘Open to ‘Signed, the computer often automatically go into newest date and time towards industry ‘Day Closed.
Entity Settings
Entity options is actually program options that come with the fresh new entity. Some of them will likely be lay whenever brand new organization is established and cannot become altered following transform are the time, others will likely be modified and you may changed when after.
Meta Label, Name, and you may Screen Label
Entity has about three labels: ‘Meta Term, ‘Label and you can ‘Screen Term. The original one or two (‘Meta Identity and you can ‘Name) are utilized of the program inside the house and when set they cannot end up being altered, since past one (‘Screen Name) is actually shown for the screen and can become changed at any time.
Password Prefix
Code prefix is employed at the start of the organization property ‘Code (the quantity that’s immediately made available to the brand new for every brand new organization in case it is composed and you will saved regarding the databases). Such as, default entity ‘Activity keeps password prefix ‘T as soon as you make the original activity it has code ‘T1.
In case your databases can get numerous entities you to start with the new exact same page, it is better to create code prefix out of dos-3-4 letters. Such as for example, entity ‘Contact possess password prefix ‘CONT.
Breakdown
Description industry is utilized to provide an even more in depth concept of brand new organization if for example the term does not chat to possess in itself. Like, entity ‘Contact could have the second breakdown “Contact information regarding organization readers and you can subcontractors”.
Title
Automagically organization label was formatted to correspond for the organization password, but not once you create individualized organization properties you might change title structure. Such as, organization ‘Get in touch with may have term that’ll automatically subscribe sphere ‘Code, ‘First-name and you can ‘History Title.
Icons
Icons are provided which have organization ‘Display Label in almost any views. Small signs are offered on the get rid of down organization listing, on top of organization outline check, etc. High icons receive at the top of part of the examine, throughout the Head to diet plan, etc. Both small and highest symbols should be revealed regarding the bow.
