All Downloads are FREE. Search and download functionalities are using the official Maven repository.

META-INF.sql.tables.sql Maven / Gradle / Ivy

create table CSDiagramEntry (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	CSDiagramEntryId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPDefinitionId LONG,
	CPInstanceId LONG,
	CProductId LONG,
	diagram BOOLEAN,
	quantity INTEGER,
	sequence VARCHAR(75) null,
	sku VARCHAR(75) null,
	primary key (CSDiagramEntryId, ctCollectionId)
);

create table CSDiagramPin (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	CSDiagramPinId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPDefinitionId LONG,
	positionX DOUBLE,
	positionY DOUBLE,
	sequence VARCHAR(75) null,
	primary key (CSDiagramPinId, ctCollectionId)
);

create table CSDiagramSetting (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	CSDiagramSettingId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPAttachmentFileEntryId LONG,
	CPDefinitionId LONG,
	color VARCHAR(75) null,
	radius DOUBLE,
	type_ VARCHAR(75) null,
	primary key (CSDiagramSettingId, ctCollectionId)
);




© 2015 - 2025 Weber Informatics LLC | Privacy Policy