수산물 챗봇

테이블 (11)

Contexts

  • context_id — NUMBER — 기본 키 — NOT NULL
  • context_data — CLOB
  • created_at — TIMESTAMP
  • user_id — NUMBER — NOT NULL

Copy Of Untitled (Seafoodsbymarket)

  • Key (seafood_id) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Key (market_id) — NUMBER — 외래 키 → Markets.Key — NOT NULL
  • Field (market_price) — NUMBER

Markets

  • Key (market_id) — NUMBER — 기본 키 — NOT NULL
  • Field (marketname) — VARCHAR2(30)
  • Field (adress) — VARCHAR2(30)
  • Key (loc_id) — NUMBER — 외래 키 → Untitled.Key — NOT NULL

ResponseMetadata

  • metadata_id — NUMBER — 기본 키 — NOT NULL
  • response_id — NUMBER — NOT NULL
  • context_id — NUMBER — 외래 키 → Contexts.context_id
  • metadata_key — VARCHAR2(50)
  • metadata_value — VARCHAR2(255)

Untitled (Users)

  • Key (user_id) — NUMBER — 기본 키 — NOT NULL
  • Field (username) — VARCHAR2(30)
  • Field2 (email) — VARCHAR(50)
  • Field3 (password_hash) — VARCHAR(255)
  • Field4 (created_at) — TIMESTAMP

Untitled (Queries)

  • Key (query_id) — NUMBER — 기본 키 — NOT NULL
  • Field (query_text) — TEXT
  • Field (created_at) — TIMESTAMP
  • Key (user_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (Responses)

  • Key (response_id) — NUMBER — 기본 키 — NOT NULL
  • Field2 (response_text) — TEXT
  • Field3 (created_at) — TIMESTAMP
  • Key (query_id) — NUMBER — 외래 키 → Untitled.Key — NOT NULL

Untitled (Seafoods)

  • Key (seafood_id) — NUMBER — 기본 키 — NOT NULL
  • Field (seafoodname) — VARCHAR2(30)
  • Field (startmonth) — NUMBER
  • Field (endmonth) — NUMBER

Untitled (Seafoodsbyloc)

  • Key (seafood_id) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Key (loc_id) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Field (callname) — VARCHAR2(30)
  • Field (loc_price) — NUMBER

Untitled (Loc)

  • Key (loc_id) — NUMBER — 기본 키 — NOT NULL
  • Field (county) — VARCHAR2(30)

Untitled (Pricebymonth)

  • Key (seafood_id) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Field (price1) — NUMBER
  • Field2 (price2) — NUMBER
  • Field3 (price3) — NUMBER
  • Field4 (price4) — NUMBER
  • Field5 (price5) — NUMBER
  • Field6 (price6) — NUMBER
  • Field7 (price7) — NUMBER
  • Field8 (price8) — NUMBER
  • Field9 (price9) — NUMBER
  • Field10 (price10) — NUMBER
  • Field11 (price11) — NUMBER
  • Field (price12) — NUMBER