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