CREATE TABLE [dbo].[TL_USER_V3]( [TLID] [varchar](15) NOT NULL, [TLNANME] [varchar](15) NOT NULL, [Password] [varchar](50) NULL, [TLFullName] [nvarchar](200) NULL, [TLSUBBRID] [varchar](15) NULL, [BRANCH_NAME] [nvarchar](200) NULL, [BRANCH_TYPE] [varchar](5) NULL, [RoleName] [varchar](200) NOT NULL, [EMAIL] [varchar](50) NULL, [ADDRESS] [varchar](100) NULL, [PHONE] [varchar](15) NULL, [AUTH_STATUS] [varchar](1) NULL, [MARKER_ID] [varchar](12) NULL, [AUTH_ID] [varchar](12) NULL, [APPROVE_DT] [datetime] NULL, [ISAPPROVE] [varchar](1) NULL, [Birthday] [datetime] NULL, [ISFIRSTTIME] [varchar](1) NULL, [SECUR_CODE] [varchar](50) NULL, CONSTRAINT [PK_TL_USER_V3] PRIMARY KEY CLUSTERED ( [TLNANME] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO