Create table in SQL Server

Database Name

<span class="pln">
</span><span class="kwd">use</span><span class="pln"> DB03TMS283_1819
</span>

Table name: tbl_userstore_tms283_G3

<span class="pln">
create TABLE tbl_userstore_tms283_G3
</span><span class="pun">(</span><span class="pln">
loginID </span><span class="kwd">int</span><span class="pln"> primary key identity</span><span class="pun">(</span><span class="lit">1</span><span class="pun">,</span><span class="lit">1</span><span class="pun">),</span><span class="pln">
username VARCHAR</span><span class="pun">(</span><span class="lit">50</span><span class="pun">),</span><span class="pln">
loginPassword VARCHAR</span><span class="pun">(</span><span class="lit">50</span><span class="pun">),</span><span class="pln">
loginTimestamp DATETIME
</span><span class="pun">)</span><span class="pln">
</span>

Table Name: tbl_customer_tms283_G3

<span class="pln">
CREATE TABLE tbl_customer_tms283_G3
</span><span class="pun">(</span><span class="pln">
customerID INT PRIMARY KEY IDENTITY</span><span class="pun">(</span><span class="lit">100000000</span><span class="pun">,</span><span class="lit">1</span><span class="pun">),</span><span class="pln">
customerSSNId INT</span><span class="pun">,</span><span class="pln">
customerName VARCHAR</span><span class="pun">(</span><span class="lit">100</span><span class="pun">),</span><span class="pln">
customerAge </span><span class="kwd">int</span><span class="pun">,</span><span class="pln">
customerAddressLine1 VARCHAR</span><span class="pun">(</span><span class="lit">100</span><span class="pun">),</span><span class="pln">
customerAddressLine2 VARCHAR</span><span class="pun">(</span><span class="lit">100</span><span class="pun">),</span><span class="pln">
customerCityID VARCHAR</span><span class="pun">(</span><span class="lit">50</span><span class="pun">),</span><span class="pln">
customerStateID VARCHAR</span><span class="pun">(</span><span class="lit">50</span><span class="pun">)</span><span class="pln"> 
</span><span class="pun">)</span><span class="pln">
</span>

Table Name: tbl_account_tms283_G3

<span class="pln">
CREATE TABLE tbl_account_tms283_G3</span><span class="pun">(</span><span class="pln">
accountID </span><span class="kwd">int</span><span class="pln"> primary </span><span class="typ">Key</span><span class="pln"> identity</span><span class="pun">(</span><span class="lit">1000000000</span><span class="pun">,</span><span class="lit">1</span><span class="pun">),</span><span class="pln">
customerID INT foreign key references tbl_customer_tms283_G3</span><span class="pun">(</span><span class="pln">customerID</span><span class="pun">),</span><span class="pln">
accountType VARCHAR</span><span class="pun">(</span><span class="lit">20</span><span class="pun">),</span><span class="pln">
depositeAmmount INT
</span><span class="pun">)</span><span class="pln">
</span>

Table Name: tbl_customerAccountStatus_tms283_G3

<span class="pln">
</span><span class="typ">Create</span><span class="pln"> </span><span class="typ">Table</span><span class="pln"> tbl_customerAccountStatus_tms283_G3
</span><span class="pun">(</span><span class="pln">

SSNID </span><span class="kwd">int</span><span class="pln"> primary key</span><span class="pun">,</span><span class="pln">
customerID </span><span class="kwd">int</span><span class="pln">  foreign key references tbl_customer_tms283_G3</span><span class="pun">(</span><span class="pln">customerID</span><span class="pun">),</span><span class="pln">
accountID </span><span class="kwd">int</span><span class="pln"> foreign key references tbl_account_tms283_G3</span><span class="pun">(</span><span class="pln">accountID</span><span class="pun">),</span><span class="pln"> 
accountType varchar</span><span class="pun">(</span><span class="lit">20</span><span class="pun">),</span><span class="pln">
accountStatus varchar</span><span class="pun">(</span><span class="lit">30</span><span class="pun">),</span><span class="pln">
accountMessage varchar</span><span class="pun">(</span><span class="lit">255</span><span class="pun">),</span><span class="pln">
lastUpdated </span><span class="typ">DateTime</span><span class="pln">
</span><span class="pun">)</span><span class="pln"> 
</span>