실습
테이블 (9)
Boards
- board_id — NUMBER
- name — VARCHAR2(100) — NOT NULL
- description — CLOB
- created_at — TIMESTAMP
- is_active — NUMBER(1)
Categories
- category_id — NUMBER
- name — VARCHAR2(50) — NOT NULL
- description — VARCHAR2(255)
Comments
- comment_id — NUMBER
- post_id — NUMBER — NOT NULL
- user_id — NUMBER — NOT NULL
- content — CLOB — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Cooking_History
- history_id — NUMBER
- user_id — NUMBER — NOT NULL
- recipe_id — NUMBER — NOT NULL
- cooked_at — TIMESTAMP
- notes — CLOB
- rating — NUMBER
Posts
- post_id — NUMBER
- board_id — NUMBER — NOT NULL
- user_id — NUMBER — NOT NULL
- title — VARCHAR2(200) — NOT NULL
- content — CLOB — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- view_count — NUMBER
Recipe_Categories
- id — NUMBER
- recipe_id — NUMBER — NOT NULL
- category_id — NUMBER — NOT NULL
Recipe_Embeddings
- embedding_id — NUMBER
- recipe_id — NUMBER — NOT NULL
- embedding_vector — CLOB — NOT NULL
- embedding_type — VARCHAR2(50) — NOT NULL
- model_name — VARCHAR2(100) — NOT NULL
- vector_dimension — NUMBER — NOT NULL
- last_updated — TIMESTAMP
Recipes
- recipe_id — NUMBER
- title — VARCHAR2(200) — NOT NULL
- description — CLOB
- ingredients — CLOB — NOT NULL
- instructions — CLOB — NOT NULL
- prep_time — NUMBER
- cook_time — NUMBER
- servings — NUMBER
- difficulty_level — VARCHAR2(10)
- author_id — NUMBER — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- view_count — NUMBER
Search_Logs
- log_id — NUMBER
- user_id — NUMBER
- query — CLOB — NOT NULL
- embedding_vector — CLOB
- results — CLOB
- timestamp — TIMESTAMP