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