Database Entity: Definition, Matchmaking, Features and you can Options 5000

Database Entity: Definition, Matchmaking, Features and you can Options

Database Entity: Definition, Matchmaking, Features and you can Options

Database organization is key element in all the relational database. CentriQS Configurator lets you do databases which have just one customized organization having particular providers means otherwise several personalized entities related to each almost every other to have conference state-of-the-art team criteria. It’s also possible to feature their custom databases organization having ready-made task government services.

What is actually Database Entity?

Database organization is an activity, person, place, equipment, object or anything on the which the investigation is caught and you will kept in the type of features, workflow and you can dining tables. When you find yourself workflow and you can dining tables is optional to own databases organization, services are required (due to the fact entity in the place of attributes is not an entity).

Entity Features

Organization property is a characteristic of the entity nevertheless often it is difficult to say whether or not databases items would be an entity otherwise a house. For this specific purpose, you need to ponder: “Is the product out of priple, ‘current email address try regarding direct focus having ‘email address database, but when you do a ‘buyers database, ‘customer could be the database organization, if you’re ‘current email address might be people possessions.

A number of organization qualities is depict databases entity relationship, we.elizabeth. connect that entity to a different organization. For example, entity ‘Occupations can have possessions ‘Visitors one refers to the entity ‘Customer so when you create another type of business you can miss along the range of customers and choose a customer to possess and that one work might be complete.

Entity Dining tables

Entity table is a kind of sandwich-organization inside the head organization (as organization table has its own qualities). Such as, entity ‘Purchase with eg qualities as the Buy ID, Purchase Time, etc. may have table ‘Products which possesses its own services instance Device Identity, Number, Rate, an such like.

Along with often it is going to be tough to choose if or not you will find an aspire to would entity dining table or create numerous attributes in order to the organization in itself. Such, for entity ‘Get in touch with you ought to get target pointers detailed with features ‘Highway, ‘City, ‘State, etcetera. In the event the each contact only has you to target, following these functions can end up in organization, when you find yourself in the event your get in touch with may have multiple address, these types of features is belong to organization table.

Organization Workflow

Entity workflow is a type of an organization lifecycle and that comprise out of says, changes and reason why organization transits in one state to some other. Eg, whenever pages replace the condition off organization ‘Task from ‘Beginning in order to ‘Signed they’re able to pick one of your readily available grounds: ‘Done otherwise ‘Terminated.

Including workflow could have procedures did because of the CentriQS immediately whenever changeover within states takes place. Including, in the event the condition off entity ‘Opportunity becomes changed off ‘Offered to ‘Closed, the computer will automatically go into most recent time and date on profession ‘Day Finalized.

Entity Configurations

Entity options try program attributes of the entity. Some of them should be place whenever the fresh entity is made and should not getting changed following the changes is actually the time, anyone else are going to be edited and changed when after.

Meta Name, Identity, and you will Display screen Name

Entity features about three labels: ‘Meta Term, ‘Title and you will ‘Display Label. The initial two (‘Meta Name and ‘Name) are used because of the system inside and when lay they can’t feel changed, just like the past you to (‘Display Name) are shown within the user interface and can become changed at any big date.

Password Prefix

Password prefix is utilized in the beginning of the entity possessions ‘Code (the amount that’s instantly provided to brand new each this new organization if it’s written and you will saved throughout the database). For example, standard organization ‘Task keeps password prefix ‘T so when you make the first task it’ll have password ‘T1.

Should your databases will get multiple entities one begin by this new same page, it is preferable to construct password prefix off 2-3-cuatro emails. Including, entity ‘Contact could have password prefix ‘CONT.


Breakdown career is utilized to incorporate an even more outlined definition of the fresh organization when your identity does not cam getting in itself. Such as, organization ‘Get in touch with may have the next malfunction “Contact information on the team subscribers and you may subcontractors”.


By default entity label try formatted to correspond towards the entity code, however once you add customized entity properties you could potentially changes name structure. Such as, organization ‘Contact possess term that can automatically join sphere ‘Code, ‘First name and you will ‘Last Term.


Symbols are provided having entity ‘Screen Title in numerous views. Short icons receive regarding the shed down entity directories, at the top of organization detail look at, etc. Highest icons receive on top of part of the see, regarding Check out diet plan, etc. Each other smaller than average large signs will be found throughout the bow.

Les commentaires