create table supplier (
suppid int primary key,
name varchar(80),    
status varchar(2) not null,    
addr1 varchar(80),    
addr2 varchar(80),    
city varchar(80),    
state varchar(80),    
zip varchar(6) ,
phone varchar(80)
);


create table account (
    userid varchar(80) primary key,
    password varchar(25)  not null,
    email varchar(80) not null,
    name varchar(80) not null,
    status varchar(2),
    addr1 varchar(80) not null,
    addr2 varchar(40),
    city varchar(80) not  null,
    state varchar(80) not null,
    zip varchar(20) not null,
    country varchar(20) not null,
    phone varchar(80) not null
);

create table orders (
      orderid int primary key,
      userid varchar(80) not null,
      orderdate date not null,
      shipaddr1 varchar(80) not null,
      shipaddr2 varchar(80),
      shipcity varchar(80) not null,
      shipstate varchar(80) not null,
      shipzip varchar(20) not null,
      shipcountry varchar(20) not null,
      shiptoname varchar(80) not null,
      courier varchar(80) not null,
      totalprice float not null
);
create table payinfo(
       orderid int primary key,
       paytype varchar(10) not null,
       isfinished int not null,
       transactiondate date,
       creditcardinfo int
       );
      
create table creditcardinfo(
          id int primary key,
          creditcard varchar(80) not null,
	      exprdate varchar(7) not null,
	      cardtype varchar(80) not null,
	      billaddr1 varchar(80) not null,
	      billaddr2 varchar(80),
	      billcity varchar(80) not null,
	      billstate varchar(80) not null,
	      billzip varchar(20) not null,
	      billcountry varchar(20) not null,
	      billtoname varchar(80) not null
	     );
       
       
create table orderstatus (
      orderid int not null,
      linenum int not null,
      timestamp date not null,
      status varchar(10) not null
);

create table lineitem (
      orderid int not null,
      linenum int not null,
      itemid varchar(10) not null,
      quantity int not null,
      unitprice float not null
);


create table category (
	catid varchar(10) primary key,
	name varchar(80),
	descn varchar(255)
);


create table product (
    productid varchar(10) primary key ,
    category varchar(10) not null,
    name varchar(80) ,
    descn varchar(255)
);

create table item (
    itemid varchar(10) primary key,
    productid varchar(10) not null,
    listprice float,
    unitcost float,
    supplier int,
    status varchar(2),
    attr1 varchar(80),
    attr2 varchar(80),
    attr3 varchar(80),
    attr4 varchar(80),
    attr5 varchar(80)
);



create table inventory (
    itemid varchar(10) primary key,
    qty int not null
);



CREATE TABLE sequence
(
    name               varchar(30)  primary key,
    nextid             int          not null
);