CityGuide ASP.netCoreWebApi
1.0.0
นี่คือ cityGuide Api ที่เขียนด้วย Asp.net Core แอปพลิเคชันนี้มีส่วนหน้าเชิงมุม 6.#Enjoy Coding
ใช้ Angular 7.0.3 แทนเวอร์ชันล่าสุด 7.0.4 ในขณะนี้
Drop table dbo . Users ;
Drop table dbo . Photos ;
Drop table dbo . Cities ;
CREATE TABLE [dbo].[Users] (
[Id] INT IDENTITY ( 1 , 1 ) NOT NULL ,
[PasswordHash] VARBINARY (MAX) NULL ,
[PasswordSalt] VARBINARY (MAX) NULL ,
[Username] NVARCHAR (MAX) NULL
);
CREATE TABLE [dbo].[Cities] (
[Id] INT IDENTITY ( 1 , 1 ) NOT NULL ,
[Description] NVARCHAR (MAX) NULL ,
[Name] NVARCHAR (MAX) NULL ,
[UserId] INT NOT NULL
);
CREATE TABLE [dbo].[ Values ] (
[Id] INT IDENTITY ( 1 , 1 ) NOT NULL ,
[Name] NVARCHAR ( 50 ) NULL
);
CREATE TABLE [dbo].[Photos] (
[Id] INT IDENTITY ( 1 , 1 ) NOT NULL ,
[CityId] INT NOT NULL ,
[DateAdded] DATETIME2 ( 7 ) NOT NULL ,
[Description] NVARCHAR (MAX) NULL ,
[IsMain] BIT NOT NULL ,
[Url] NVARCHAR (MAX) NULL ,
[PublicId] NVARCHAR ( 250 ) NULL
);
