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 42 43 44 45 46 47 48 49 50 51 52 53 54 55
| CREATE TABLE [dbo].[ADRESSE](
[ADRESSE_NR] [decimal](10, 0) NOT NULL,
[NAME] [varchar](32) NULL,
[VORNAME] [varchar](32) NULL,
[KURZNAME] [varchar](16) NULL,
[TITEL] [varchar](32) NULL,
[ADR1] [varchar](32) NULL,
[ADR2] [varchar](32) NULL,
[ADR3] [varchar](32) NULL,
[PLZ] [varchar](10) NULL,
[ORT] [varchar](32) NULL,
[LAND_ID] [varchar](3) NULL,
[TELEFON1] [varchar](20) NULL,
[TELEFON2] [varchar](20) NULL,
[NATEL] [varchar](20) NULL,
[TELEFAX] [varchar](20) NULL,
[TELEX] [varchar](20) NULL,
[EMAIL] [varchar](80) NULL,
[INTERNET] [varchar](80) NULL,
[PTELEFON1] [varchar](20) NULL,
[PTELEFON2] [varchar](20) NULL,
[PNATEL] [varchar](20) NULL,
[PTELEFAX] [varchar](20) NULL,
[PEMAIL] [varchar](80) NULL,
[PINTERNET] [varchar](80) NULL,
[ADRTYP_SCNR] [smallint] NULL,
[SPRACHE_NR] [smallint] NULL,
[ANREDE_NR] [smallint] NULL,
[ANREDENAME] [varchar](32) NULL,
[INFO] [smallint] NULL,
[AHV] [varchar](20) NULL,
[NOTIZ] [text] NULL,
[LV] [smallint] NULL,
[GEBDATUM] [datetime] NULL,
[GEBTAG] [smallint] NULL,
[GEBMONAT_SCNR] [smallint] NULL,
[GEBJAHR] [smallint] NULL,
[MUTMIT_NR] [smallint] NULL,
[KONTAKTNZUS_SCNR] [smallint] NULL,
[GEBGESCHENK_UCNR] [int] NULL,
[RECHTSFORM_UCNR] [int] NULL,
[WEIHGESCHENK_UCNR] [int] NULL,
[ZUSMIT1_NR] [int] NULL,
[ZUSMIT2_NR] [int] NULL,
[ZUSMIT3_NR] [int] NULL,
[CDATE] [datetime] NOT NULL CONSTRAINT [DF_ADRESSE_CDATE] DEFAULT (getdate()),
[CUSER] [smallint] NOT NULL,
[MDATE] [datetime] NULL,
[MUSER] [smallint] NULL,
[ROWVERSION] [timestamp] NOT NULL,
CONSTRAINT [XPKADRESSE] PRIMARY KEY NONCLUSTERED
(
[ADRESSE_NR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] |
Partager