 );
 
 CREATE TABLE Posts
-(who varchar2(255) not null,
+(who integer not null,
  message integer not null,
  sm_post integer not null,
  PRIMARY KEY (who, message, sm_post),
- FOREIGN KEY (who) references Account (email_address),
+ FOREIGN KEY (who) references Account (id),
  FOREIGN KEY (message) references Reply (ID),
  FOREIGN KEY (sm_post) references Social_Media_Post(ID)
 );
 
 CREATE TABLE Makes
-(fromacc varchar2(255) not null,
- toacc varchar2(255) not null,
+(fromacc integer not null,
+ toacc integer not null,
  tid integer not null,
  smid integer,
  PRIMARY KEY (tid),
- FOREIGN KEY (fromacc) references Account (email_address),
- FOREIGN KEY (toacc) references Account (email_address),
+ FOREIGN KEY (fromacc) references Account (id),
+ FOREIGN KEY (toacc) references Account (id),
  FOREIGN KEY (tid) references Transaction (ID),
  FOREIGN KEY (smid) references Social_Media_Post (ID)
 );
 
 create sequence seq_transaction minvalue 1 start with 1 increment by 1 cache 10;
 create sequence seq_sm minvalue 1 start with 1 increment by 1 cache 10;
+create sequence seq_account minvalue 1337 start with 1337 increment by 13 cache 10;
 
 -- drop table Makes;
 -- drop table Posts;

);

CREATE TABLE Likes
(who varchar2(255) not null,
 smid integer not null,
 PRIMARY KEY (who, smid),
 FOREIGN KEY (who) references Account (email_address),
 FOREIGN KEY (smid) references Social_Media_Post (ID)
);


CREATE TABLE account
(id integer not null,
 email_address varchar2(255) not null,
 password varchar2(255) not null,
 name varchar2(255) not null,
 SSN char(11),
