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)