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