forA

Tables (53)

auth_password

  • auth_password_id — varchar(32) — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • password — varchar(500)
  • user_id — varchar(32)

auth_social_login

  • auth_social_login_id — varchar(32) — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • external_user_id — varchar(500) — NOT NULL
  • user_id — varchar(32)
  • provider — enum('NAVER', 'KAKAO', 'GOOGLE', 'APPLE') — NOT NULL

category

  • category_id — bigint — Primary key — NOT NULL
  • category_name — varchar(255)

comment

  • comment_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • anonymous — bit — NOT NULL
  • content — longtext — NOT NULL
  • like_count — int — NOT NULL
  • nickname — varchar(255)
  • profile_image — varchar(255)
  • parent_comment_id — bigint
  • post_id — bigint
  • user_id — varchar(32)
  • parent_id — bigint
  • deleted — bit — NOT NULL
  • deleted_message — varchar(255)

comment_like_filter

  • comment_like_filter_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • comment_id — bigint
  • user_id — varchar(32)

doctor

  • doctor_id — varchar(32) — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • deleted — bit — NOT NULL
  • image — varchar(255)
  • name — varchar(255) — NOT NULL
  • profile — longtext
  • total_brief_review_count — int — NOT NULL
  • total_grade_sum — bigint — NOT NULL
  • total_receipt_review_count — int — NOT NULL
  • hospital_id — varchar(32) — NOT NULL

fcm_token

  • fcm_token_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • token — varchar(255) — NOT NULL
  • user_id — varchar(32) — NOT NULL
  • active — bit — NOT NULL
  • last_seen_at — datetime(6) — NOT NULL

hospital

  • hospital_id — varchar(32) — Primary key — NOT NULL
  • deleted — bit — NOT NULL
  • total_evaluation_review_count — int — NOT NULL
  • total_receipt_review_count — int — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • phone — varchar(20)
  • address — varchar(500) — NOT NULL
  • name — varchar(255) — NOT NULL
  • location — geometry — NOT NULL
  • place_id — varchar(255)

hospital_bookmark

  • hospital_id — varchar(32) — Primary key — NOT NULL
  • user_id — varchar(32) — Primary key — NOT NULL
  • deleted — bit — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)

hospital_brief_review

  • hospital_brief_review_id — varchar(32) — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • adhd_understanding — int — NOT NULL
  • deleted — bit — NOT NULL
  • enough_medical_time — int — NOT NULL
  • kindness — int — NOT NULL
  • doctor_id — varchar(32) — NOT NULL
  • user_id — varchar(32) — NOT NULL

hospital_evaluation_answer

  • hospital_evaluation_answer_id — bigint — Primary key — NOT NULL
  • answer — bit — NOT NULL
  • created_at — datetime(6)
  • hospital_evaluation_question_id — bigint — NOT NULL
  • last_modified_at — datetime(6)
  • hospital_evaluation_review_id — varchar(32) — NOT NULL

hospital_evaluation_question

  • hospital_evaluation_question_id — bigint — Primary key — NOT NULL
  • deleted — bit — NOT NULL
  • seq — int — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • question — varchar(500) — NOT NULL

hospital_evaluation_review

  • hospital_evaluation_review_id — varchar(32) — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • hospital_id — varchar(32) — NOT NULL
  • user_id — varchar(32) — NOT NULL

hospital_receipt_review

  • hospital_receipt_review_id — varchar(32) — Primary key — NOT NULL
  • deleted — bit — NOT NULL
  • help_count — int — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • medical_expense — bigint
  • content — longtext — NOT NULL
  • doctor_id — varchar(32)
  • hospital_id — varchar(32) — NOT NULL
  • images — varchar(1000)
  • receipt_id — varchar(255)
  • user_id — varchar(32) — NOT NULL
  • adhd_understanding — int — NOT NULL
  • enough_medical_time — int — NOT NULL
  • kindness — int — NOT NULL

hospital_receipt_review_help

  • hospital_receipt_review_id — varchar(32) — Primary key — NOT NULL
  • user_id — varchar(32) — Primary key — NOT NULL
  • deleted — bit — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)

magazine

  • magazine_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • chapter_name — varchar(255) — NOT NULL
  • content_author — varchar(255) — NOT NULL
  • content_html — longtext — NOT NULL
  • content_images — varchar(3000)
  • design_type — int — NOT NULL
  • main_title — varchar(255) — NOT NULL
  • sub_title — varchar(255)
  • thumbnail_images — varchar(1000)
  • user_id — varchar(32)
  • scrap_count — int — NOT NULL
  • magazine_category_v2 — varbinary(255)
  • view_count — bigint — NOT NULL

magazine_category

  • magazine_id — bigint — Primary key — NOT NULL
  • category — enum('MY_ADHD', 'CHILD_ADHD', 'EMOTIONS_DAILY_LIFE', 'TIME_MANAGEMENT') — Primary key — NOT NULL

magazine_comment

  • magazine_comment_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • content — text — NOT NULL
  • deleted — bit — NOT NULL
  • nickname — varchar(255)
  • profile_image — varchar(255)
  • magazine_id — bigint
  • parent_comment_id — bigint
  • user_id — varchar(32)
  • like_count — bigint — NOT NULL — 좋아요 수

magazine_comment_like_filter

  • magazine_comment_like_filter_id — bigint — 댓글 좋아요 PK' primary ke
  • comment_id — bigint — NOT NULL — 댓글 ID (FK)
  • user_id — varchar(32) — NOT NULL — 좋아요 누른 사용자 ID (FK)
  • created_at — datetime(6) — 생성 일시
  • last_modified_at — datetime(6) — 마지막 수정 일시

magazine_comment_notification

  • magazine_comment_notification_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • is_read — bit — NOT NULL
  • message — varchar(255) — NOT NULL
  • notification_type — enum('COMMENT', 'REPLY')
  • actor_user_id — varchar(32)
  • comment_id — bigint
  • magazine_id — bigint
  • parent_comment_id — bigint
  • recipient_user_id — varchar(32)

magazine_comment_report

  • magazine_comment_report_id — bigint — 매거진 댓글 신고 PK' primary ke
  • comment_id — bigint — NOT NULL — 댓글/대댓글 ID (FK)
  • report_type — varchar(50) — NOT NULL — 신고 타입
  • reporter_id — varchar(32) — NOT NULL — 신고자 ID (FK)
  • created_at — datetime(6) — 생성 일시
  • last_modified_at — datetime(6) — 마지막 수정 일시

magazine_like_filter

  • magazine_like_filter_id — bigint — 매거진 좋아요 PK' primary ke
  • magazine_id — bigint — NOT NULL — 매거진 ID (FK)
  • user_id — varchar(32) — NOT NULL — 좋아요 누른 사용자 ID (FK)
  • created_at — datetime(6) — 생성 일시
  • last_modified_at — datetime(6) — 마지막 수정 일시

magazine_rank

  • magazine_rank_id — bigint — Primary key — NOT NULL
  • rank_order — int — NOT NULL
  • ranking_type — enum('POPULAR', 'TRENDING') — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • view_count — bigint — NOT NULL
  • magazine_id — bigint — NOT NULL

magazine_scrap_filter

  • magazine_scrap_filter_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • user_id — varchar(32)
  • magazine_id — bigint
  • is_active — bit — NOT NULL

magazine_view_log

  • magazine_view_log_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • magazine_id — bigint — NOT NULL
  • user_id — varchar(255) — NOT NULL

medicine

  • medicine_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • chart — varchar(255)
  • class_name — varchar(255)
  • class_no — varchar(255)
  • color_class1 — varchar(255)
  • color_class2 — varchar(255)
  • drug_shape — varchar(255)
  • entp_name — varchar(255)
  • entp_seq — varchar(255)
  • form_code_name — varchar(255)
  • ingredient_type — enum('METHYLPHENIDATE', 'ATOMOXETINE', 'CLONIDINE')
  • is_favorite — bit
  • item_eng_name — varchar(255)
  • item_image — text
  • item_name — varchar(255)
  • item_seq — varchar(255)
  • rating — double
  • tablet_type — enum('TABLET', 'HARD_CAPSULE', 'SOFT_CAPSULE')

medicine_anon

  • medicine_anon_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • anon_number — int — NOT NULL
  • medicine_id — bigint
  • user_id — varchar(32)

medicine_anon_counter

  • medicine_id — bigint — Primary key — NOT NULL
  • last_anon_number — int — NOT NULL

medicine_bookmark

  • medicine_bookmark_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • deleted — bit — NOT NULL
  • medicine_id — bigint
  • user_id — varchar(32)

medicine_co_medication

  • id — bigint — Primary key — NOT NULL
  • medicine_id — bigint — NOT NULL
  • medicine_review_id — bigint — NOT NULL

medicine_review

  • medicine_review_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • age_range — varchar(50)
  • content — longtext — NOT NULL
  • gender — enum('MALE', 'FEMALE', 'UNKNOWN')
  • grade — double — NOT NULL
  • help_count — int — NOT NULL
  • images — varchar(1000)
  • nickname — varchar(50)
  • profile_image — varchar(255)
  • medicine_id — bigint
  • user_id — varchar(32)

medicine_review_images

  • review_id — bigint — NOT NULL
  • image_url — varchar(255)

medicine_review_like_filter

  • medicine_review_like_filter_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • medicine_review_id — bigint
  • user_id — varchar(32)

medicine_search_history

  • medicine_search_history_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • term — varchar(255) — NOT NULL
  • user_id — varchar(32)
  • searched_at — datetime(6)

notification

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • is_read — bit — NOT NULL
  • message — varchar(255)
  • user_id — varchar(32)
  • post_id — bigint
  • notification_type — enum('COMMENT', 'REPLY', 'LIKE', 'TOP10', 'NEW_MAGAZINE')

post

  • post_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • anonymous — bit — NOT NULL
  • category — enum('TEENS', 'TWENTIES', 'THIRTIES_AND_ABOVE', 'PARENTS')
  • comment_count — int — NOT NULL
  • content — longtext — NOT NULL
  • images — varchar(1000)
  • like_count — int — NOT NULL
  • nickname — varchar(255)
  • profile_image — varchar(255)
  • scrap_count — int — NOT NULL
  • title — varchar(255) — NOT NULL
  • view_count — int — NOT NULL
  • user_id — varchar(32)
  • notified_as_top — bit — NOT NULL
  • category_v2 — enum('MEDICATION_TALK', 'GOAL_CHECK_IN', 'COUNSELING', 'INFORMATION_SHARING', 'DAILY_LIFE', 'TREATMENT_REVIEW', 'PARENTING_REVIEW', 'RAISING_CHILDREN')
  • dday — int
  • medicine_tags — varchar(500)
  • subject — varchar(255)

post_anon

  • post_anon_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • anon_number — int — NOT NULL
  • post_id — bigint
  • user_id — varchar(32)

post_anon_counter

  • post_id — bigint — Primary key — NOT NULL
  • last_anon_number — int — NOT NULL

post_like_filter

  • post_like_filter_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • post_id — bigint — NOT NULL
  • user_id — varchar(32) — NOT NULL

post_scrap_filter

  • post_scrap_filter_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • post_id — bigint
  • user_id — varchar(32)

post_search_history

  • post_search_history_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • term — varchar(255) — NOT NULL
  • user_id — varchar(32) — NOT NULL
  • search_time — datetime(6)

push_notification_approval

  • push_notification_approval_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • push_notification_type — enum('ALL') — NOT NULL

report_comment

  • report_comment_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • report_type — enum('INSULT_AND_DEGRADE', 'MISINFORMATION', 'PERSONAL_INFO_LEAK', 'COMMERCIAL_ADVERTISEMENT', 'HATEFUL_CONTENT') — NOT NULL
  • comment_id — bigint — NOT NULL
  • reporter_id — varchar(32) — NOT NULL

report_post

  • report_post_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • report_count — int — NOT NULL
  • report_type — enum('INSULT_AND_DEGRADE', 'MISINFORMATION', 'PERSONAL_INFO_LEAK', 'COMMERCIAL_ADVERTISEMENT', 'HATEFUL_CONTENT') — NOT NULL
  • post_id — bigint

report_post_v2

  • report_post_v2_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • report_type — enum('INSULT_AND_DEGRADE', 'MISINFORMATION', 'PERSONAL_INFO_LEAK', 'COMMERCIAL_ADVERTISEMENT', 'HATEFUL_CONTENT') — NOT NULL
  • post_id — bigint
  • reporter_id — varchar(32) — NOT NULL

terms

  • terms_id — bigint — Primary key — NOT NULL
  • required — bit — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • seq — bigint — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — tinytext — NOT NULL

user

  • user_id — varchar(255) — Primary key — NOT NULL
  • is_verified_email — bit — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • profile_image — varchar(255)
  • role — enum('ADMIN', 'USER', 'GUEST', 'ANONYMOUS') — NOT NULL
  • email — varchar(100) — NOT NULL
  • deleted — bit — NOT NULL
  • deleted_at — datetime(6)
  • status — enum('CLEAN', 'DAY_2_PAUSE', 'DAY_ALL_PAUSE', 'POST_DELETE')
  • is_temporary_password — tinyint(1) — NOT NULL

user_blocked

  • user_blocked_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • deleted — bit — NOT NULL
  • blocked_user_id — varchar(32) — NOT NULL
  • user_id — varchar(32) — NOT NULL

user_device

  • user_device_id — varchar(32) — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • os_type — varchar(10)
  • os_version — varchar(10)
  • model — varchar(30)
  • device_token — varchar(255)
  • user_id — varchar(32)

user_privacy

  • user_privacy_id — varchar(32) — Primary key — NOT NULL
  • birth — date
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • age_range — varchar(50)
  • name — varchar(50) — NOT NULL
  • user_id — varchar(32)
  • gender — enum('MALE', 'FEMALE', 'UNKNOWN') — NOT NULL

user_profile

  • user_profile_id — varchar(32) — Primary key — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • nickname — varchar(50) — NOT NULL
  • profile_image — varchar(255)
  • user_id — varchar(32)
  • for_adhd_type — enum('FOR_MY_ADHD', 'FOR_CHILDREN_ADHD', 'FOR_AROUND_ADHD') — NOT NULL

user_push_notification_approval

  • push_notification_approval_id — bigint — Primary key — NOT NULL
  • user_id — varchar(32) — Primary key — NOT NULL
  • approved — bit — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)

user_terms_approval

  • terms_id — bigint — Primary key — NOT NULL
  • user_id — varchar(32) — Primary key — NOT NULL
  • approved — bit — NOT NULL
  • created_at — datetime(6)
  • last_modified_at — datetime(6)