Blooming

Tables (4)

COMPLETE_TASK (Untitled4)

  • 식별자 (complete_task_id) — NN — Primary key — NOT NULL
  • 완료 날짜 (complete_date) — NN
  • 식별자 (subgoal_id) — NN — Foreign key → SUBGOAL.식별자 — NOT NULL

GOAL (Untitled2)

  • 식별자 (goal_id) — NN — Primary key — NOT NULL
  • 식별자 (user_id) — NN — Foreign key → USER.식별자 — NOT NULL
  • 목표명 (goal_name)
  • 시작 날짜 (start_date) — NN

SUBGOAL (Untitled3)

  • 식별자 (subgoal_id) — NN — Primary key — NOT NULL
  • 세부목표명 (subgoal_name)
  • 식별자 (goal_id2) — NN — Foreign key → GOAL.식별자 — NOT NULL

USER (Untitled)

  • 식별자 (user_id) — NN — Primary key — NOT NULL
  • 닉네임 (nickname) — NN
  • 비밀번호 (password) — NN