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