create table Password(
    passHash varchar(255),
    passSalt varchar(255),
    passDate timestamp,
    CONSTRAINT Password_passHash_passSalt_pk PRIMARY KEY (passHash, passSalt)
);

create table AppUser(
    userEmail varchar(254),
    userFirst varchar(50) NOT NULL,
    userLast varchar(50) NOT NULL,
    userImg varchar(255),
    userCreated timestamp,
    passHash varchar(255),
    passSalt varchar(255),
    CONSTRAINT AppUser_userEmail_pk PRIMARY KEY (userEmail),
    CONSTRAINT AppUser_passHash_passSalt_uc UNIQUE (passHash, passSalt),
    CONSTRAINT AppUser_passHash_passSalt_fk FOREIGN KEY (passHash, passSalt) REFERENCES Password(passHash, passSalt)
);

create table LinkStack(
    stackId varchar(32),
    stackTitle varchar(100),
    stackDesc varchar(255),
    stackTheme varchar(50),
    userEmail varchar(254),
    CONSTRAINT LinkStack_stackId_pk PRIMARY KEY (stackId),
    CONSTRAINT LinkStack_userEmail_fk FOREIGN KEY (userEmail) REFERENCES AppUser(userEmail)
);

create table Link (
    linkId varchar(32),
    linkHTTP varchar(100),
    linkPlatform varchar(32),
    linkNickname varchar(50),
    linkTitle varchar(50),
    linkDesc varchar(250),
    stackId varchar(32),
    CONSTRAINT Link_linkId_pk PRIMARY KEY (linkId),
    CONSTRAINT Link_stackId_fk FOREIGN KEY (stackId) REFERENCES LinkStack(stackId)
);