healthcare
테이블 (24)
account
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- email — character — NOT NULL
- failure_count — integer — NOT NULL
- last_access — timestamp
- name — character — NOT NULL
- notes — character
- password — character — NOT NULL
- promotion — character
- status — character
caution(주의사항) (caution)
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- img_source — character
- name — character — NOT NULL
dosing_supplement
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- email — character
- manufacturing_number — character
- account_id — bigint — 외래 키 → account.id
- supplement_shop_id — bigint — 외래 키 → supplement_shop(쇼핑몰 영양제).id
efficacy (효능) (efficacy)
- id — character — 기본 키 — NOT NULL
- name — character — NOT NULL
health_judgement
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- gender — integer
- inspection_items — character
- judgement_type — integer
- max — double
- min — double
- unit — character
ingredient_content(성분) (ingredient_content)
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- capacity — character
- content — character
- ratio — double
- supplement_manufacturing_number — character — 외래 키 → supplement (식약처 영앙제).manufacturing_number
ingredient_content_name_mapper
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- ingredient_content_name — character
- ingredient_content_standard_name_id — bigint — 외래 키 → ingredient_content_standard_name.id
ingredient_content_standard_name
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- standard_name — character
ingredient_efficacy(원재료) (ingredient_efficacy)
- id — character — 기본 키 — NOT NULL
- create_date — date
- day_intake_high_limit — double
- day_intake_low_limit — double
- intake_unit — character
- last_update_date — date
- material_name — character
- material_type — character
- efficacy_id — character — 외래 키 → efficacy (효능).id
inspection
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- additional_introduction — character
- description_details — character
- inspection_description — character
- inspection_field_name — character
- inspection_hangul_name — character
- inspection_items — character
- reference1 — character
- reference2 — character
- reference3 — character
- reference4 — character
- reference5 — character
inspection_category
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- category_description — character
- category_hangul_name — character
- category_name — character
mbti
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- characteristic — character
- job — character
- type — character
mbtirecommend_ingredient
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- mbti_id — bigint — 외래 키 → mbti.id
mbtiresult
- id — bigint — 기본 키 — NOT NULL
- characteristic — character
- job — character
- recommend_supplement — character
- type — character
new_ingredient_efficacy(성분) (CopyOfingredient_efficacy)
- id — character — 기본 키 — NOT NULL
- create_date — date
- day_intake_high_limit — double
- day_intake_low_limit — double
- intake_unit — character
- last_update_date — date
- material_name — character
- material_type — character
personal_health(개인건강정보) (personal_health)
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- checkup_time — timestamp
- email — character
- bmi — double
- dbp — integer
- gfr — integer
- hdlcholesterol — integer
- ldlcholesterol — integer
- sbp — integer
- sgot — integer
- sgpt — integer
- check_up_institution — character
- check_up_type — character
- chest_radiography — character
- date_of_birth — date
- fasting_blood_sugar — integer
- ggtp — integer
- gender — integer
- healthy_age — integer
- hemoglobin — double
- left_hearing — character
- left_sight — double
- real_age — integer
- right_hearing — character
- right_sight — double
- serum_creatinine — double
- tall — double
- total_cholesterol — integer
- triglycerides — integer
- urine_protein — character
- waist_circumference — double
- weight — double
- account_id — bigint — 외래 키 → account.id
recommend_efficacy (질환별 추천 효능) (recommend_efficacy)
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- inspection_items — character
- efficacy_id — character — 외래 키 → efficacy (효능).id
- recommend_ingredients_id — bigint — 외래 키 → health_judgement.id
recommend_ingredients(질환별 추천 원재료) (recommend_ingredients)
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- inspection_items — character
- ingredient_efficacy_id — character — 외래 키 → ingredient_efficacy(원재료).id
- recommend_ingredients_id — bigint — 외래 키 → health_judgement.id
supplement (식약처 영앙제) (supplement)
- manufacturing_number — character — 기본 키 — NOT NULL
- caution — character
- company_name — character
- expiration_date_days — integer
- form — character
- intake_method — character
- intake_time — character
- is_domestic — boolean
- license_number — character
- permission_date — date
- supplement_name — character
- brand — character
supplement_caution(영양제 주의사항) (supplement_caution)
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- caution_id — bigint — 외래 키 → caution(주의사항).id
- supplement_manufacturing_number — character — 외래 키 → supplement (식약처 영앙제).manufacturing_number
supplement_efficacy(영양제 - 효능) (supplement_efficacy)
- id — bigint — 기본 키 — NOT NULL
- efficacy_id — character — 외래 키 → efficacy (효능).id
- supplement_manufacturing_number — character — 외래 키 → supplement (식약처 영앙제).manufacturing_number
supplement_ingredient(영양제 - 원재료) (supplement_ingredient)
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- ingredient_last_update_date — date
- ingredient_efficacy_id — character — 외래 키 → ingredient_efficacy(원재료).id
- supplement_manufacturing_number — character — 외래 키 → supplement (식약처 영앙제).manufacturing_number
supplement_search_table
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- search_term — character
- supplement_shop_id — bigint — 외래 키 → supplement_shop(쇼핑몰 영양제).id
supplement_shop(쇼핑몰 영양제) (supplement_shop)
- id — bigint — 기본 키 — NOT NULL
- created_date — timestamp
- last_update_date — timestamp
- img_source — character
- number_of_views — integer
- price — integer
- star — double — NOT NULL
- status — character
- supplement_name — character
- supplement_manufacturing_number — character — 외래 키 → supplement (식약처 영앙제).manufacturing_number