/* Class Def. SQL */
CREATE TABLE "wClassDef" ( "objName" TEXT, "pName" TEXT, "dspName" TEXT, "absFlag" BOOLEAN, "relFlag" BOOLEAN, "LName" TEXT, "RName" TEXT );
CREATE UNIQUE INDEX "wClassDef_objName" ON "wClassDef" ("objName");
/* Attribute Def. SQL */
CREATE TABLE "wAttrDef" (
	"objName"	TEXT,
	"dataType"	TEXT,
	"defValue"	TEXT,
	"dspName"	TEXT,
	"IsRequired"	BOOLEAN
);
CREATE UNIQUE INDEX "wAttrDef_objName" ON "wAttrDef" ("objName");
/* Index Def. SQL */
CREATE TABLE "wIndexDef" ( "objName" TEXT, "idxType" TEXT);
CREATE UNIQUE INDEX "wIndexDef_objName" ON "wIndexDef" ("objName");
/* Class-Attr Info. SQL */
CREATE TABLE "wClassAttrDef" (
	"LName"	TEXT,
	"RName"	TEXT,
	"Order"	TEXT,
	"dspName"	TEXT
);
CREATE UNIQUE INDEX "wClassAttrDef_Unique" ON "wClassAttrDef" ("LName", "RName");
/* Class-Index Info. SQL */
CREATE TABLE "wClassIndexDef" (
	"LName"	TEXT,
	"RName"	TEXT,
	"Order"	TEXT,
	"dspName"	TEXT
);
CREATE UNIQUE INDEX "wClassIndexDef_Unique" ON "wClassIndexDef" ("LName", "RName");
/* Index-Attr Info. SQL */
CREATE TABLE "wIndexAttrDef" (
	"LName"	TEXT,
	"RName"	TEXT,
	"Order"	TEXT
);
CREATE UNIQUE INDEX "wIndexAttrDef_Unique" ON "wIndexAttrDef" ("LName", "RName");

/* BPMS Function Declare */
CREATE FUNCTION "wFloat2Text" (float8) RETURNS text AS ' SELECT text($1+0);
' LANGUAGE 'SQL';
CREATE FUNCTION "wInt2Text" (int8) RETURNS text AS ' SELECT text($1+0);
' LANGUAGE 'SQL';

CREATE TABLE "wRoot" (
	"Name"	TEXT,
	"OBID"	TEXT,
	"wClassName"	TEXT
);
CREATE UNIQUE INDEX "wRoot_OBID" ON "wRoot" ("OBID");

CREATE TABLE "wObject" (
	"CreateDate"	DATE	DEFAULT	'now',
	"CreateTime"	TIME	DEFAULT	'now',
	"CreatorID"	TEXT,
	"IsValid"	BOOLEAN	DEFAULT	't'
) INHERITS ("wRoot");
CREATE UNIQUE INDEX "wObject_OBID" ON "wObject" ("OBID");
CREATE INDEX "wObject_IsValid" ON "wObject" ("IsValid");

CREATE TABLE "wItem" (
	"LcStatus"	TEXT	DEFAULT	'Working'
) INHERITS ("wObject");
CREATE UNIQUE INDEX "wItem_OBID" ON "wItem" ("OBID");
CREATE INDEX "wItem_IsValid" ON "wItem" ("IsValid");
CREATE INDEX "wItem_IsSuspended" ON "wItem" ("IsSuspended");

CREATE TABLE "CustMst" (
	"OrdCode"	TEXT,
	"Kind"	TEXT,
	"CustTelNum"	TEXT,
	"CeoName"	TEXT,
	"ConnPerson"	TEXT,
	"BusinessNum"	TEXT,
	"ConnPersonTel"	TEXT,
	"CustAddress"	TEXT,
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "CustMst_OBID" ON "CustMst" ("OBID");
CREATE INDEX "CustMst_IsValid" ON "CustMst" ("IsValid");
CREATE INDEX "CustMst_IsSuspended" ON "CustMst" ("IsSuspended");

CREATE TABLE "DefectSaleItem" (
	"DefDate"	DATE,
	"OrdCode"	TEXT,
	"Qty"	FLOAT8,
	"GoodQty"	FLOAT8,
	"DefQty"	FLOAT8,
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "DefectSaleItem_OBID" ON "DefectSaleItem" ("OBID");
CREATE INDEX "DefectSaleItem_IsValid" ON "DefectSaleItem" ("IsValid");
CREATE INDEX "DefectSaleItem_IsSuspended" ON "DefectSaleItem" ("IsSuspended");

CREATE TABLE "DeliveryMst" (
	"DeliveryDate"	DATE,
	"OrdNum"	INT8	DEFAULT	'0',
	"Waerhouse"	TEXT,
	"Qty"	FLOAT8,
	"DeliveryMethod"	TEXT,
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "DeliveryMst_OBID" ON "DeliveryMst" ("OBID");
CREATE INDEX "DeliveryMst_IsValid" ON "DeliveryMst" ("IsValid");
CREATE INDEX "DeliveryMst_IsSuspended" ON "DeliveryMst" ("IsSuspended");

CREATE TABLE "EmpMst" (
	"OrdCode"	TEXT,
	"Position"	TEXT,
	"Role"	TEXT,
	"InDate"	DATE,
	"OutDate"	DATE,
	"Status"	TEXT,
	"EmpTelNum"	TEXT,
	"EmpAddress"	TEXT,
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "EmpMst_OBID" ON "EmpMst" ("OBID");
CREATE INDEX "EmpMst_IsValid" ON "EmpMst" ("IsValid");
CREATE INDEX "EmpMst_IsSuspended" ON "EmpMst" ("IsSuspended");

CREATE TABLE "GroupMst" (
	"OrdCode"	TEXT,
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "GroupMst_OBID" ON "GroupMst" ("OBID");
CREATE INDEX "GroupMst_IsValid" ON "GroupMst" ("IsValid");
CREATE INDEX "GroupMst_IsSuspended" ON "GroupMst" ("IsSuspended");

CREATE TABLE "LinkMst" (
	"OrdNum"	INT8	DEFAULT	'0',
	"SiteName"	TEXT,
	"URL"	TEXT,
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "LinkMst_OBID" ON "LinkMst" ("OBID");
CREATE INDEX "LinkMst_IsValid" ON "LinkMst" ("IsValid");
CREATE INDEX "LinkMst_IsSuspended" ON "LinkMst" ("IsSuspended");

CREATE TABLE "MachineMst" (
	"MachCode"	TEXT,
	"MachDate"	DATE,
	"CustName"	TEXT,
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "MachineMst_OBID" ON "MachineMst" ("OBID");
CREATE INDEX "MachineMst_IsValid" ON "MachineMst" ("IsValid");
CREATE INDEX "MachineMst_IsSuspended" ON "MachineMst" ("IsSuspended");

CREATE TABLE "MachMonitoring" (
	"MachCode"	TEXT,
	"Status"	TEXT,
	"StartDate"	DATE,
	"StartTime"	TIME,
	"EndDate"	DATE,
	"EndTime"	TIME
) INHERITS ("wItem");
CREATE UNIQUE INDEX "MachMonitoring_OBID" ON "MachMonitoring" ("OBID");
CREATE INDEX "MachMonitoring_IsValid" ON "MachMonitoring" ("IsValid");
CREATE INDEX "MachMonitoring_IsSuspended" ON "MachMonitoring" ("IsSuspended");

CREATE TABLE "MaterialData" (
	"OrdNum"	INT8	DEFAULT	'0',
	"OrdCode"	TEXT,
	"Standard"	TEXT,
	"Kind"	TEXT,
	"Status"	TEXT,
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "MaterialData_OBID" ON "MaterialData" ("OBID");
CREATE INDEX "MaterialData_IsValid" ON "MaterialData" ("IsValid");
CREATE INDEX "MaterialData_IsSuspended" ON "MaterialData" ("IsSuspended");

CREATE TABLE "MaterialMst" (
	"MatCode"	TEXT,
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "MaterialMst_OBID" ON "MaterialMst" ("OBID");
CREATE INDEX "MaterialMst_IsValid" ON "MaterialMst" ("IsValid");
CREATE INDEX "MaterialMst_IsSuspended" ON "MaterialMst" ("IsSuspended");

CREATE TABLE "NilmData" (
	"idx"	INT8,
	"DATE_ID"	TEXT,
	"ID"	TEXT,
	"CHA_PF"	TEXT,
	"CHA_VOLT"	TEXT,
	"CHA_CUR"	TEXT,
	"CHA_Var"	TEXT,
	"CHA_Va"	TEXT,
	"CHB_PF"	TEXT,
	"CHB_VOLT"	TEXT,
	"CHB_CUR"	TEXT,
	"CHB_Var"	TEXT,
	"CHB_Va"	TEXT,
	"MPU_AX"	TEXT,
	"MPU_AY"	TEXT,
	"MPU_AZ"	TEXT,
	"MPU_GX"	TEXT,
	"MPU_GY"	TEXT,
	"MPU_GZ"	TEXT,
	"UpdateTime"	TIMESTAMP
) INHERITS ("wItem");
CREATE UNIQUE INDEX "NilmData_OBID" ON "NilmData" ("OBID");
CREATE INDEX "NilmData_IsValid" ON "NilmData" ("IsValid");
CREATE INDEX "NilmData_IsSuspended" ON "NilmData" ("IsSuspended");

CREATE TABLE "NoticeMst" (
	"OrdDate"	DATE,
	"NoticeStart"	DATE,
	"NoticeStop"	DATE,
	"Anthor"	TEXT,
	"Content"	TEXT,
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "NoticeMst_OBID" ON "NoticeMst" ("OBID");
CREATE INDEX "NoticeMst_IsValid" ON "NoticeMst" ("IsValid");
CREATE INDEX "NoticeMst_IsSuspended" ON "NoticeMst" ("IsSuspended");

CREATE TABLE "OrderMst" (
	"OrdNum"	INT8	DEFAULT	'0',
	"OrdDate"	DATE,
	"CustName"	TEXT,
	"ConnPerson"	TEXT,
	"DeliveryDate"	DATE,
	"Waerhouse"	TEXT,
	"Qty"	FLOAT8,
	"Unitt"	TEXT,
	"UnitPrice"	FLOAT8,
	"Amount"	INT8	DEFAULT	'0',
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "OrderMst_OBID" ON "OrderMst" ("OBID");
CREATE INDEX "OrderMst_IsValid" ON "OrderMst" ("IsValid");
CREATE INDEX "OrderMst_IsSuspended" ON "OrderMst" ("IsSuspended");

CREATE TABLE "ProcessDetail" (
	"OrdNum"	INT8	DEFAULT	'0',
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "ProcessDetail_OBID" ON "ProcessDetail" ("OBID");
CREATE INDEX "ProcessDetail_IsValid" ON "ProcessDetail" ("IsValid");
CREATE INDEX "ProcessDetail_IsSuspended" ON "ProcessDetail" ("IsSuspended");

CREATE TABLE "ProdessMst" (
	"OrdNum"	INT8	DEFAULT	'0',
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "ProdessMst_OBID" ON "ProdessMst" ("OBID");
CREATE INDEX "ProdessMst_IsValid" ON "ProdessMst" ("IsValid");
CREATE INDEX "ProdessMst_IsSuspended" ON "ProdessMst" ("IsSuspended");

CREATE TABLE "ProductInspect" (
	"InspPerson"	TEXT,
	"InspDate"	DATE,
	"InspQty"	FLOAT8,
	"GoodQty"	FLOAT8,
	"DefQty"	FLOAT8,
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "ProductInspect_OBID" ON "ProductInspect" ("OBID");
CREATE INDEX "ProductInspect_IsValid" ON "ProductInspect" ("IsValid");
CREATE INDEX "ProductInspect_IsSuspended" ON "ProductInspect" ("IsSuspended");

CREATE TABLE "ProductMst" (
	"ProdCode"	TEXT,
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "ProductMst_OBID" ON "ProductMst" ("OBID");
CREATE INDEX "ProductMst_IsValid" ON "ProductMst" ("IsValid");
CREATE INDEX "ProductMst_IsSuspended" ON "ProductMst" ("IsSuspended");

CREATE TABLE "ProductPlan" (
	"OrdNum"	INT8	DEFAULT	'0',
	"OrdDate"	DATE,
	"OrdCode"	TEXT,
	"ConnPerson"	TEXT,
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "ProductPlan_OBID" ON "ProductPlan" ("OBID");
CREATE INDEX "ProductPlan_IsValid" ON "ProductPlan" ("IsValid");
CREATE INDEX "ProductPlan_IsSuspended" ON "ProductPlan" ("IsSuspended");

CREATE TABLE "PruchaseMst" (
	"OrdNum"	INT8	DEFAULT	'0',
	"OrdCode"	TEXT,
	"CustName"	TEXT,
	"OrdDate"	DATE,
	"DeliveryDate"	DATE,
	"Waerhouse"	TEXT,
	"ConnPerson"	TEXT,
	"Qty"	FLOAT8,
	"Unitt"	TEXT,
	"UnitPrice"	FLOAT8,
	"Amount"	INT8	DEFAULT	'0',
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "PruchaseMst_OBID" ON "PruchaseMst" ("OBID");
CREATE INDEX "PruchaseMst_IsValid" ON "PruchaseMst" ("IsValid");
CREATE INDEX "PruchaseMst_IsSuspended" ON "PruchaseMst" ("IsSuspended");

CREATE TABLE "SaleItemMst" (
	"OrdDate"	DATE,
	"OrdCode"	TEXT,
	"Qty"	FLOAT8,
	"GoodQty"	FLOAT8,
	"DefQty"	FLOAT8,
	"Unitt"	TEXT,
	"Descriptions"	TEXT,
	"ReQty"	FLOAT8,
	"DeliveryQty"	FLOAT8,
	"Status"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "SaleItemMst_OBID" ON "SaleItemMst" ("OBID");
CREATE INDEX "SaleItemMst_IsValid" ON "SaleItemMst" ("IsValid");
CREATE INDEX "SaleItemMst_IsSuspended" ON "SaleItemMst" ("IsSuspended");

CREATE TABLE "TeamMst" (
	"OrdNum"	INT8	DEFAULT	'0',
	"MainTask"	TEXT,
	"Descriptions"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "TeamMst_OBID" ON "TeamMst" ("OBID");
CREATE INDEX "TeamMst_IsValid" ON "TeamMst" ("IsValid");
CREATE INDEX "TeamMst_IsSuspended" ON "TeamMst" ("IsSuspended");

CREATE TABLE "TmpData" (
	"MachCode"	TEXT,
	"SetTmp"	TEXT,
	"NowTmp"	TEXT,
	"AlarmStatus"	TEXT,
	"Status"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "TmpData_OBID" ON "TmpData" ("OBID");
CREATE INDEX "TmpData_IsValid" ON "TmpData" ("IsValid");
CREATE INDEX "TmpData_IsSuspended" ON "TmpData" ("IsSuspended");

CREATE TABLE "TmpMonitoring" (
	"MachCode"	TEXT,
	"SetTmp"	TEXT,
	"NowTmp"	TEXT,
	"AlarmStatus"	TEXT,
	"Status"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "TmpMonitoring_OBID" ON "TmpMonitoring" ("OBID");
CREATE INDEX "TmpMonitoring_IsValid" ON "TmpMonitoring" ("IsValid");
CREATE INDEX "TmpMonitoring_IsSuspended" ON "TmpMonitoring" ("IsSuspended");

CREATE TABLE "WrokSchedule" (
	"OrdDate"	DATE,
	"MachName"	TEXT,
	"MachCode"	TEXT,
	"Qty"	FLOAT8,
	"Unitt"	TEXT,
	"Descriptions"	TEXT,
	"Status"	TEXT
) INHERITS ("wItem");
CREATE UNIQUE INDEX "WrokSchedule_OBID" ON "WrokSchedule" ("OBID");
CREATE INDEX "WrokSchedule_IsValid" ON "WrokSchedule" ("IsValid");
CREATE INDEX "WrokSchedule_IsSuspended" ON "WrokSchedule" ("IsSuspended");

CREATE TABLE "wRelation" (
	"Revision"	TEXT	DEFAULT	'A',
	"LOBID"	TEXT,
	"ROBID"	TEXT,
	"LClassName"	TEXT,
	"RClassName"	TEXT
) INHERITS ("wObject");
CREATE UNIQUE INDEX "wRelation_OBID" ON "wRelation" ("OBID");
CREATE INDEX "wRelation_IsValid" ON "wRelation" ("IsValid");
CREATE INDEX "wRelation_LOBID" ON "wRelation" ("LOBID");
CREATE INDEX "wRelation_ROBID" ON "wRelation" ("ROBID");
CREATE INDEX "wRelation_IsSuspended" ON "wRelation" ("IsSuspended");

CREATE TABLE "CustMstGroupR" (

) INHERITS ("wRelation");
CREATE UNIQUE INDEX "CustMstGroupR_OBID" ON "CustMstGroupR" ("OBID");
CREATE INDEX "CustMstGroupR_IsValid" ON "CustMstGroupR" ("IsValid");
CREATE INDEX "CustMstGroupR_LOBID" ON "CustMstGroupR" ("LOBID");
CREATE INDEX "CustMstGroupR_ROBID" ON "CustMstGroupR" ("ROBID");
CREATE INDEX "CustMstGroupR_IsSuspended" ON "CustMstGroupR" ("IsSuspended");

CREATE TABLE "EmpMstGroupR" (

) INHERITS ("wRelation");
CREATE UNIQUE INDEX "EmpMstGroupR_OBID" ON "EmpMstGroupR" ("OBID");
CREATE INDEX "EmpMstGroupR_IsValid" ON "EmpMstGroupR" ("IsValid");
CREATE INDEX "EmpMstGroupR_LOBID" ON "EmpMstGroupR" ("LOBID");
CREATE INDEX "EmpMstGroupR_ROBID" ON "EmpMstGroupR" ("ROBID");
CREATE INDEX "EmpMstGroupR_IsSuspended" ON "EmpMstGroupR" ("IsSuspended");

CREATE TABLE "GroupMstLinkR" (
	"OrdNum"	INT8	DEFAULT	'0'
) INHERITS ("wRelation");
CREATE UNIQUE INDEX "GroupMstLinkR_OBID" ON "GroupMstLinkR" ("OBID");
CREATE INDEX "GroupMstLinkR_IsValid" ON "GroupMstLinkR" ("IsValid");
CREATE INDEX "GroupMstLinkR_LOBID" ON "GroupMstLinkR" ("LOBID");
CREATE INDEX "GroupMstLinkR_ROBID" ON "GroupMstLinkR" ("ROBID");
CREATE INDEX "GroupMstLinkR_IsSuspended" ON "GroupMstLinkR" ("IsSuspended");

CREATE TABLE "MaterialDataR" (
	"OrdNum"	INT8	DEFAULT	'0'
) INHERITS ("wRelation");
CREATE UNIQUE INDEX "MaterialDataR_OBID" ON "MaterialDataR" ("OBID");
CREATE INDEX "MaterialDataR_IsValid" ON "MaterialDataR" ("IsValid");
CREATE INDEX "MaterialDataR_LOBID" ON "MaterialDataR" ("LOBID");
CREATE INDEX "MaterialDataR_ROBID" ON "MaterialDataR" ("ROBID");
CREATE INDEX "MaterialDataR_IsSuspended" ON "MaterialDataR" ("IsSuspended");

CREATE TABLE "ProcessDetailMatMstR" (
	"OrdNum"	INT8	DEFAULT	'0'
) INHERITS ("wRelation");
CREATE UNIQUE INDEX "ProcessDetailMatMstR_OBID" ON "ProcessDetailMatMstR" ("OBID");
CREATE INDEX "ProcessDetailMatMstR_IsValid" ON "ProcessDetailMatMstR" ("IsValid");
CREATE INDEX "ProcessDetailMatMstR_LOBID" ON "ProcessDetailMatMstR" ("LOBID");
CREATE INDEX "ProcessDetailMatMstR_ROBID" ON "ProcessDetailMatMstR" ("ROBID");
CREATE INDEX "ProcessDetailMatMstR_IsSuspended" ON "ProcessDetailMatMstR" ("IsSuspended");

CREATE TABLE "ProcessMstDetailR" (
	"RunningNum"	INT4
) INHERITS ("wRelation");
CREATE UNIQUE INDEX "ProcessMstDetailR_OBID" ON "ProcessMstDetailR" ("OBID");
CREATE INDEX "ProcessMstDetailR_IsValid" ON "ProcessMstDetailR" ("IsValid");
CREATE INDEX "ProcessMstDetailR_LOBID" ON "ProcessMstDetailR" ("LOBID");
CREATE INDEX "ProcessMstDetailR_ROBID" ON "ProcessMstDetailR" ("ROBID");
CREATE INDEX "ProcessMstDetailR_IsSuspended" ON "ProcessMstDetailR" ("IsSuspended");

CREATE TABLE "ProductInspectDefR" (

) INHERITS ("wRelation");
CREATE UNIQUE INDEX "ProductInspectDefR_OBID" ON "ProductInspectDefR" ("OBID");
CREATE INDEX "ProductInspectDefR_IsValid" ON "ProductInspectDefR" ("IsValid");
CREATE INDEX "ProductInspectDefR_LOBID" ON "ProductInspectDefR" ("LOBID");
CREATE INDEX "ProductInspectDefR_ROBID" ON "ProductInspectDefR" ("ROBID");
CREATE INDEX "ProductInspectDefR_IsSuspended" ON "ProductInspectDefR" ("IsSuspended");

CREATE TABLE "ProductMstMatMstR" (
	"OrdNum"	INT8	DEFAULT	'0',
	"Qty"	FLOAT8,
	"Unitt"	TEXT
) INHERITS ("wRelation");
CREATE UNIQUE INDEX "ProductMstMatMstR_OBID" ON "ProductMstMatMstR" ("OBID");
CREATE INDEX "ProductMstMatMstR_IsValid" ON "ProductMstMatMstR" ("IsValid");
CREATE INDEX "ProductMstMatMstR_LOBID" ON "ProductMstMatMstR" ("LOBID");
CREATE INDEX "ProductMstMatMstR_ROBID" ON "ProductMstMatMstR" ("ROBID");
CREATE INDEX "ProductMstMatMstR_IsSuspended" ON "ProductMstMatMstR" ("IsSuspended");

CREATE TABLE "ProductOrderMstR" (
	"OrdNum"	INT8	DEFAULT	'0'
) INHERITS ("wRelation");
CREATE UNIQUE INDEX "ProductOrderMstR_OBID" ON "ProductOrderMstR" ("OBID");
CREATE INDEX "ProductOrderMstR_IsValid" ON "ProductOrderMstR" ("IsValid");
CREATE INDEX "ProductOrderMstR_LOBID" ON "ProductOrderMstR" ("LOBID");
CREATE INDEX "ProductOrderMstR_ROBID" ON "ProductOrderMstR" ("ROBID");
CREATE INDEX "ProductOrderMstR_IsSuspended" ON "ProductOrderMstR" ("IsSuspended");

CREATE TABLE "ProductPlanInspR" (

) INHERITS ("wRelation");
CREATE UNIQUE INDEX "ProductPlanInspR_OBID" ON "ProductPlanInspR" ("OBID");
CREATE INDEX "ProductPlanInspR_IsValid" ON "ProductPlanInspR" ("IsValid");
CREATE INDEX "ProductPlanInspR_LOBID" ON "ProductPlanInspR" ("LOBID");
CREATE INDEX "ProductPlanInspR_ROBID" ON "ProductPlanInspR" ("ROBID");
CREATE INDEX "ProductPlanInspR_IsSuspended" ON "ProductPlanInspR" ("IsSuspended");

CREATE TABLE "ProductPlanSaleItemR" (

) INHERITS ("wRelation");
CREATE UNIQUE INDEX "ProductPlanSaleItemR_OBID" ON "ProductPlanSaleItemR" ("OBID");
CREATE INDEX "ProductPlanSaleItemR_IsValid" ON "ProductPlanSaleItemR" ("IsValid");
CREATE INDEX "ProductPlanSaleItemR_LOBID" ON "ProductPlanSaleItemR" ("LOBID");
CREATE INDEX "ProductPlanSaleItemR_ROBID" ON "ProductPlanSaleItemR" ("ROBID");
CREATE INDEX "ProductPlanSaleItemR_IsSuspended" ON "ProductPlanSaleItemR" ("IsSuspended");

CREATE TABLE "ProductPlanWorkSchR" (
	"OrdNum"	INT8	DEFAULT	'0',
	"StartDate"	DATE,
	"StartTime"	TIME,
	"EndDate"	DATE,
	"EndTime"	TIME,
	"Status"	TEXT,
	"Descriptions"	TEXT
) INHERITS ("wRelation");
CREATE UNIQUE INDEX "ProductPlanWorkSchR_OBID" ON "ProductPlanWorkSchR" ("OBID");
CREATE INDEX "ProductPlanWorkSchR_IsValid" ON "ProductPlanWorkSchR" ("IsValid");
CREATE INDEX "ProductPlanWorkSchR_LOBID" ON "ProductPlanWorkSchR" ("LOBID");
CREATE INDEX "ProductPlanWorkSchR_ROBID" ON "ProductPlanWorkSchR" ("ROBID");
CREATE INDEX "ProductPlanWorkSchR_IsSuspended" ON "ProductPlanWorkSchR" ("IsSuspended");

CREATE TABLE "PurchaseMstMaterialDataR" (
	"OrdNum"	INT8	DEFAULT	'0'
) INHERITS ("wRelation");
CREATE UNIQUE INDEX "PurchaseMstMaterialDataR_OBID" ON "PurchaseMstMaterialDataR" ("OBID");
CREATE INDEX "PurchaseMstMaterialDataR_IsValid" ON "PurchaseMstMaterialDataR" ("IsValid");
CREATE INDEX "PurchaseMstMaterialDataR_LOBID" ON "PurchaseMstMaterialDataR" ("LOBID");
CREATE INDEX "PurchaseMstMaterialDataR_ROBID" ON "PurchaseMstMaterialDataR" ("ROBID");
CREATE INDEX "PurchaseMstMaterialDataR_IsSuspended" ON "PurchaseMstMaterialDataR" ("IsSuspended");

CREATE TABLE "SaleItemMstDeliveryR" (
	"OrdNum"	INT8	DEFAULT	'0'
) INHERITS ("wRelation");
CREATE UNIQUE INDEX "SaleItemMstDeliveryR_OBID" ON "SaleItemMstDeliveryR" ("OBID");
CREATE INDEX "SaleItemMstDeliveryR_IsValid" ON "SaleItemMstDeliveryR" ("IsValid");
CREATE INDEX "SaleItemMstDeliveryR_LOBID" ON "SaleItemMstDeliveryR" ("LOBID");
CREATE INDEX "SaleItemMstDeliveryR_ROBID" ON "SaleItemMstDeliveryR" ("ROBID");
CREATE INDEX "SaleItemMstDeliveryR_IsSuspended" ON "SaleItemMstDeliveryR" ("IsSuspended");

CREATE TABLE "WorkScheduleMatDataR" (

) INHERITS ("wRelation");
CREATE UNIQUE INDEX "WorkScheduleMatDataR_OBID" ON "WorkScheduleMatDataR" ("OBID");
CREATE INDEX "WorkScheduleMatDataR_IsValid" ON "WorkScheduleMatDataR" ("IsValid");
CREATE INDEX "WorkScheduleMatDataR_LOBID" ON "WorkScheduleMatDataR" ("LOBID");
CREATE INDEX "WorkScheduleMatDataR_ROBID" ON "WorkScheduleMatDataR" ("ROBID");
CREATE INDEX "WorkScheduleMatDataR_IsSuspended" ON "WorkScheduleMatDataR" ("IsSuspended");

CREATE TABLE "wSession" (
	"UserID"	TEXT,
	"UserPWD"	TEXT,
	"ServerName"	TEXT,
	"ServerPort"	TEXT,
	"HostName"	TEXT,
	"CompanyName"	TEXT,
	"ClearDateTime"	TIMESTAMP
) INHERITS ("wObject");
CREATE UNIQUE INDEX "wSession_OBID" ON "wSession" ("OBID");
CREATE INDEX "wSession_IsValid" ON "wSession" ("IsValid");