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