miniarca
Tables (12)
ACTIVITY_RECOMMENDATION
- id — VARCHAR(255)
- entry_id — VARCHAR(255) — Foreign key → MINIARCA_ENTRY.id
- activity — VARCHAR(255)
- reason — TEXT
BACKGROUND_IMAGE
- id — VARCHAR(255)
- entry_id — VARCHAR(255) — Foreign key → MINIARCA_ENTRY.id
- image_path — VARCHAR(255)
EMOJI
- id — VARCHAR(255)
- entry_id — VARCHAR(255) — Foreign key → MINIARCA_ENTRY.id
- emoji_name — VARCHAR(50)
EMOTION_ANALYSIS
- id — VARCHAR(255)
- entry_id — VARCHAR(255) — Foreign key → MINIARCA_ENTRY.id
- main_emotion — VARCHAR(50)
- emotion_intensity — INT
EMOTION_DETAIL
- id — VARCHAR(255)
- analysis_id — VARCHAR(255) — Foreign key → EMOTION_ANALYSIS.id
- emotion_name — VARCHAR(50)
- intensity — INT
EMOTION_INSIGHT
- id — VARCHAR(255)
- entry_id — VARCHAR(255) — Foreign key → MINIARCA_ENTRY.id
- insight_text — TEXT
FINAL_EMOTION
- id — VARCHAR(255)
- entry_id — VARCHAR(255) — Foreign key → MINIARCA_ENTRY.id
- emotion_category — VARCHAR(50)
- confidence_score — FLOAT
- animation_name — VARCHAR(255)
MINIARCA_ENTRY
- id — VARCHAR(255)
- timestamp — DATETIME
- content — TEXT
- summary — TEXT
- front_path — VARCHAR(255)
- back_path — VARCHAR(255)
OBJECT_KEYWORD
- id — VARCHAR(255)
- entry_id — VARCHAR(255) — Foreign key → MINIARCA_ENTRY.id
- keyword — VARCHAR(100)
PHOTO_DETECTION
- id — VARCHAR(255)
- entry_id — VARCHAR(255) — Foreign key → MINIARCA_ENTRY.id
- label — VARCHAR(255)
- color_hex — VARCHAR(7)
PLACE_EXTRACTION
- id — VARCHAR(255)
- entry_id — VARCHAR(255) — Foreign key → MINIARCA_ENTRY.id
- place_name — VARCHAR(255)
SONG_RECOMMENDATION
- id — VARCHAR(255)
- entry_id — VARCHAR(255) — Foreign key → MINIARCA_ENTRY.id
- song_title — VARCHAR(255)
- reason — TEXT