ㅁㄴㅇㄹ

Tables (5)

GeneratedResults

  • result_id — INT — Primary key
  • search_id — INT — Foreign key → SearchHistory.search_id
  • generated_text — CLOB
  • generated_date — TIMESTAMP

Restaurants

  • restaurant_id — INT — Primary key
  • name — VARCHAR2(100)
  • description — CLOB
  • category — VARCHAR2(50)
  • location — VARCHAR2(255)

Reviews

  • review_id — INT — Primary key
  • user_id — INT — Foreign key → Users.user_id
  • restaurant_id — INT — Foreign key → Restaurants.restaurant_id
  • rating — FLOAT
  • comment — CLOB
  • review_date — TIMESTAMP

SearchHistory

  • search_id — INT — Primary key
  • user_id — INT — Foreign key → Users.user_id
  • search_query — VARCHAR2(255)
  • search_date — TIMESTAMP

Users

  • user_id — INT — Primary key
  • name — VARCHAR2(100)
  • email — VARCHAR2(100)
  • password — VARCHAR2(255)
  • signup_date — TIMESTAMP