contoso_schemas

CREATE TABLE favorites (
    id SERIAL PRIMARY KEY,
    createdAt TEXT NOT NULL
);
CREATE TABLE listings (
    id SERIAL PRIMARY KEY,
    createdAt TEXT NOT NULL,
    title VARCHAR(255) NOT NULL,
    slug VARCHAR(255) NOT NULL,
    bathrooms TEXT NOT NULL,
    bedrooms TEXT NOT NULL,
    description TEXT NOT NULL,
    type TEXT NOT NULL,
    isFeatured TEXT NOT NULL,
    isRecommended TEXT NOT NULL,
    photos TEXT NOT NULL,
    capacity TEXT NOT NULL,
    ammenities TEXT NOT NULL,
    reviews_stars TEXT NOT NULL,
    reviews_number TEXT NOT NULL,
    isFavorited TEXT NOT NULL,
    address TEXT NOT NULL,
    fees TEXT NOT NULL
);
CREATE TABLE up_users (
    id SERIAL PRIMARY KEY,
    username VARCHAR(255) UNIQUE NOT NULL,
    email VARCHAR(255) UNIQUE NOT NULL,
    provider VARCHAR(255),
    password VARCHAR(255) NOT NULL,
    resetPasswordToken VARCHAR(255),
    confirmationToken VARCHAR(255),
    confirmed BOOLEAN DEFAULT FALSE,
    blocked BOOLEAN DEFAULT FALSE
);
ALTER TABLE favorites
ADD COLUMN listing_id INTEGER,
ADD COLUMN user_id INTEGER,
ADD CONSTRAINT fk_listing
    FOREIGN KEY (listing_id)
    REFERENCES listings (id),
ADD CONSTRAINT fk_user
    FOREIGN KEY (user_id)
    REFERENCES up_users (id);
ALTER TABLE listings
ADD COLUMN favorite_id INTEGER,
ADD CONSTRAINT fk_favorite
    FOREIGN KEY (favorite_id)
    REFERENCES favorites (id);
ALTER TABLE up_users
ADD COLUMN role_id INTEGER,
ADD CONSTRAINT fk_role
    FOREIGN KEY (role_id)
    REFERENCES up_users (id);
ALTER TABLE up_users
ADD COLUMN favorite_id INTEGER,
ADD CONSTRAINT fk_favorite
    FOREIGN KEY (favorite_id)
    REFERENCES favorites (id);