⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 compiere.sql

📁 Java写的ERP系统
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
COMMENT ON COLUMN AD_ReportView.AD_Table_ID IS 'AD_Table_ID Definition'
;
-- 
-- TABLE: AD_ReportView_Col 
--

CREATE TABLE AD_ReportView_Col(
	AD_ReportView_Col_ID	NUMBER(10, 0)	 NOT NULL,
	AD_Client_ID			NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID				NUMBER(10, 0)	 NOT NULL,
	IsActive				CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created					DATE			  DEFAULT SYSDATE NOT NULL,
	CreatedBy				NUMBER(10, 0)	 NOT NULL,
	Updated					DATE			  DEFAULT SYSDATE NOT NULL,
	UpdatedBy				NUMBER(10, 0)	 NOT NULL,
	AD_ReportView_ID		NUMBER(10, 0)	 NOT NULL,
	AD_Column_ID			NUMBER(10, 0),
	FunctionColumn			NVARCHAR2(60)	 NOT NULL,
	IsGroupFunction			CHAR(1)			  DEFAULT 'N' NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CHECK (IsGroupFunction in ('Y','N')),
	CONSTRAINT AD_ReportView_Col_Key PRIMARY KEY (AD_ReportView_Col_ID)
) 
;


-- 
-- TABLE: AD_Role_ClientAccess 
--

CREATE TABLE AD_Role_ClientAccess(
	AD_Role_ID		NUMBER(10, 0)	 NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	 NOT NULL,
	IsActive		CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created			DATE			  DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	 NOT NULL,
	Updated			DATE			  DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	 NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_Role_ClientAccess_Key PRIMARY KEY (AD_Role_ID, AD_Client_ID)
) 
;


COMMENT ON TABLE AD_Role_ClientAccess IS 'Base for ClientList'
;
-- 
-- TABLE: AD_Role_OrgAccess 
--

CREATE TABLE AD_Role_OrgAccess(
	AD_Role_ID		NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	 NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	 NOT NULL,
	IsActive		CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created			DATE			  DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	 NOT NULL,
	Updated			DATE			  DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	 NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_Role_OrgAccess_Key PRIMARY KEY (AD_Role_ID, AD_Org_ID)
) 
;


COMMENT ON TABLE AD_Role_OrgAccess IS 'Base For OrgList'
;
-- 
-- TABLE: AD_System 
--

CREATE TABLE AD_System(
	AD_System_ID	NUMBER(10, 0)	  NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	  NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	  NOT NULL,
	IsActive		CHAR(1)			   DEFAULT 'Y' NOT NULL,
	Created			DATE			   DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	  NOT NULL,
	Updated			DATE			   DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	  NOT NULL,
	Name			NVARCHAR2(60)	  NOT NULL,
	UserName		NVARCHAR2(60)	  NOT NULL,
	Info			NVARCHAR2(255)	  NOT NULL,
	Version			NVARCHAR2(20)	  NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_System_Key PRIMARY KEY (AD_System_ID)
	USING INDEX
TABLESPACE INDX
) 
;


COMMENT ON TABLE AD_System IS 'System Identification and status'
;
-- 
-- TABLE: AD_Task_Access 
--

CREATE TABLE AD_Task_Access(
	AD_Task_ID		NUMBER(10, 0)	 NOT NULL,
	AD_Role_ID		NUMBER(10, 0)	 NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	 NOT NULL,
	IsActive		CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created			DATE			  DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	 NOT NULL,
	Updated			DATE			  DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	 NOT NULL,
	IsReadWrite		CHAR(1)			  DEFAULT 'Y' NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CHECK (IsReadWrite in ('Y','N')),
	CONSTRAINT AD_Task_Access_Key PRIMARY KEY (AD_Task_ID, AD_Role_ID)
	USING INDEX
TABLESPACE INDX
) 
;


-- 
-- TABLE: AD_Trace 
--

CREATE TABLE AD_Trace(
	When	DATE			   NOT NULL,
	No		NUMBER				DEFAULT 0 NOT NULL,
	What	NVARCHAR2(2000)	   NOT NULL,
	CONSTRAINT AD_Trace_Key PRIMARY KEY (When, No)
	USING INDEX
TABLESPACE INDX
) 
;


-- 
-- TABLE: AD_Tree 
--

CREATE TABLE AD_Tree(
	AD_Tree_ID		NUMBER(10, 0)	  NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	  NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	  NOT NULL,
	Created			DATE			   DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	  NOT NULL,
	Updated			DATE			   DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	  NOT NULL,
	IsActive		CHAR(1)			   DEFAULT 'Y' NOT NULL,
	Name			NVARCHAR2(60)	  NOT NULL,
	Description		NVARCHAR2(255),
	TreeType		CHAR(2)			  NOT NULL,
	IsAllNodes		CHAR(1)			   DEFAULT 'Y' NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CHECK (IsAllNodes in ('Y','N')),
	CONSTRAINT AD_Tree_Key PRIMARY KEY (AD_Tree_ID)
	USING INDEX
TABLESPACE INDX
) 
;


-- 
-- TABLE: AD_TreeBar 
--

CREATE TABLE AD_TreeBar(
	AD_Tree_ID		NUMBER(10, 0)	 NOT NULL,
	AD_User_ID		NUMBER(10, 0)	 NOT NULL,
	Node_ID			NUMBER(10, 0)	 NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	 NOT NULL,
	IsActive		CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created			DATE			  DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	 NOT NULL,
	Updated			DATE			  DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	 NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_TreeBar_Key PRIMARY KEY (AD_Tree_ID, AD_User_ID, Node_ID)
) 
;


COMMENT ON TABLE AD_TreeBar IS 'User Shortcuts'
;
-- 
-- TABLE: AD_TreeNode 
--

CREATE TABLE AD_TreeNode(
	AD_Tree_ID		NUMBER(10, 0)	 NOT NULL,
	Node_ID			NUMBER(10, 0)	 NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	 NOT NULL,
	IsActive		CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created			DATE			  DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	 NOT NULL,
	Updated			DATE			  DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	 NOT NULL,
	Parent_ID		NUMBER(10, 0),
	SeqNo			NUMBER(10, 0),
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_TreeNode_Key PRIMARY KEY (AD_Tree_ID, Node_ID)
	USING INDEX
TABLESPACE INDX
) 
;


COMMENT ON TABLE AD_TreeNode IS 'Generic TreeNodes'
;
-- 
-- TABLE: AD_TreeNodeBP 
--

CREATE TABLE AD_TreeNodeBP(
	AD_Tree_ID		NUMBER(10, 0)	 NOT NULL,
	Node_ID			NUMBER(10, 0)	 NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	 NOT NULL,
	IsActive		CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created			DATE			  DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	 NOT NULL,
	Updated			DATE			  DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	 NOT NULL,
	Parent_ID		NUMBER(10, 0),
	SeqNo			NUMBER(10, 0),
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_TreeNodeBP_Key PRIMARY KEY (AD_Tree_ID, Node_ID)
) 
;


COMMENT ON TABLE AD_TreeNodeBP IS 'TreeNodes for Business Partners'
;
-- 
-- TABLE: AD_TreeNodeMM 
--

CREATE TABLE AD_TreeNodeMM(
	AD_Tree_ID		NUMBER(10, 0)	 NOT NULL,
	Node_ID			NUMBER(10, 0)	 NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	 NOT NULL,
	IsActive		CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created			DATE			  DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	 NOT NULL,
	Updated			DATE			  DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	 NOT NULL,
	Parent_ID		NUMBER(10, 0),
	SeqNo			NUMBER(10, 0),
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_TreeNodeMM_Key PRIMARY KEY (AD_Tree_ID, Node_ID)
) 
STORAGE(BUFFER_POOL KEEP
		)
CACHE
;


COMMENT ON TABLE AD_TreeNodeMM IS 'TreeNodes for Menues'
;
-- 
-- TABLE: AD_TreeNodePR 
--

CREATE TABLE AD_TreeNodePR(
	AD_Tree_ID		NUMBER(10, 0)	 NOT NULL,
	Node_ID			NUMBER(10, 0)	 NOT NULL,
	AD_Client_ID	NUMBER(10, 0)	 NOT NULL,
	AD_Org_ID		NUMBER(10, 0)	 NOT NULL,
	IsActive		CHAR(1)			  DEFAULT 'Y' NOT NULL,
	Created			DATE			  DEFAULT SYSDATE NOT NULL,
	CreatedBy		NUMBER(10, 0)	 NOT NULL,
	Updated			DATE			  DEFAULT SYSDATE NOT NULL,
	UpdatedBy		NUMBER(10, 0)	 NOT NULL,
	Parent_ID		NUMBER(10, 0),
	SeqNo			NUMBER(10, 0),
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_TreeNodePR_Key PRIMARY KEY (AD_Tree_ID, Node_ID)
) 
;


COMMENT ON TABLE AD_TreeNodePR IS 'TreeNodes for Products'
;
-- 
-- TABLE: AD_UserDef_Field 
--

CREATE TABLE AD_UserDef_Field(
	AD_UserDef_Field_ID	   NUMBER(10, 0)	  NOT NULL,
	AD_Client_ID		   NUMBER(10, 0)	  NOT NULL,
	AD_Org_ID			   NUMBER(10, 0)	  NOT NULL,
	IsActive			   CHAR(1)			   DEFAULT 'Y' NOT NULL,
	Created				   DATE				   DEFAULT SYSDATE NOT NULL,
	CreatedBy			   NUMBER(10, 0)	  NOT NULL,
	Updated				   DATE				   DEFAULT SYSDATE NOT NULL,
	UpdatedBy			   NUMBER(10, 0)	  NOT NULL,
	AD_UserDef_Tab_ID	   NUMBER(10, 0)	  NOT NULL,
	AD_Field_ID			   NUMBER(10, 0)	  NOT NULL,
	Name				   NVARCHAR2(60)	  NOT NULL,
	Description			   NVARCHAR2(255),
	Help				   NVARCHAR2(2000),
	IsDisplayed			   CHAR(1)			   DEFAULT 'Y' NOT NULL,
	DisplayLength		   NUMBER(10, 0),
	DisplayLogic		   NVARCHAR2(2000),
	IsReadOnly			   CHAR(1)			   DEFAULT 'N' NOT NULL,
	IsUpdateable		   CHAR(1)			   DEFAULT 'Y',
	SortNo				   NUMBER(10, 0),
	SeqNo				   NUMBER(10, 0)	  NOT NULL,
	IsSameLine			   CHAR(1)			   DEFAULT 'N' NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CHECK (IsDisplayed in ('Y','N')),
	CHECK (IsReadOnly in ('Y','N')),
	CHECK (IsUpdateable in ('Y','N')),
	CHECK (IsSameLine in ('Y','N')),
	CONSTRAINT AD_UserDef_Field_Key PRIMARY KEY (AD_UserDef_Field_ID)
) 
;


-- 
-- TABLE: AD_UserDef_Tab 
--

CREATE TABLE AD_UserDef_Tab(
	AD_UserDef_Tab_ID	 NUMBER(10, 0)		NOT NULL,
	AD_Client_ID		 NUMBER(10, 0)		NOT NULL,
	AD_Org_ID			 NUMBER(10, 0)		NOT NULL,
	IsActive			 CHAR(1)			 DEFAULT 'Y' NOT NULL,
	Created				 DATE				 DEFAULT SYSDATE NOT NULL,
	CreatedBy			 NUMBER(10, 0)		NOT NULL,
	Updated				 DATE				 DEFAULT SYSDATE NOT NULL,
	UpdatedBy			 NUMBER(10, 0)		NOT NULL,
	AD_UserDef_Win_ID	 NUMBER(10, 0)		NOT NULL,
	AD_Tab_ID			 NUMBER(10, 0)		NOT NULL,
	Name				 NVARCHAR2(60)		NOT NULL,
	Description			 NVARCHAR2(255),
	Help				 NVARCHAR2(2000),
	IsSingleRow			 CHAR(1)			 DEFAULT 'N' NOT NULL,
	IsReadOnly			 CHAR(1)			 DEFAULT 'N' NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CHECK (IsSingleRow in ('Y','N')),
	CHECK (IsReadOnly in ('Y','N')),
	CONSTRAINT AD_UserDef_Tab_Key PRIMARY KEY (AD_UserDef_Tab_ID)
) 
;


-- 
-- TABLE: AD_UserDef_Win 
--

CREATE TABLE AD_UserDef_Win(
	AD_UserDef_Win_ID	 NUMBER(10, 0)		NOT NULL,
	AD_Client_ID		 NUMBER(10, 0)		NOT NULL,
	AD_Org_ID			 NUMBER(10, 0)		NOT NULL,
	AD_User_ID			 NUMBER(10, 0),
	IsActive			 CHAR(1)			 DEFAULT 'Y' NOT NULL,
	Created				 DATE				 DEFAULT SYSDATE NOT NULL,
	CreatedBy			 NUMBER(10, 0)		NOT NULL,
	Updated				 DATE				 DEFAULT SYSDATE NOT NULL,
	UpdatedBy			 NUMBER(10, 0)		NOT NULL,
	AD_Window_ID		 NUMBER(10, 0)		NOT NULL,
	Name				 NVARCHAR2(60)		NOT NULL,
	Description			 NVARCHAR2(255),
	Help				 NVARCHAR2(2000),
	AD_Language			 VARCHAR2(6)		NOT NULL,
	IsDefault			 CHAR(1)			 DEFAULT 'N' NOT NULL,
	IsReadOnly			 CHAR(1)			 DEFAULT 'N' NOT NULL,
	IsUserUpdateable	 CHAR(1)			 DEFAULT 'Y' NOT NULL,
	CHECK (IsActive in ('Y','N')),
	CHECK (IsReadOnly in ('Y','N')),
	CHECK (IsUserUpdateable in ('Y','N')),
	CONSTRAINT AD_UserDef_Win_Key PRIMARY KEY (AD_UserDef_Win_ID)
) 
;


-- 
-- TABLE: AD_Workbench 
--

CREATE TABLE AD_Workbench(
	AD_Workbench_ID	   NUMBER(10, 0)	  NOT NULL,
	AD_Client_ID	   NUMBER(10, 0)	  NOT NULL,
	AD_Org_ID		   NUMBER(10, 0)	  NOT NULL,
	IsActive		   CHAR(1)			   DEFAULT 'Y' NOT NULL,
	Created			   DATE				   DEFAULT SYSDATE NOT NULL,
	CreatedBy		   NUMBER(10, 0)	  NOT NULL,
	Updated			   DATE				   DEFAULT SYSDATE NOT NULL,
	UpdatedBy		   NUMBER(10, 0)	  NOT NULL,
	Name			   NVARCHAR2(60)	  NOT NULL,
	Description		   NVARCHAR2(255),
	Help			   NVARCHAR2(2000),
	EntityType		   CHAR(1)			   DEFAULT 'D' NOT NULL,
	AD_Column_ID	   NUMBER(10, 0)	  NOT NULL,
	AD_Image_ID		   NUMBER(10, 0),
	AD_Color_ID		   NUMBER(10, 0),
	PA_Goal_ID		   NUMBER(10, 0),
	CHECK (IsActive in ('Y','N')),
	CONSTRAINT AD_Workbench_Key PRIMARY KEY (AD_Workbench_ID)
) 
;


-- 
-- TABLE: AD_WorkbenchWindow 
--

CREATE TABLE AD_WorkbenchWindow(
	AD_WorkbenchWindow_ID	 NUMBER(10, 0)	  NOT NULL,
	AD_Client_ID			 NUMBER(10, 0)	  NOT NULL,
	AD_Org_ID				 NUMBER(10, 0)	  NOT NULL,
	IsActive				 CHAR(1)		   DEFAULT 'Y' NOT NULL,
	Created					 DATE			   DEFAULT SYSDATE NOT NULL,
	CreatedBy				 NUMBER(10, 0)	  NOT NULL,
	Updated					 DATE			   DEFAULT SYSDATE NOT NULL,
	UpdatedBy				 NUMBER(10, 0)	  NOT NULL,
	AD_Workbench_ID			 NUMBER(10, 0)	  NOT NULL,
	SeqNo					 NUMBER(10, 0)	  NOT NULL,
	IsPrimary				 CHAR(1)		   DEFAULT 'N' NOT NULL,
	EntityType				 CHAR(1)		   DEFAULT 'D' NOT NULL,
	AD_Window_ID			 NUMBER(10, 0),
	AD_Form_ID				 NUMBER(10, 0),
	AD_Process_ID			 NUMBER(10, 0),
	AD_Task_ID				 NUMBER(10, 0),
	CHECK (IsActive in ('Y','N')),
	CHECK (IsPrimary in ('Y','N')),
	CONSTRAINT AD_WorkbenchWindow_Key PRIMARY KEY (AD_WorkbenchWindow_ID)
) 
;


-- 
-- TABLE: AD_Workbench_Trl 
--

CREATE TABLE AD_Workbench_Trl(
	AD_Workbench_ID	   NUMBER(10, 0)	  NOT NULL,
	AD_Language		   VARCHAR2(6)		  NOT NULL,
	AD_Client_ID	   NUMBER(10, 0)	  NOT NULL,
	AD_Org_ID		   NUMBER(10, 0)	  NOT NULL,
	IsActive		   CHAR(1)			   DEFAULT 'Y' NOT NULL,
	Created			   DATE				   DEFAULT SYSDATE NOT NULL,
	CreatedBy		   NUMBER(10, 0)	  NOT NULL,
	Updated			   DATE				   DEFAULT SYSDATE NOT NULL,
	UpdatedBy		   NUMBER(10, 0)	  NOT NULL,
	Name			   NVARCHAR2(60)	  NOT NULL,
	Description		   NVARCHAR2(255),
	Help			   NVARCHAR2
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -