Hboard

테이블 (3)

강의 (Untitled2)

  • lec_id (Key) — 기본 키 — NOT NULL
  • lec_title (Field)
  • teacher (Field2)
  • level (Field3)
  • time (Field4)
  • chapter (Field5)
  • photo_url (Field6)
  • tag_id (Field7)
  • id (Key2) — 외래 키 → 회원.id — NOT NULL

수강후기 (Untitled3)

  • rev_id (Key) — 기본 키 — NOT NULL
  • rev_title (Field)
  • contents (Field2)
  • rate (Field3)
  • lec_id (Field4)
  • id (Field5)
  • lec_id (Key2) — 외래 키 → 강의.lec_id — NOT NULL

회원 (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • username (Field)
  • user_id (Field2)
  • password (Field3)
  • email (Field4)
  • mobile_phone (Field5)
  • home_phone (Field6)
  • postal_code (Field7)
  • address (Field8)
  • address_detail (Field9)
  • sms_opt (Field10)
  • email_opt (Field11)
  • created_at (Field12)
  • updated_at (Field13)