Page MenuHomeSealhub

Sealious PostgreSQL integration - add proper types in columns for wrapper fields
Open, NormalPublic1 Points

Description

We have couple of fields that are wrapper fileds meaning that they add some additional functionality to the original filed but they keep the original data type. This task about including that in PostgreSQL integration, so when we are creating a table with wrapper field we need to create a column with datatype of the field we are wrapping. Sometimes it may create additional coumns. Here is full list of that

Name					Description														Suggested Data Type
CachedValue				Remember a value and only recalculate it when some event occurs								TIMESTAMP, <original type>
ControlAccess				Controls who can display and/or edit the given field									<original type>
DerivedValue				Calculates a value based on other fields within the same item and stores it.						<original type>
DisallowUpdate				Allows to set the value once and then disallow any changes to it.							<original type>
Required				Wrapper that makes the wrapped field required.										<original type>
SettableBy				Wraps a field and makes it editable only to users matching a given Policy						<original type>
ValueExistingInCollection		Accepts as a value only values that exist as values of other field in other collection					<original type>
ValueNotExistingInCollection		Opposite to ValueExistingInCollection. Only not-yet-seen values are accepted						<original type> UNIQUE (single unique column)