Create table in SQL Server

Database Name

use DB03TMS283_1819

Table name: tbl_userstore_tms283_G3

create TABLE tbl_userstore_tms283_G3
(
loginID int primary key identity(1,1),
username VARCHAR(50),
loginPassword VARCHAR(50),
loginTimestamp DATETIME
)

Table Name: tbl_customer_tms283_G3

CREATE TABLE tbl_customer_tms283_G3
(
customerID INT PRIMARY KEY IDENTITY(100000000,1),
customerSSNId INT,
customerName VARCHAR(100),
customerAge int,
customerAddressLine1 VARCHAR(100),
customerAddressLine2 VARCHAR(100),
customerCityID VARCHAR(50),
customerStateID VARCHAR(50) 
)

Table Name: tbl_account_tms283_G3

CREATE TABLE tbl_account_tms283_G3(
accountID int primary Key identity(1000000000,1),
customerID INT foreign key references tbl_customer_tms283_G3(customerID),
accountType VARCHAR(20),
depositeAmmount INT
)

Table Name: tbl_customerAccountStatus_tms283_G3

Create Table tbl_customerAccountStatus_tms283_G3
(

SSNID int primary key,
customerID int  foreign key references tbl_customer_tms283_G3(customerID),
accountID int foreign key references tbl_account_tms283_G3(accountID), 
accountType varchar(20),
accountStatus varchar(30),
accountMessage varchar(255),
lastUpdated DateTime
)