test

Tables (23)

account

  • id — bigint — Primary key — 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

  • id — bigint — Primary key — NOT NULL
  • created_date — timestamp
  • last_update_date — timestamp
  • img_source — character
  • name — character — NOT NULL

dosing_supplement

  • id — bigint — Primary key — NOT NULL
  • created_date — timestamp
  • last_update_date — timestamp
  • email — character
  • manufacturing_number — character
  • account_id — bigint
  • supplement_shop_id — bigint

efficacy

  • id — character — Primary key — NOT NULL
  • name — character — NOT NULL

health_judgement

  • id — bigint — Primary key — 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

  • id — bigint — Primary key — NOT NULL
  • created_date — timestamp
  • last_update_date — timestamp
  • capacity — character
  • content — character
  • ratio — double
  • supplement_manufacturing_number — character

ingredient_content_name_mapper

  • id — bigint — Primary key — NOT NULL
  • created_date — timestamp
  • last_update_date — timestamp
  • ingredient_content_name — character
  • ingredient_content_standard_name_id — bigint

ingredient_content_standard_name

  • id — bigint — Primary key — NOT NULL
  • created_date — timestamp
  • last_update_date — timestamp
  • standard_name — character

ingredient_efficacy

  • id — character — Primary key — 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

inspection

  • id — bigint — Primary key — 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 — Primary key — NOT NULL
  • created_date — timestamp
  • last_update_date — timestamp
  • category_description — character
  • category_hangul_name — character
  • category_name — character

mbti

  • id — bigint — Primary key — NOT NULL
  • created_date — timestamp
  • last_update_date — timestamp
  • characteristic — character
  • job — character
  • type — character

mbtirecommend_ingredient

  • id — bigint — Primary key — NOT NULL
  • created_date — timestamp
  • last_update_date — timestamp
  • mbti_id — bigint

mbtiresult

  • id — bigint — Primary key — NOT NULL
  • characteristic — character
  • job — character
  • recommend_supplement — character
  • type — character

personal_health

  • id — bigint — Primary key — 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

recommend_efficacy

  • id — bigint — Primary key — NOT NULL
  • created_date — timestamp
  • last_update_date — timestamp
  • inspection_items — character
  • efficacy_id — character
  • recommend_ingredients_id — bigint

recommend_ingredients

  • id — bigint — Primary key — NOT NULL
  • created_date — timestamp
  • last_update_date — timestamp
  • inspection_items — character
  • ingredient_efficacy_id — character
  • recommend_ingredients_id — bigint

supplement

  • manufacturing_number — character — Primary key — 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

  • id — bigint — Primary key — NOT NULL
  • created_date — timestamp
  • last_update_date — timestamp
  • caution_id — bigint
  • supplement_manufacturing_number — character

supplement_efficacy

  • id — bigint — Primary key — NOT NULL
  • efficacy_id — character
  • supplement_manufacturing_number — character

supplement_ingredient

  • id — bigint — Primary key — NOT NULL
  • created_date — timestamp
  • last_update_date — timestamp
  • ingredient_last_update_date — date
  • ingredient_efficacy_id — character
  • supplement_manufacturing_number — character

supplement_search_table

  • id — bigint — Primary key — NOT NULL
  • created_date — timestamp
  • last_update_date — timestamp
  • search_term — character
  • supplement_shop_id — bigint

supplement_shop

  • id — bigint — Primary key — 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