SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[コード名称マスタ](
[区分] [int] NOT NULL,
[コード] [nvarchar](10) COLLATE Japanese_CI_AS NOT NULL,
[名称] [nvarchar](50) COLLATE Japanese_CI_AS NULL,
[数値1] [int] NULL,
[数値2] [int] NULL,
[作成日] [datetime] NULL,
[更新日] [datetime] NULL
) ON [PRIMARY]
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[社員マスタ](
[社員コード] [nvarchar](4) COLLATE Japanese_CI_AS NOT NULL,
[氏名] [nvarchar](50) COLLATE Japanese_CI_AS NULL,
[フリガナ] [nvarchar](50) COLLATE Japanese_CI_AS NULL,
[所属] [nvarchar](4) COLLATE Japanese_CI_AS NULL,
[性別] [int] NULL,
[作成日] [datetime] NULL,
[更新日] [datetime] NULL,
[給与] [int] NULL,
[手当] [int] NULL,
[管理者] [nvarchar](4) COLLATE Japanese_CI_AS NULL,
[生年月日] [datetime] NULL
) ON [PRIMARY]
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[取引データ](
[取引区分] [nvarchar](2) COLLATE Japanese_CI_AS NOT NULL,
[伝票番号] [int] NOT NULL,
[行] [int] NOT NULL,
[取引日付] [datetime] NULL,
[取引先コード] [nvarchar](4) COLLATE Japanese_CI_AS NULL,
[商品コード] [nvarchar](4) COLLATE Japanese_CI_AS NULL,
[数量] [int] NULL,
[単価] [int] NULL,
[金額] [int] NULL,
[更新済] [nvarchar](1) COLLATE Japanese_CI_AS NULL
) ON [PRIMARY]
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[商品マスタ](
[商品コード] [nvarchar](4) COLLATE Japanese_CI_AS NOT NULL,
[商品名] [nvarchar](50) COLLATE Japanese_CI_AS NULL,
[在庫評価単価] [int] NULL,
[販売単価] [int] NULL,
[商品分類] [nvarchar](3) COLLATE Japanese_CI_AS NULL,
[商品区分] [nvarchar](1) COLLATE Japanese_CI_AS NULL,
[作成日] [datetime] NULL,
[更新日] [datetime] NULL,
[備考] [ntext] COLLATE Japanese_CI_AS NULL,
[削除フラグ] [nvarchar](1) COLLATE Japanese_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[得意先マスタ](
[得意先コード] [nvarchar](4) COLLATE Japanese_CI_AS NOT NULL,
[得意先名] [nvarchar](50) COLLATE Japanese_CI_AS NULL,
[得意先区分] [nvarchar](1) COLLATE Japanese_CI_AS NULL,
[担当者] [nvarchar](4) COLLATE Japanese_CI_AS NULL,
[郵便番号] [nvarchar](7) COLLATE Japanese_CI_AS NULL,
[住所1] [nvarchar](100) COLLATE Japanese_CI_AS NULL,
[住所2] [nvarchar](100) COLLATE Japanese_CI_AS NULL,
[作成日] [datetime] NULL,
[更新日] [datetime] NULL,
[締日] [int] NULL,
[締日区分] [int] NULL,
[支払日] [int] NULL,
[備考] [nvarchar](100) COLLATE Japanese_CI_AS NULL
) ON [PRIMARY]