CREATE TABLE [dbo].[EMR_Record_Content](
    [bm] [bigint] IDENTITY(1,1) NOT NULL,
    [TempletKey] [bigint] NOT NULL,
    [UserID] [bigint] NOT NULL,
    [RecordID] [bigint] NOT NULL,
    [RowIndex] [bigint] NOT NULL CONSTRAINT [DF_EMR_Record_Content_Order]  DEFAULT ((0)),
    [FiledValue] [varchar](max) NOT NULL CONSTRAINT [DF_EMR_Content_Record_FiledValue]  DEFAULT (''),
    [FieldData] [varchar](max) NOT NULL CONSTRAINT [DF_EMR_Content_Record_FieldData]  DEFAULT (''),
    [isprint] [bit] NULL,
    [type] [tinyint] NULL,
    [isdelete] [bit] NULL,
 CONSTRAINT [PK_EMR_Record_Content] PRIMARY KEY NONCLUSTERED 
(
    [bm] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 30) ON [PRIMARY]
) ON [PRIMARY]


CREATE CLUSTERED INDEX IX_EMR_Record_Content ON dbo.EMR_Record_Content
    (
    RowIndex
    ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

go