실습

테이블 (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