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