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