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