Can someone tell me if this schema design is good or what
I need to change in your opinion. I will respond back to
any replies, so please check. Thanks everyone.
CREATE TABLE [dbo].[Storages] (
[StorageID] [int] IDENTITY (100, 1) NOT NULL
PRIMARY KEY,
[EmpID] [int] NOT NULL ,
[StorageName] [varchar] (50) NOT NULL ,
[StreetAddress] [varchar] (150) NOT NULL ,
[City] [varchar] (50) NOT NULL ,
[State] [char] (2) NOT NULL CHECK ([State]
like '[A-Z][A-Z]'),
[PostalCode] [char] (5) NOT NULL CHECK
([PostalCode] like '[0-9][0-9][0-9][0-9][0-9]'),
[Country] [varchar] (25) NOT NULL DEFAULT 'USA',
[Phone] [char] (12) NULL CHECK ([Phone] like '[0-9]
...
Bookmarks