Hi,
A UUID field is automatically generated when this field is associated with another entity. In the database, this field is UUID. It’s hard to maintain on database side. Does CUBA support to generate a usual type field(string,integer,etc) instead of uniqueidentifier field?
For example, I have two entities, one is customer and another is order. Order is associate with customer. I hope the associate field is string(customer name) not uniqueidentifier. But CUBA always generate UUID for database DDL and insert sql statement.
Your replay is greatly appreciated.
create table CUBATEST_CUSTOMER (
ID uniqueidentifier,
VERSION integer not null,
CREATE_TS datetime2,
CREATED_BY varchar(50),
UPDATE_TS datetime2,
UPDATED_BY varchar(50),
DELETE_TS datetime2,
DELETED_BY varchar(50),
--
NAME varchar(100),
--
primary key nonclustered (ID)
)
create table CUBATEST_ORDER (
ID uniqueidentifier,
VERSION integer not null,
CREATE_TS datetime2,
CREATED_BY varchar(50),
UPDATE_TS datetime2,
UPDATED_BY varchar(50),
DELETE_TS datetime2,
DELETED_BY varchar(50),
--
CUSTOMER **_uniqueidentifier_**,
DATE_ datetime2,
--
primary key nonclustered (ID)
)