OpenCourse

Tables (9)

comment (Untitled3)

  • comment_id (Key) — bigint — Primary key — NOT NULL
  • content (Field) — varchar(255) — NOT NULL
  • created (Field2) — datetime — NOT NULL
  • updated (Field3) — datetime
  • course_id (Key3) — bigint — Foreign key → course.course_id — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.user_id — NOT NULL

course (Untitled2)

  • course_id (Key) — bigint — Primary key — NOT NULL
  • title (Field) — varchar(255) — NOT NULL
  • created (Field2) — datetime — NOT NULL
  • updated (Field3) — datetime

follow

  • follow_id (follower_id) — bigint — Primary key — NOT NULL
  • followee_id (Field) — bigint — NOT NULL
  • user_id (Key) — bigint — Foreign key → user.user_id — NOT NULL

location (Untitled4)

  • location_id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(255) — NOT NULL
  • text (Field2) — varchar(255)
  • photo_url (Field3) — varchar(255)
  • posx (Field4) — float — NOT NULL
  • posy (Field5) — float — NOT NULL
  • created (Field6) — datetime — NOT NULL
  • updated (Field7) — datetime
  • course_id (Key2) — bigint — Foreign key → course.course_id — NOT NULL

location_tag (Untitled7)

  • location_tag_id (Key) — bigint — Primary key — NOT NULL
  • location_id (Key2) — bigint — Foreign key → location.location_id — NOT NULL
  • tag_id (Key3) — bigint — Foreign key → tag.tag_id — NOT NULL

tag (Untitled6)

  • tag_id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(255) — NOT NULL

user (Untitled)

  • user_id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — varchar(255) — NOT NULL
  • password (Field2) — varchar(255)
  • name (Field3) — varchar(255) — NOT NULL
  • imageUrl (Field4) — varchar(255)
  • provider (Field5) — varchar(255)
  • provider_id (Field6) — varchar(255)
  • created (Field7) — datetime — NOT NULL
  • updated (Field8) — datetime

user_course_like (Untitled8)

  • user_course_like_id (Key) — bigint — Primary key — NOT NULL
  • course_id (Key3) — bigint — Foreign key → course.course_id — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.user_id — NOT NULL

user_course_save (Untitled9)

  • user_course_save_id (Key) — bigint — Primary key — NOT NULL
  • course_id (Key3) — bigint — Foreign key → course.course_id — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.user_id — NOT NULL