search

SkillTech-Organization / AXERP_API

AXERP Backend layer
0 stars 0 forks source link

Azure SQL DB - manually #2

Closed szdezso closed 4 months ago

szdezso commented 5 months ago

AC-01 Select an appropriate Azure SQL server version

AC-02 Create its: AXERP_DB_TEST

AC-03 Document it to - https://drive.google.com/drive/folders/1YyVa2fLdpzO5OZ6nZmLO_-uRoJns8mV0

szdezso commented 4 months ago

axerpdatabasetest.database.windows.net axerpadministrator VnOAn07280OVfd2g

C-63 commented 4 months ago

Table: GasTransactions v1

@szdezso 

/****** Object:  Table [dbo].[GasTransactions]    Script Date: 2024. 07. 14. 16:56:39 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[GasTransactions](
    [RowID] [bigint] IDENTITY(1,1) PRIMARY KEY,
    [DeliveryID] [bigint] NOT NULL,
    [DateLoadedEnd] [datetime2](7) NULL,
    [DateDelivered] [datetime2](7) NULL,
    [SalesContractID] [nvarchar](50) NULL,
    [SalesStatus] [nvarchar](50) NULL,
    [Terminal] [nvarchar](50) NULL,
    [QtyLoaded] [decimal](18, 2) NULL,
    [ToDeliveryID] [bigint] NULL,
    [Status] [nvarchar](50) NULL,
    [SpecificDeliveryPoint] [nvarchar](50) NULL,
    [DeliveryPoint] [nvarchar](50) NULL,
    [Transporter] [nvarchar](50) NULL,
    [DeliveryUP] [decimal](18, 2) NULL,
    [TransportCharges] [decimal](18, 2) NULL,
    [UnitSlotCharge] [decimal](18, 2) NULL,
    [ServiceCharges] [decimal](18, 2) NULL,
    [UnitStorageCharge] [decimal](18, 2) NULL,
    [StorageCharge] [decimal](18, 2) NULL,
    [OtherCharges] [decimal](18, 2) NULL,
    [Sales] [decimal](18, 2) NULL,
    [CMR] [datetime2](7) NULL,
    [BioMWh] [decimal](18, 2) NULL,
    [BillOfLading] [datetime2](7) NULL,
    [BioAddendum] [nvarchar](50) NULL,
    [Comment] [nvarchar](max) NULL,
    [CustomerNote] [nvarchar](max) NULL,
    [Customer] [nvarchar](50) NULL,
    [Reference] [nvarchar](max) NULL,
    [Reference2] [nvarchar](max) NULL,
    [Reference3] [nvarchar](max) NULL,
    [TruckLoadingCompanyComment] [nvarchar](max) NULL,
    [TruckCompany] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
C-63 commented 4 months ago

Table: GasTransactions v2

@szdezso 

/****** Object:  Table [dbo].[GasTransactions]    Script Date: 2024. 07. 14. 16:56:39 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[GasTransactions](
    --[RowID] [bigint] IDENTITY(1,1) PRIMARY KEY,
    [DeliveryID] [nvarchar](50) PRIMARY KEY,
    [DateLoadedEnd] [datetime2](7) NULL,
    [DateDelivered] [datetime2](7) NULL,
    [SalesContractID] [nvarchar](50) NULL,
    [SalesStatus] [nvarchar](50) NULL,
    [Terminal] [nvarchar](50) NULL,
    [QtyLoaded] [decimal](18, 2) NULL,
    [ToDeliveryID] [bigint] NULL,
    [Status] [nvarchar](50) NULL,
    [SpecificDeliveryPoint] [nvarchar](50) NULL,
    [DeliveryPoint] [nvarchar](50) NULL,
    [Transporter] [nvarchar](50) NULL,
    [DeliveryUP] [decimal](18, 2) NULL,
    [TransportCharges] [decimal](18, 2) NULL,
    [UnitSlotCharge] [decimal](18, 2) NULL,
    [ServiceCharges] [decimal](18, 2) NULL,
    [UnitStorageCharge] [decimal](18, 2) NULL,
    [StorageCharge] [decimal](18, 2) NULL,
    [OtherCharges] [decimal](18, 2) NULL,
    [Sales] [decimal](18, 2) NULL,
    [CMR] [datetime2](7) NULL,
    [BioMWh] [decimal](18, 2) NULL,
    [BillOfLading] [datetime2](7) NULL,
    [BioAddendum] [nvarchar](50) NULL,
    [Comment] [nvarchar](max) NULL,
    [CustomerNote] [nvarchar](max) NULL,
    [Customer] [nvarchar](50) NULL,
    [Reference] [nvarchar](max) NULL,
    [Reference2] [nvarchar](max) NULL,
    [Reference3] [nvarchar](max) NULL,
    [TruckLoadingCompanyComment] [nvarchar](max) NULL,
    [TruckCompany] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO