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)