tables creation, Sql Server

tables creation

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

select @@version as 'sql server version'

create table Customer
(
    Cust_id int constraint id_pk PRIMARY KEY,
    Firstname varchar(100) constraint fn_nn NOT NULL,
    Lastname varchar(100) constraint Ln_nn NOT NULL,
    Street varchar(100) constraint str_nn NOT NULL,
    City varchar(100) constraint cit_nn NOT NULL,
    state varchar(100) constraint stt_nn NOT NULL,
    Zip int constraint zp_nn NOT NULL,
    Phone int constraint zp_nn NOT NULL,
    Email_id varchar(100) constraint em_nn NOT NULL,
    Age int constraint age_ck  CHECK(Age>=18),
    Credit_Limit int constraint cl_ck CHECK(Credit_Limit>=500)
    );
    
    Create Table Orders
(
    order_no int constraint or_pk PRIMARY KEY,
    Date_order int constraint date_nn NOT NULL,
    Totalamount int constraint total_nn NOT NULL,
    Tax int constraint tax_nn NOT NULL,
    City varchar(100) constraint ci_nn NOT NULL,
    State varchar(100) constraint ost_nn NOT NULL,
    Zip int constraint zp_nn NOT NULL,
    Areacode int constraint ac_nn NOT NULL,
    Number int constraint nu_nn NOT NULL,
     FOREIGN KEY (order_no) REFERENCES Customer(Cust_id)
    );
    
    create table Item
    ( 
     Item_no  int constraint it_no PRIMARY KEY,
     Item_Name varchar(100) constraint sn_n1 NOT NULL,
     Qlyonhand varchar(100) constraint sn_n2 NOT NULL,
     Recordpoint varchar(100) constraint sn_n3 NOT NULL,
     Unitprice  varchar(100) constraint sn_n4 NOT NULL,
     FOREIGN KEY (Item_no) REFERENCES Orders(order_no)

);
   create table Supplier 
   (
       Supplier_no int constraint su_pk PRIMARY KEY,
       Sup_Name varchar(100) constraint sn_nn NOT NULL,
       Street varchar(100) constraint str_nn NOT NULL,
       City varchar(100) constraint cit_nn NOT NULL,
       state varchar(100) constraint stt_nn NOT NULL,
       Zip int constraint zp_nn NOT NULL,
       Country varchar(100) constraint co_nn NOT NULL,
       Areacode int constraint ac_nn NOT NULL,
       Number int constraint nu_nn NOT NULL,
       Countrycode int constraint cc_nn NOT NULL,
       Phone int constraint ph_nn NOT NULL,
        FOREIGN KEY (Supplier_no) REFERENCES Item(Item_no)

);
       
        CREATE TABLE Categories
      (
          Cat_Id int constraint c_pk PRIMARY KEY,
          Cat_Name varchar(100) constraint c_nn NOT NULL,
          Description varchar(200) constraint de_nn NOT NULL,
          FOREIGN KEY (Cat_Id) references Item(Item_no)
          );


run \| edit \| history \| help	0