init.sql

CREATE TABLE IF NOT EXISTS users (
    created_at TIMESTAMP,
    updated_at TIMESTAMP,
    deleted_at TIMESTAMP,
    id int PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    firstname varchar(255) not null,
    lastname varchar(255),
    password varchar(255) not null,
    email varchar(255) not null
);

CREATE TABLE IF NOT EXISTS user_logins (
    created_at TIMESTAMP,
    updated_at TIMESTAMP,
    deleted_at TIMESTAMP,
    id int PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    user_id int not null
);

CREATE TABLE IF NOT EXISTS sellers (
    created_at TIMESTAMP,
    updated_at TIMESTAMP,
    deleted_at TIMESTAMP,
    id int PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    storename varchar(255) not null,
    password varchar(255) not null,
    email varchar(255) not null
);

CREATE TABLE IF NOT EXISTS seller_logins (
    created_at TIMESTAMP,
    updated_at TIMESTAMP,
    deleted_at TIMESTAMP,
    id int PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    seller_id int not null
);

CREATE TABLE IF NOT EXISTS products (
    created_at TIMESTAMP,
    updated_at TIMESTAMP,
    deleted_at TIMESTAMP,
    id int PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    seller_id int not null,
    name varchar(255) not null,
    price int not null,
    image varchar(255) not null
);

CREATE TABLE IF NOT EXISTS cart (
    created_at TIMESTAMP,
    updated_at TIMESTAMP,
    deleted_at TIMESTAMP,
    id int PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    product_id int not null,
    price int not null
);