1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| CREATE TABLE [dbo].[EXTEQU](
[ID_EXT] [dbo].[T_NUMINT] NOT NULL,
[PNU_DIAM] [numeric](4, 0) NULL,
[PNU_PUISS] [numeric](4, 0) NULL,
[PST_NUMSER] [varchar](50) NULL,
[PNU_DEBIT] [varchar](4) NULL,
[PDE_HMT] [numeric](5, 2) NULL,
[PNU_DEBI] [numeric](4, 0) NULL,
[PNU_VROTAT] [numeric](5, 0) NULL,
[PNU_VOLUME] [numeric](5, 0) NULL,
[PNU_ANMES] [numeric](4, 0) NULL,
[PN_DVIEPRE] [numeric](2, 0) NULL,
[PNU_DVIPRE] [numeric](2, 0) NULL,
[PNU_ANRENO] [numeric](4, 0) NULL,
[PMO_VALREM] [numeric](16, 5) NULL,
[PST_RPRNP] [varchar](3) NULL,
[PNU_NBRP] [numeric](3, 0) NULL,
[PMO_MTRP] [numeric](16, 5) NULL,
[PNU_RISQUE] [numeric](3, 0) NULL,
[PMO_MTRNP] [numeric](16, 5) NULL,
[PST_TYPE] [varchar](100) NULL,
[PST_ADRESS] [varchar](250) NULL,
[PST_TYPCON] [varchar](50) NULL,
[PNU_ORDRE] [numeric](4, 0) NULL,
[PST_NEWEQU] [varchar](100) NULL,
[PST_EQUOLD] [varchar](100) NULL,
[PST_TYPOEQ] [varchar](100) NULL,
[PDT_DATMES] [datetime] NULL,
[PDT_DATREN] [datetime] NULL,
[PNU_DVIPMO] [numeric](3, 0) NULL,
[PNU_DVITEC] [numeric](2, 0) NULL,
[PDT_DTRETC] [datetime] NULL,
[PNU_COEF15] [numeric](7, 4) NULL,
[PDT_DEPOSE] [datetime] NULL,
[PDT_POSE] [datetime] NULL,
[PST_REFEXT] [varchar](500) NULL,
CONSTRAINT [PK_EXTEQU] PRIMARY KEY CLUSTERED
(
[ID_EXT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] |
Partager