Our 3D CAD supplier models have been moved to 3Dfindit.com, the new visual search engine for 3D CAD, CAE & BIM models.
You can log in there with your existing account of this site.
The content remains free of charge.
sql_connect SYSADM,SYSADM
sql_execute create table ERPTABLE (/ ERP_PDM_NUMBER varchar (50) not null,/ DESCRIPTION varchar (200),/ MAT_NAME varchar (100),/ primary key (ERP_PDM_NUMBER)) sql_execute create public synonym ERPTABLE for SYSADM.ERPTABLE sql_execute grant all on ERPTABLE to PUBLIC
erp_pdm_number: foreign key (ERPTABLE) |
all self added fields/columns become part of the ERPTABLE. |
For example: description, material, surface. |
sql_execute create table LINKTABLE (/ PRJ_PATH varchar (500) not null,/ LINE_ID integer not null,/ LINE_SUBID integer not null,/ VERSION varchar(5) not null,/ ACTIVE_STATE smallint default 0 not null,/ REQUESTED_STATE smallint default 0 not null,/ VARSET varchar (4000) ,/ VARIANT integer default 0,/ ERP_PDM_NUMBER varchar (50),/ foreign key ERP_FK (ERP_PDM_NUMBER) references ERPTABLE,/ primary key (PRJ_PATH,LINE_ID,LINE_SUBID,VERSION)) sql_execute create public synonym LINKTABLE for SYSADM.LINKTABLE sql_execute grant all on LINKTABLE to PUBLIC
LINKTABLE and ERPTABLE are connected via primary and foreign key. |