averyfairbanks / WatchTower

0 stars 0 forks source link

Limit Text Input for Create/Log Meal fields to match db #13

Closed averyfairbanks closed 1 year ago

averyfairbanks commented 1 year ago

CREATE TABLE IF NOT EXISTS users (
    id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
    email VARCHAR(128) NOT NULL
);

    CREATE TABLE IF NOT EXISTS user_meal (
    id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    user_id BIGINT NOT NULL,
    name VARCHAR(128) NOT NULL, // ex: text input for name must be limited to 128, etc
    description VARCHAR(512),
    photo_url VARCHAR(512),
    time_logged TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
    notified BOOLEAN DEFAULT false
);