USE [NECTARCARD_APP]
GO

/****** Object:  Table [dbo].[POS_FIELDS]    Script Date: 10/05/2022 02:29:27 p. m. ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[POS_FIELDS](
    [NEC_KANJI] [INT] NOT NULL,
    [NEC_SEED] [INT] NOT NULL,
    [NEC_FIELD] [VARCHAR](10) NOT NULL,
    [NAME] [VARCHAR](100) NOT NULL,
    [FIELDS] [INT] NOT NULL,
    [NAME01] [NCHAR](15) NOT NULL,
    [NAME02] [NCHAR](15) NOT NULL,
    [NAME03] [NCHAR](15) NOT NULL,
    [NAME04] [NCHAR](15) NOT NULL,
    [NAME05] [NCHAR](15) NOT NULL,
    [TYPE01] [CHAR](1) NOT NULL,
    [TYPE02] [CHAR](1) NOT NULL,
    [TYPE03] [CHAR](1) NOT NULL,
    [TYPE04] [CHAR](1) NOT NULL,
    [TYPE05] [CHAR](1) NOT NULL,
    [LEN01] [CHAR](2) NOT NULL,
    [LEN02] [CHAR](2) NOT NULL,
    [LEN03] [CHAR](2) NOT NULL,
    [LEN04] [CHAR](2) NOT NULL,
    [LEN05] [CHAR](2) NOT NULL,
    [LENMIN01] [CHAR](2) NOT NULL,
    [LENMIN02] [CHAR](2) NOT NULL,
    [LENMIN03] [CHAR](2) NOT NULL,
    [LENMIN04] [CHAR](2) NOT NULL,
    [LENMIN05] [CHAR](2) NOT NULL,
    [STATUS] [INT] NOT NULL,
    [NEC_KABUS] [INT] NOT NULL,
    [USED_ON_TRANS] [bit] NULL,
    [NEC_ALLOCATION] [INT] NULL,
    [NEC_LEVEL] [INT] NULL,
    [CREATED_DATE] [datetime] NULL,
    [USER_NAME] [VARCHAR](50) NOT NULL,
    [POS_FIELD] [INT] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [PK_POS_FIELDS] PRIMARY KEY CLUSTERED
(
    [NEC_KANJI] ASC,
    [NEC_SEED] ASC,
    [NEC_FIELD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [NECTAR]
) ON [NECTAR]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF__POS_FIELDS__NAME__2355CBBA]  DEFAULT ('') FOR [NAME]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_FIELDS]  DEFAULT ((1)) FOR [FIELDS]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_NAME04]  DEFAULT ('') FOR [NAME04]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_NAME05]  DEFAULT ('') FOR [NAME05]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_TYPE_FIELD01]  DEFAULT ('A') FOR [TYPE01]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_TYPE_FIELD02]  DEFAULT ('A') FOR [TYPE02]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_TYPE_FIELD03]  DEFAULT ('A') FOR [TYPE03]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_TYPE04]  DEFAULT ('A') FOR [TYPE04]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_TYPE05]  DEFAULT ('N') FOR [TYPE05]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_LEN_FIELD01]  DEFAULT ('A') FOR [LEN01]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_LEN_FIELD02]  DEFAULT ('A') FOR [LEN02]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_LEN_FIELD03]  DEFAULT ('A') FOR [LEN03]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_LEN04]  DEFAULT ('A') FOR [LEN04]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_LEN05]  DEFAULT ('0') FOR [LEN05]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_LEN_MIN_FIELD01]  DEFAULT ('A') FOR [LENMIN01]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_LEN_MIN_FIELD02]  DEFAULT ('A') FOR [LENMIN02]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_LEN_MIN_FIELD03]  DEFAULT ('A') FOR [LENMIN03]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_LENMIN04]  DEFAULT ('A') FOR [LENMIN04]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_LENMIN05]  DEFAULT ('0') FOR [LENMIN05]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_STATUS]  DEFAULT ((1)) FOR [STATUS]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF_POS_FIELDS_NEC_KABUS]  DEFAULT ((0)) FOR [NEC_KABUS]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF__POS_FIELD__USED___50287231]  DEFAULT ((0)) FOR [USED_ON_TRANS]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF__POS_FIELD__NEC_A__511C966A]  DEFAULT ((0)) FOR [NEC_ALLOCATION]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF__POS_FIELD__NEC_L__5210BAA3]  DEFAULT ((0)) FOR [NEC_LEVEL]
GO

ALTER TABLE [dbo].[POS_FIELDS] ADD  CONSTRAINT [DF__POS_FIELD__USER___1F5030AC]  DEFAULT ('') FOR [USER_NAME]
GO