CREATE TABLE [COLL_CONFIG_OPERATE_FIELD](
	[ID] [varchar](8) NOT NULL,
	[FID] [varchar](10) NULL,
	[FIELD] [varchar](50) NULL,
	[ISDISPLAY] [varchar](1) NULL,
	[ISEDIT] [varchar](1) NULL,
	[ISMUSTFILL] [varchar](1) NULL,
	[DEFAULT1] [varchar](1000) NULL,
	[ISFORCE] [char](1) NULL
 CONSTRAINT [PK_COLL_CONFIG_OPERATE_FIELD] PRIMARY KEY CLUSTERED 
(
	[ID]
)
)



CREATE TABLE [COLL_DOC_CONFIG](
	[ID] [varchar](8) NOT NULL,
	[DOCNAME] [varchar](100) NULL,
	[TEMPLAET] [varchar](80) NULL,
	[OTHERFIELD] [varchar](8) NULL,
	[MAINTABLE] [varchar](4) NULL,
	[DOCTYPE] [varchar](1) NULL,
        [DCODE] [varchar](64) NULL
 CONSTRAINT [PK_COLL_DOC_CONFIG] PRIMARY KEY CLUSTERED 
(
	[ID]
)
)



CREATE TABLE [COLL_DOC_PRINT](
	[ID] [varchar](8) NOT NULL,
	[DOCID] [varchar](8) NULL,
	[TEMPLAET] [varchar](80)  NULL,
	[PAGE] [numeric](2, 0) NULL
 CONSTRAINT [PK_COLL_DOC_PRINT] PRIMARY KEY CLUSTERED 
(
	[ID]
)
)


