DB Create 생성문 AUTO_INCREMENT

-- products 테이블 생성
CREATE TABLE products (
    product_id INT AUTO_INCREMENT PRIMARY KEY,
    product_name VARCHAR(255),
    description VARCHAR(255),
    price INT,
    image_url VARCHAR(255),
    detail_url VARCHAR(255),
    ingredients TEXT(500)
);

-- user_inputs 테이블 생성
CREATE TABLE user_inputs (
    input_id INT AUTO_INCREMENT PRIMARY KEY,
    brand_name VARCHAR(200),
    gender CHAR(5),
    ingredients TEXT(500),
    efficacy VARCHAR(255),
    price INT,
    grade VARCHAR(255)
);

-- public ingredients 테이블 생성
CREATE TABLE public_ingredients (
    ingredient_id INT AUTO_INCREMENT PRIMARY KEY,
    category VARCHAR(255),
    ingredients TEXT(500),
    description VARCHAR(255)
);

 

각 ID 필드를 오토 인크리먼트(자동 증가)로 생성