SINO ERD
Tables (9)
aiAnalysis (Untitled6)
- id (Key2) — INT — Primary key — NOT NULL
- post_id (Key) — INT — Foreign key → post.id — NOT NULL
- signal_noise_result (Field) — ENUM('Signal', 'Noise')
- created_at (Field2) — DATETIME
aiAnalyzedEmotion (Untitled7)
- id (Key) — INT — Primary key — NOT NULL
- Analysis_id (Key2) — INT — Foreign key → aiAnalysis.id — NOT NULL
- emotion_id (Key3) — INT — Foreign key → emotion.id — NOT NULL
- percentage (Field) — DECIMAL(5, 2)
emotion (Untitled4)
- id (Key) — INT — Primary key — NOT NULL
- emotion_name (Field) — VARCHAR(20) — NOT NULL
photo (Untitled3)
- id (Key) — INT — Primary key — NOT NULL
- post_id (Key2) — INT — Foreign key → post.id — NOT NULL
- url (Field) — VARCHAR(300)
- is_picked (Field2) — BOOLEAN
- upload_order (Field3) — INT
- created_at (Field4) — DATETIME
post (Untitled2)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → user.id — NOT NULL
- year (Field) — INT — NOT NULL
- month (Field2) — INT
- title (Field3) — VARCHAR(100)
- content (Field4) — VARCHAR(500)
- is_deleted (Field7) — BOOLEAN
- deleted_at (Field6) — DATETIME
- created_at (Field5) — DATETIME
quotation (Untitled8)
- id (Key) — INT — Primary key — NOT NULL
- content (Field) — VARCHAR(500)
- author (Field2) — VARCHAR
- created_at (Field3) — DATETIME
quotationEmotionMap (Untitled9)
- id (Key) — INT — Primary key — NOT NULL
- emotion_id (Key2) — INT — Foreign key → emotion.id — NOT NULL
- quotation_id (Key3) — INT — Foreign key → quotation.id — NOT NULL
user (Untitled)
- id (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(15) — NOT NULL — Unique
- is_deleted (Field3) — BOOLEAN
- deleted_at (Field4) — DATETIME
- created_at (Field2) — DATETIME — NOT NULL
userSelectedEmotion (Untitled5)
- id (Key) — INT — Primary key — NOT NULL
- post_id (Key2) — INT — Foreign key → post.id — NOT NULL
- emotion_id (Key3) — INT — Foreign key → emotion.id — NOT NULL
- is_saved (Field) — BOOLEAN
- percentage (Field2) — DECIMAL(5, 2)