growv_erd
Tables (4)
LearningHistory (학습이력)
- history_id — NOT NULL — Primary key — NOT NULL
- user_id — NOT NULL — Foreign key → User.user_id — NOT NULL
- lesson_id — NOT NULL — Foreign key → Lesson.lesson_id — NOT NULL
- status (상태) — NOT NULL
Lesson (학습목록)
- lesson_id — NOT NULL — Primary key — NOT NULL
- title (학습명) — NOT NULL
- category (카테고리) — NOT NULL
- duration (시청시간) — NOT NULL
- point_reward (포인트리워드) — NOT NULL
- user_id — NOT NULL — Foreign key → User.user_id — NOT NULL
User (회원)
- user_id — NOT NULL — Primary key — NOT NULL
- login_id (로그인아이디) — NOT NULL
- password (비밀번호) — NOT NULL
- p_name (학부모_이름) — NOT NULL
- email (이메일) — NOT NULL
- phone_number (핸드폰 번호) — NOT NULL
- c_name (자녀_이름) — NOT NULL
- gender (성별) — NOT NULL
- birth (생일) — NOT NULL
- created_at (생성일시) — NOT NULL
- updated_at (수정일시) — NOT NULL
point (포인트)
- point_id — NOT NULL — Primary key — NOT NULL
- user_id — NOT NULL — Foreign key → User.user_id — NOT NULL
- history_id — NOT NULL — Foreign key → LearningHistory.history_id — NOT NULL
- point_amount (적립/차감포인트) — NOT NULL
- reason (적립/차감이유) — NOT NULL
- created_at (포인트발생시각) — NOT NULL