AI:RE
Tables (8)
Chat_Buffer (단기 기억 및 대화 버퍼)
- id (PK) — int — Primary key — NOT NULL
- role (발화자) — ENUM — NOT NULL — user, ai
- context (메세지 내용) — TEXT
- created_at (생성일) — DATETIME — NOT NULL — 현재 시간
Enemies (적군)
- enemies_id (PK) — int — Primary key — NOT NULL
- name (이름) — varchar(50) — NOT NULL
- description (설명) — TEXT
- weakness_json (약점) — JSON
Episodic_Memory (장기기억)
- id (PK) — int — Primary key — NOT NULL
- event_summary (이벤트 요약) — TEXT — NOT NULL
- priority (중요도) — int — 1~10
- timestamp (발생 시간) — DATETIME — NOT NULL
- search (백터 데이터) — JSON
Inventory (CopyOf위치)
- inventory_id (PK) — Primary key — NOT NULL — [0,0] [0,1]
- item_id (FK1) — int — Foreign key → Items.item_id
- item_cnt (Field)
Items (아이템)
- item_id (PK) — int — Primary key — NOT NULL
- name (이름) — varchar(50) — NOT NULL
- description (설명) — TEXT
Location (위치)
- located_id (PK) — int — Primary key — NOT NULL
- enemies_id (FK) — int — Foreign key → Enemies.enemies_id
- item_id (FK1) — int — Foreign key → Items.item_id
- coordinate (좌표) — JSON — NOT NULL
Offline_Task (오프라인 비동기 연동)
- task_id (PK) — int — Primary key — NOT NULL
- item_id (FK) — int — Foreign key → Items.item_id — NOT NULL
- task_type (작업 종류) — ENUM — NOT NULL
- status (상태) — ENUM — NOT NULL
- started_at (작업 요청 시간) — DATETIME — NOT NULL
Recipe (레시피)
- Recipe_id (PK) — int — Primary key — NOT NULL
- item_id (FK) — int — Foreign key → Items.item_id — NOT NULL
- material_json (레시피) — JSON