lv4

Tables (6)

comments (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → users.id — NOT NULL
  • lesson_id (Key3) — Long — Foreign key → lesson.id — NOT NULL
  • comments (Field) — String
  • createAt (Field2) — Date
  • modifiedAt (Field3) — Date

countLikes (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • lesson_id (Key2) — Long — Foreign key → lesson.id — NOT NULL
  • likes (Field) — Long

lesson (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • id (teacher_id) — Long — Foreign key → teachers.id — NOT NULL
  • title (Field) — String
  • price (Field2) — Long
  • introduction (Field3) — String
  • category (Field4) — String
  • teacherName (Field5) — String
  • createAt (Field6) — Date

likes (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → users.id — NOT NULL
  • lesson_id (Key3) — Long — Foreign key → lesson.id — NOT NULL
  • status (Field) — char

teachers (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • career (Field2) — Long
  • company (Field3) — String
  • phoneNumber (Field4) — String
  • introduction (Field5) — String

users (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • email (Field) — String
  • pw (Field2) — String
  • gender (Field3) — char
  • phoneNumber (Field4) — String
  • address (Field5) — String
  • role (Field6) — String