수산물 챗봇
테이블 (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