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