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)