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 (시작일)