studyPlanner

Tables (3)

member (회원)

  • PK (member_id) — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar
  • 이메일 (email) — varchar
  • 비밀번호 (password) — varchar

plan_transaction (Untitled3)

  • PK (plan_transaction_id) — bigint — Primary key — NOT NULL
  • 오늘 진행률 (day_figure) — int
  • 현재 총 진행률 (current_figure) — int
  • study_plan_id — bigint — Foreign key → study_plan.PK — NOT NULL

study_plan (Untitled2)

  • PK (study_plan_id) — bigint — Primary key — NOT NULL
  • 제목 (title) — varchar
  • 내용 (content) — varchar
  • 현재 진행률 (current_figure) — int
  • 완료 수치 (complete_figure) — int
  • 예상 목표 시간 (expect_complete_date) — date
  • 등록 날짜 (registration_date) — date
  • 완료 날짜 (complete_date) — date
  • 진행 여부 (status) — varchar
  • member_id — bigint — Foreign key → member.PK — NOT NULL