TravelDiary

Tables (11)

ai_report

  • id — BIGINT — Primary key — NOT NULL
  • attraction_id — BIGINT — Foreign key → attraction.id — NOT NULL
  • emotion_type_id — BIGINT — Foreign key → emotion_type.id — NOT NULL
  • content — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

attraction

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • sido_id — BIGINT — Foreign key → sido.id — NOT NULL
  • gugun_id — BIGINT — Foreign key → gugun.id — NOT NULL
  • content_type_id — BIGINT — Foreign key → content_type.id — NOT NULL
  • emotion_type_id — BIGINT — Foreign key → emotion_type.id
  • name — VARCHAR(100)
  • photo — VARCHAR(100)
  • location — POINT
  • address — VARCHAR(100)
  • overview — TEXT
  • is_deleted — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

attraction_emotion_stat

  • attraction_id — BIGINT — Foreign key → attraction.id — NOT NULL
  • emotion_type_id — BIGINT — Foreign key → emotion_type.id — NOT NULL
  • count — INT — NOT NULL
  • score — DOUBLE — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

bookmark

  • attraction_id — BIGINT — Foreign key → attraction.id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

content_type

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(45)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

diary

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • attraction_id — BIGINT — Foreign key → attraction.id — NOT NULL
  • photo — VARCHAR(100)
  • content — TEXT
  • visit_date — DATE
  • is_public — TINYINT — NOT NULL
  • is_analyzed — TINYINT — NOT NULL
  • is_deleted — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

diary_emotion_analysis

  • id — BIGINT — Primary key — NOT NULL
  • diary_id — BIGINT — Foreign key → diary.id — NOT NULL
  • emotion_type_id — BIGINT — Foreign key → emotion_type.id — NOT NULL
  • created_at — DATETIME — NOT NULL

emotion_type

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(20)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

gugun

  • id — BIGINT — Primary key — NOT NULL
  • sido_id — BIGINT — Foreign key → sido.id — NOT NULL
  • name — VARCHAR(20)
  • code — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • provider_id — VARCHAR(100) — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • role — ENUM('USER', 'ADMIN') — NOT NULL
  • profile_image_url — VARCHAR(255)
  • is_deleted — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

sido

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(20)
  • code — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL