mini_project

테이블 (5)

달성 (Untitled3)

  • ACCOM_ID (Key) — 기본 키 — NOT NULL
  • ACCOM_NAME (Field)
  • ACCOM_LEVEL (Field2)
  • ACCOM_IMAGE (Field3)

습관등록 (Untitled2)

  • HABIT_ID (Key) — 기본 키 — NOT NULL
  • USER_ID (Key2) — 외래 키 → 회원.USER_ID — NOT NULL
  • HABIT_NAME (Field)
  • HABIT_TYPE (Field2)
  • HABIT_GOAL (Field3)
  • HABIT_DAYS (Field4)

타이머기록 (Untitled4)

  • HABIT_ID (Key) — 외래 키 → 습관등록.HABIT_ID — NOT NULL
  • USER_ID (Key2) — 외래 키 → 습관등록.USER_ID — NOT NULL
  • COMPLETED (Field)
  • DATE (Field2)
  • Field3

회원 (Untitled)

  • USER_ID (Key) — 기본 키 — NOT NULL
  • USER_NAME (Field)
  • USER_EMAIL (Field2)
  • USER_PIN (Field3)

횟수기록 (Untitled5)

  • HABIT_ID (Key) — 외래 키 → 습관등록.HABIT_ID — NOT NULL
  • USER_ID (Key2) — 외래 키 → 습관등록.USER_ID — NOT NULL
  • COMPLETED (Field)
  • DATE (Field2)
  • Field3
  • Field4