ййй

 CREATE Table [AddressInfo](

   [AddressInfoId]   Int Identity (1,1)        Not Null, 

  [UserDataId]     INT         NOT NULL,

  [CountryId]  INT    Not Null,

  [ZipCode]  Varchar(20)  Null,

  [City]  Varchar(20)   Null,

  [Street]  Varchar(20)   Null,

  [BuildingNumber] Varchar(20)   Null,  

  [FlatNumber] Varchar(20)   Null,

  [AddressType]   Char(1)   Null,

CONSTRAINT PK_AddressInfo PRIMARY KEY ([AddressInfoId]),

CONSTRAINT FK_AddressInfo_UserData FOREIGN KEY ([UserDataId]) References [UserData] ([UserDataId]),

CONSTRAINT FK_AddressInfo_Country FOREIGN KEY ([CountryId]) References [Country] ([CountryId]),

CONSTRAINT CK_AddressInfo_AddressType CHECK ([AddressType] in ('H', 'W', 'E')), -- H - Home, w - Work, E - Extra

)

INSERT INTO AddressInfo (UserDataId, CountryId, ZipCode, City, Street, BuildingNumber, FlatNumber, AddressType)

values (1, 1, '03928', 'Kiev', 'Green', '8', 145,'H'),

 (2, 2, '03928', 'Krakow', 'White', '9', 7, 'W'),

 (3, 1, '03928', 'Kiev', 'Lomonosov', '2', 456, 'H'),

 (4, 3, '03928', 'NY', 'BlackStreet', '23', 234, 'W'),

 (5, 1, '03928', 'Kiev', 'Test', '1', 1, 'H'),

 (6, 5, '79000', 'Paris', 'Flowers', '2', 23, 'H'),

 (7, 1, '79000', 'Lviv', 'Shevchenko', '7', 45, 'W'),

 (8, 2, '03928', 'Krakow', 'Lomonosov', '2', 999, 'H'),

 (115, 1, '07403', 'Brovaru', 'Olimpiiska', '6', 25, 'H')

  Create Table [Country] (

   [CountryId]  Int   Not null,

  [CountryName] Varchar(20)  null,

  CONSTRAINT PK_Country PRIMARY KEY ([CountryId])

  )

 INSERT INTO Country (CountryId, CountryName)

 VALUES (1, 'Ukraine'),

  (2, 'Poland'),

  (3, 'USA'),

  (4, 'Germany'),

  (5, 'France'),

  (6, 'Great Britain'),

  (7, 'Lithuania'),

  (8, 'Belgium'),

  (9, 'China'),

  (10, 'Japan')