IITP 2

테이블 (24)

agonist (Untitled9)

  • id (Key) — 기본 키 — NOT NULL
  • name (Field)

chart (Untitled20)

    chart_question (Untitled22)

      common_code (Untitled8)

      • id (Key) — 기본 키 — NOT NULL
      • type (Field)
      • text (Field2)
      • value (Field3)
      • description (Field4)

      content (Untitled2)

      • id (Key) — 기본 키 — NOT NULL
      • user_id (Key2) — 외래 키 → user.id — NOT NULL
      • content_name (Field3)
      • Field4
      • Field5

      content_exercise (Untitled12)

      • id (Key) — 기본 키 — NOT NULL
      • content_id (Key2) — 외래 키 → content.id — NOT NULL
      • exercise_id (Key3) — 외래 키 → exercise.id — NOT NULL
      • Field2

      exercise (Untitled10)

      • id (Key) — 기본 키 — NOT NULL
      • name (Field)
      • exercise_title (Field2)
      • exercise_type (Field3)
      • measure_type (Field4)
      • is_default (Field5)
      • muscle_type (Field6)

      exercise_agonist (-)

      • id (Key) — 기본 키 — NOT NULL
      • exercise_id (Key2) — 외래 키 → exercise.id — NOT NULL
      • agonist_id (Key3) — 외래 키 → agonist.id — NOT NULL

      faq (Untitled13)

      • id (Key) — 기본 키 — NOT NULL
      • title (Field)
      • content (Field2)

      fitness_center (Untitled7)

      • id (Key) — 기본 키 — NOT NULL
      • name (Field)
      • address (Field2)
      • latitude (Field3)
      • longitude (Field4)

      fitness_machine (Untitled6)

      • id (Key) — 기본 키 — NOT NULL
      • exercise_id (Key2) — 외래 키 → exercise.id — NOT NULL
      • fitness_id (Key3) — 외래 키 → fitness_center.id — NOT NULL
      • name (Field3)

      migration (Untitled11)

      • id (Key) — 기본 키 — NOT NULL
      • type (Field)
      • text (Field2)
      • value (Field3)
      • description (Field4)

      notice (Untitled14)

      • id (Key) — 기본 키 — NOT NULL
      • user_id (Key2) — 외래 키 → user.id — NOT NULL
      • title (Field)
      • content (Field2)

      notification (Untitled15)

      • id (Key) — 기본 키 — NOT NULL
      • user_id (Key2) — 외래 키 → user.id — NOT NULL
      • title (Field)
      • content (Field2)
      • status (Field3)
      • type (Field4)

      package (정의 확인 필요) (Untitled3)

      • id (Key) — 기본 키 — NOT NULL
      • user_id (Key2) — 외래 키 → user.id — NOT NULL
      • package_name (Field)

      plan (Untitled4)

      • id (Key) — 기본 키 — NOT NULL
      • user_id (Key2) — 외래 키 → user.id — NOT NULL
      • plan_name (Field)

      plan_exercise (CopyOfUntitled12)

      • id (Key) — 기본 키 — NOT NULL
      • plan_id (Key3) — 외래 키 → plan.id — NOT NULL
      • exercise_id (Key2) — 외래 키 → exercise.id — NOT NULL

      product(누가 파는건지 확인 필요) (Untitled5)

      • Key — 기본 키 — NOT NULL
      • product_name (Field2)

      qna (Untitled16)

      • id (Key) — 기본 키 — NOT NULL
      • user_id (Key2) — 외래 키 → user.id — NOT NULL
      • type (Field)
      • question (Field2)
      • answer (Field3)
      • answerYN (Field4)
      • answered_at (Field5)

      question (Untitled21)

        question_example (Untitled23)

          trainer (Untitled19)

          • id (Key) — 기본 키 — NOT NULL
          • login_id (Field)
          • password (Field2)
          • name (Field3)
          • resident_registration_number (Field4)
          • age (Field5)
          • birthday (Field6)
          • birthday_type (Field7)
          • mobile (Field8)
          • address (Field9)
          • address_detail (Field10)
          • note (Field11)
          • email (Field12)
          • major (Field13)

          user (Untitled)

          • id (Key) — 기본 키 — NOT NULL
          • name (Field2)
          • gender (Field3)
          • mobile (Field4)
          • blood_type (Field5)
          • email (Field6)
          • age (Field7)
          • height (Field8)
          • weight (Field9)
          • uuid (Field11)
          • firebase_token (Field12)
          • address (Field16)
          • address_detail (Field17)
          • profile_path (Field20)
          • profile_name (Field21)
          • profile_thumb_path (Field22)
          • profile_thumb_name (Field23)
          • mileage (Field)

          user_chart (Untitled17)

          • id (Key) — 기본 키 — NOT NULL
          • user_id (Key2) — 외래 키 → user.id — NOT NULL
          • chart_name (Field)
          • attending_physician_opinion (Field2)