DRAW AND YOU

Tables (17)

User (유저)

  • user_id (Key) — bingint — Primary key — NOT NULL
  • username (Field) — varchar
  • email (Field2) — varchar
  • password (Field3) — varchar
  • role (Field4) — varchar
  • auth_provider (Field5) — varchar
  • profile_image_url (Field6) — varchar
  • gender (Field7) — Enum
  • created_at (Field8) — datetime
  • updated_at (Field9) — datetime

article (게시글)

  • article_id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bingint — Foreign key → User.user_id — NOT NULL
  • content (Field2) — varchar
  • title (Field3) — varchar
  • created_at (Field4) — datetime
  • updated_at (Field5) — datetime

article_comment_count (게시글_댓글수)

  • article_id (Key) — bigint — Primary key — NOT NULL
  • comment_count (Field) — bigint

article_image (게시글 이미지)

  • article_image_id (Key) — bigint — Primary key — NOT NULL
  • article_id (Key2) — bigint — Foreign key → article.article_id — NOT NULL
  • image_url (Field2) — varchar
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime

article_like (게시글_좋아요)

  • article_like_id (Key) — bigint — Primary key — NOT NULL
  • article_id (Field) — bigint
  • user_id (Field2) — bigint
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime
  • Field5

article_like_count (게시글_좋아요수)

  • article_like_count_id (Key) — bigint — Primary key — NOT NULL
  • article_id (Field) — bigint
  • likecount (Field2) — bigint

article_view_count (게시글_조회수)

  • article_view_count_id (Key) — bigint — Primary key — NOT NULL
  • article_id (Field) — bigint
  • view_count (Field2) — bigint

comment (댓글)

  • comment_id (Key) — bigint — Primary key — NOT NULL
  • article_id (Field) — bigint
  • user_id (Field2) — bigint
  • path (Field3) — varchar
  • content (Field4) — varchar
  • deleted (Field5) — bit
  • created_at (Field6) — datetime
  • updated_at (Field7) — datetime

daily_course (일일 코스)

  • daily_course_id (Key) — bigint — Primary key — NOT NULL
  • drawing_id (Key2) — bigint — Foreign key → drawing.drawing_id — NOT NULL
  • therapy_program_id (Field2) — bigint
  • title (Field3)
  • description (Field4)
  • current_day (Field5)
  • course_type (Field6)
  • is_completed (Field7)
  • completed_at (Field8)
  • created_at (Field9)
  • updated_at (Field10)

diary (일기)

  • diary_id (Key) — bigint — Primary key — NOT NULL
  • author_id (Field) — bigint
  • content (Field2) — text
  • emotion_keyword (Field3) — enum
  • image_url (Field4) — varchar
  • title (Field5) — varchar
  • written_at (Field6) — datetime
  • created_at (Field7) — datetime
  • updated_at (Field8) — datetime

drawing (드로잉)

  • drawing_id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
  • title (Field2) — varchar
  • image_url (Field3) — varchar
  • drawn_at (Field4) — datetime
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

drawing_analysis (드로잉 분석)

  • drawing_analysis_id (Key) — bigint — Primary key — NOT NULL
  • drawing_id (Key2) — bigint — Foreign key → drawing.drawing_id — NOT NULL
  • score (Field2) — int
  • color_analysis (Field3) — varchar
  • line_analysis (Field4) — varchar
  • composition_analysis (Field5) — varchar
  • emotion_status (Field6) — varchar
  • created_at (Field7) — datetime
  • updated_at (Field8) — datetime

music_recommendations (음악_추천(VO))

  • drawing_analysis_id (Key) — bigint — Foreign key → drawing_analysis.drawing_analysis_id — NOT NULL
  • artist (Field2) — varchar
  • title (Field3) — varchar
  • image (Field4) — text
  • url (Field5) — text

place_recommendations (장소_추천(VO))

  • drawing_analysis_id (Key) — bigint — Foreign key → drawing_analysis.drawing_analysis_id — NOT NULL
  • address (Field2) — text
  • image (Field3) — text
  • rating (Field4) — double
  • title (Field5) — varchar
  • url (Field6) — text

therapy_program (치료 프로그램)

  • therapy_program_id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
  • start_date (Field2) — datetime
  • finished_date (Field3) — datetime
  • is_finished (Field4) — bit
  • total_days (Field5) — int
  • created_at (Field6) — datetime
  • updated_at (Field7) — datetime
  • Field
  • daily_course_id (Key3) — bigint — Foreign key → daily_course.daily_course_id — NOT NULL

user_hobbies (유저 관심사(VO))

  • user_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
  • hobbies (Field) — varchar

video_recommendations (영상_추천(VO))

  • thumbnail (Field2) — text
  • title (Field3) — varchar
  • url (Field4) — text
  • drawing_analysis_id (Key) — bigint — Foreign key → drawing_analysis.drawing_analysis_id — NOT NULL