mbti_survey

Tables (7)

answer (Untitled2)

  • Key — Primary key — NOT NULL
  • question_no (Field2)
  • score (점수)
  • content (답변)
  • status (상태값)
  • registered (생성일)
  • updated (수정일)

category (건강 고민)

  • category (Key) — Primary key — NOT NULL
  • name (건강고민)

category_material (Untitled4)

  • Key — Primary key — NOT NULL
  • category (Key2) — Foreign key → category.category — NOT NULL
  • category_no (카테고리 no)
  • material (성분)

member_category (Untitled3)

  • member_no (Key) — Primary key — NOT NULL
  • mbity_survey (mbti) — ISTP
  • category_no (선택한 카테고리)

question (Untitled)

  • question_no (Key) — Primary key — NOT NULL
  • question_content (질문)
  • mbti_type (mbti 타입)
  • survye_type (질문에 대한 타입)
  • status (상태값)
  • registered (생성일)
  • updated (수정일)

take_alarm (Untitled6)

  • Key — Primary key — NOT NULL
  • schedule_id (Field)
  • target_time (Field2)
  • registered (Field3)
  • Field4

take_schedule (Untitled5)

  • Key — Primary key — NOT NULL
  • member_no (Field)
  • order_item_no (Field2)
  • product_no (Field3)
  • target_day (Field4) — JSON
  • target_time (Field5)
  • left (Field6)
  • registered (Field8)
  • status (Field7)
  • end_date (예상종료일)
  • start_date (시작일)