linkerverse

Tables (31)

address

  • id — bigint(20)
  • address — varchar(255) — NOT NULL
  • address_detail — varchar(255) — NOT NULL
  • delivery_name — varchar(100) — NOT NULL
  • is_default — bit(1) — NOT NULL
  • latitude — float
  • longitude — float
  • phone_number — varchar(15) — NOT NULL
  • recipient — varchar(100) — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL

ai_analysis_ref

  • ai_analysis_ref_no — int(11) — NOT NULL
  • name — varchar(300) — 분석결과
  • title — varchar(300) — 분석결과
  • description — varchar(1500) — 분석결과
  • recommend_food — varchar(300) — 추천
  • image — varchar(300) — 이미지

ai_analysis_ref_ingredient

  • ai_analysis_ref_no — int(11) — Foreign key → ai_analysis_ref.ai_analysis_ref_no
  • ingredient_id — int(11) — Foreign key → ingredient.ingredient_id — 성분아이디

ai_nail_ref

  • ai_nail_ref_no — int(11) — NOT NULL
  • min — float
  • max — float
  • gender — varchar(20) — 성별
  • diag — varchar(2000) — 진단내용

answer_post

  • id — bigint(20)
  • content — varchar(300)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • post_id — bigint(20) — Foreign key → post.id
  • user_id — bigint(20) — Foreign key → user.id
  • status — varchar(10)

doctor_info

  • id — bigint(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • avatar — varchar(100)
  • description — varchar(300)
  • name — varchar(100)
  • working_hours — int(11)
  • user_id — bigint(20) — Foreign key → user.id
  • store_name — varchar(255)
  • pharm_license_no — varchar(100) — 약사
  • pharm_license_file — varchar(100) — 약사
  • biz_license_no — varchar(100) — 사업자
  • biz_license_file — varchar(100) — 사업자
  • arrange_cert_no — varchar(100) — 소분서비스
  • arrange_cert_file — varchar(100) — 소분서비스
  • bank_account_no — varchar(100) — 계좌
  • bank_name — varchar(50) — 은행명
  • bank_account_file — varchar(100) — 통장

drug

  • id — bigint(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • description — varchar(300)
  • drug_info — longtext
  • name — varchar(100)
  • solution_id — bigint(20) — Foreign key → solution.id
  • image — varchar(255)
  • supplement_id — bigint(20) — Foreign key → supplement.supplement_id — 영양제

event

  • id — bigint(20)
  • coupon — varchar(255)
  • created_at — datetime(6)
  • description — varchar(255)
  • event_name — varchar(255)
  • height — float
  • image — varchar(255)
  • sort_order — int(11)
  • status — bit(1)
  • width — float
  • updated_at — datetime(6)

faq

  • id — bigint(20)
  • answer — varchar(300)
  • created_at — datetime(6)
  • faq_type — varchar(15)
  • question — varchar(300)
  • title — varchar(50)
  • updated_at — datetime(6)

health_analysis

  • id — bigint(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(255)
  • title — varchar(255)
  • user_id — bigint(20) — Foreign key → user.id
  • check_date — datetime(6)
  • finger_cropped_images — longtext
  • finger_scores — longtext
  • health_score — float
  • health_status — longtext
  • health_status_details — longtext
  • current_disease — varchar(255)
  • pregnant — bit(1)

health_answer

  • id — bigint(20)
  • content — varchar(300)
  • sort_order — int(11)
  • health_question_id — bigint(20) — Foreign key → health_question.id

health_question

  • id — bigint(20)
  • gender — nvarchar2(255) — NOT NULL
  • OTHER)) — DEFAULT
  • question — varchar(300)
  • question_type — nvarchar2(255) — NOT NULL
  • ANALYSIS)) — DEFAULT
  • sort_order — int(11)
  • type — nvarchar2(255) — NOT NULL
  • MULTIPLE_CHOICE)) — DEFAULT

ingredient

  • ingredient_id — int(11)
  • name — varchar(100) — 성분명
  • type — varchar(2) — NOT NULL — 성분타입
  • effect — varchar(200) — 효능
  • caution — varchar(500) — 섭취시
  • daily_standard — int(11) — 1일
  • unit — varchar(10) — 단위
  • created_at — datetime — 등록일시
  • del_yn — varchar(1) — 삭제
  • deleted_at — datetime — 삭제일시

inquiry

  • id — bigint(20)
  • answer — varchar(300)
  • answer_created_at — datetime(6)
  • created_question_at — datetime(6)
  • question — varchar(300)
  • title — varchar(50)
  • updated_at — datetime(6)
  • user_aw — bigint(20)
  • user_q — bigint(20)
  • question_created_at — datetime(6)

notification

  • id — bigint(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(255)
  • noti_type — nvarchar2(255) — NOT NULL
  • HEALTH_ANALYSIS)) — DEFAULT
  • title — varchar(255)
  • all_user — bit(1)
  • is_read — bit(1)
  • user_id — bigint(20)
  • noti_detail_type — nvarchar2(255) — NOT NULL
  • REGISTER_TREATMENT_SUCCESSFUL)) — DEFAULT
  • ref_id — bigint(20)

order

  • id — bigint(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • address — varchar(255)
  • coupon — varchar(255)
  • latitude — float
  • longitude — float
  • payment_method — nvarchar2(255) — NOT NULL
  • TOSSPAY)) — DEFAULT
  • payment_souce — varchar(255)
  • status — nvarchar2(255) — NOT NULL
  • FAILED)) — NOT — NOT NULL
  • total_price — decimal(38,2)
  • address_detail — varchar(255)
  • promotion_code — varchar(255)
  • receiver_name — varchar(255)
  • receiver_phone — varchar(255)
  • user_id — bigint(20)
  • order_no — varchar(255)

order_item

  • id — bigint(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • order_date — datetime(6)
  • order_id — bigint(20)
  • order_item_type — nvarchar2(255) — NOT NULL
  • CART_ITEM)) — DEFAULT
  • order_no — varchar(255)
  • quantity — int(11)
  • ship_fee — decimal(38,2)
  • solution_id — bigint(20)
  • status — nvarchar2(255) — NOT NULL
  • DELIVERED)) — DEFAULT
  • total_price — decimal(38,2)
  • user_id — bigint(20)
  • register_treatment_id — bigint(20) — Foreign key → register_treatment.id

post

  • id — bigint(20)
  • content — varchar(300)
  • created_at — datetime(6)
  • title — varchar(50)
  • updated_at — datetime(6)
  • category_question_id — bigint(20) — Foreign key → question_category.id
  • user_id — bigint(20) — Foreign key → user.id
  • images — text
  • status — varchar(10)

question_category

  • id — bigint(20)
  • created_at — datetime(6)
  • description — varchar(300)
  • name — varchar(100)
  • updated_at — datetime(6)

question_set

  • id — bigint(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • gender — nvarchar2(255) — NOT NULL
  • OTHER)) — DEFAULT
  • question_answer — longtext
  • type — nvarchar2(255) — NOT NULL
  • MULTIPLE_CHOICE)) — DEFAULT

register_treatment

  • id — bigint(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • issues — varchar(300)
  • type — varchar(10)
  • user_id — bigint(20) — Foreign key → user.id
  • extra_questions — longtext
  • expiration_time — datetime(6)
  • health_analysis_id — bigint(20) — Foreign key → health_analysis.id
  • issue_names — varchar(300)

solution

  • id — bigint(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • description — varchar(3000)
  • name — varchar(600)
  • price — decimal(38,2)
  • doctor_id — bigint(20) — Foreign key → user.id
  • status — varchar(10) — NOT NULL
  • invoice_no — varchar(100) — 송장번호
  • send_dt — datetime — 배송일시
  • arrange_dt — datetime — 소분완료일시
  • pay_dt — datetime — 결제일시
  • register_treatment_id — bigint(20) — Foreign key → register_treatment.id
  • delivery_company — varchar(200) — 택배회사

solution_review

  • id — bigint(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • comment — varchar(300)
  • images — text
  • rating — int(11)
  • status — varchar(10)
  • solution_id — bigint(20) — Foreign key → solution.id
  • user_id — bigint(20) — Foreign key → user.id
  • subscription_id — bigint(20) — Foreign key → subscription.id

subscription

  • id — bigint(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • end_date — datetime(6)
  • start_date — datetime(6) — NOT NULL
  • status — varchar(15) — NOT NULL
  • user_confirmed — bit(1) — NOT NULL
  • order_item_id — bigint(20) — Foreign key → order_item.id
  • register_treatment_id — bigint(20) — Foreign key → register_treatment.id
  • solution_id — bigint(20) — Foreign key → solution.id
  • user_id — bigint(20) — Foreign key → user.id

supplement

  • supplement_id — bigint(20)
  • name — varchar(100) — 영양제
  • description — varchar(300) — 설명
  • image — varchar(255) — 이미지
  • status — varchar(100) — 등록상태
  • created_at — datetime — 등록일시
  • updated_at — datetime — 수정일시
  • doctor_id — bigint(20) — Foreign key → user.id — 등록약사
  • disease_yn_01 — varchar(1) — NOT NULL — 01
  • disease_yn_02 — varchar(1) — NOT NULL — 02
  • disease_yn_03 — varchar(1) — NOT NULL — 03
  • disease_yn_04 — varchar(1) — NOT NULL — 04
  • manufacture — varchar(100) — 제조사
  • caution — varchar(500) — 주의사항
  • usage — varchar(500) — 섭취방법
  • refer_url — varchar(255) — 참고사이트
  • reject_reason — varchar(300) — 반려사유
  • deleted_at — datetime — 삭제일시

supplement_favorite

  • doctor_id — bigint(20) — Foreign key → user.id — NOT NULL
  • supplement_id — bigint(20) — Foreign key → supplement.supplement_id — NOT NULL — 약
  • reg_dt — datetime — 등록일시

supplement_ingredient

  • supplement_id — bigint(20) — Foreign key → supplement.supplement_id — NOT NULL
  • ingredient_id — int(11) — Foreign key → ingredient.ingredient_id — NOT NULL — 성분
  • name — varchar(200) — 성분명
  • amount — int(11) — 성분함량치
  • unit — varchar(10) — 성분
  • percent — int(11) — 성분
  • reg_dt — datetime — NOT NULL — 성분등록일시

token

  • id — bigint(20)
  • access_token — varchar(500) — NOT NULL
  • created_at — datetime(6)
  • expiry_date — datetime(6)
  • refresh_token — varchar(500) — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id
  • fcm_token — varchar(500)

user

  • id — bigint(20)
  • address — varchar(100)
  • birthday — date
  • created_at — datetime(6)
  • email — varchar(100)
  • first_login — bit(1)
  • gender — nvarchar2(255) — NOT NULL
  • OTHER)) — DEFAULT
  • longitude — float
  • password — varchar(300)
  • phone — varchar(15)
  • referral_code — varchar(10)
  • registered_from — varchar(15) — NOT NULL
  • status — varchar(10)
  • type — nvarchar2(255) — NOT NULL
  • ROLE_DOCTOR)) — DEFAULT
  • updated_at — datetime(6)
  • username — varchar(100) — NOT NULL
  • avatar — varchar(50)
  • address_detail — varchar(100)
  • nickname — varchar(100)
  • latitude — float
  • locale — nvarchar2(255) — NOT NULL
  • ENGLISH)) — DEFAULT
  • name — varchar(100)
  • post_id — bigint(20)
  • user_code — varchar(10)
  • identity_verification_result — longtext

user_info

  • id — bigint(20)
  • bmi — int(11)
  • health_info — longtext
  • height — int(11)
  • weight — int(11)
  • user_id — bigint(20) — Foreign key → user.id
  • coupon — int(11)
  • point — int(11)
  • avatar — varchar(255)
  • marketting_noti — bit(1)
  • system_noti — bit(1)
  • analysis_remaining_count — int(11)
  • bonus_analysis_remaining_count — int(11)

user_notification

  • id — bigint(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • is_read — bit(1)
  • notification_id — bigint(20)
  • user_id — bigint(20)