OwnCourse

Tables (8)

Course

  • Course ID (id) — BIGINT — Primary key — NOT NULL
  • User ID (user_id) — BIGINT — Foreign key → User.User ID — NOT NULL
  • Course name (course_name) — VARCHAR(45)
  • Place num (place_num) — INT(8)
  • Cost (cost) — INT(10)
  • Hours (hours) — FLOAT
  • Address (address) — VARCHAR(128)
  • Longitude (longitude) — DOUBLE
  • Latitude (latitude) — DOUBLE
  • Create date (created_at) — TIMESTAMP
  • Update date (updated_at) — TIMESTAMP

Course Place (Course_Place)

  • Course_Place ID (id) — BIGINT — Primary key — NOT NULL
  • Course ID (course_id) — BIGINT — Foreign key → Course.Course ID — NOT NULL
  • Place ID (place_id) — INT
  • Place order (place_order) — INT
  • Average costs (avg_cost) — INT
  • Popular menu (popular_menu) — VARCHAR(45)

Place

  • Place ID (id) — INT — Primary key — NOT NULL
  • Geocode ID (geocode_id) — BIGINT
  • Place name (name) — VARCHER(40)
  • Address (address) — VARCHAR(128) — NOT NULL
  • Road address (road_address) — VARCHAR(128) — NOT NULL
  • Category code (category_group_code) — VARCHAR(16) — NOT NULL
  • Category name (category_group_name) — VARCHAR(64) — NOT NULL
  • Hashtags(JSON) (hashtags) — VARCHAR(128) — NOT NULL
  • Phone (phone) — VARCHAR(128) — NOT NULL
  • Homepage URL (url) — VARCHAR(128) — NOT NULL
  • Longitude (longitude) — DOUBLE — NOT NULL
  • Latitude (latitude) — DOUBLE — NOT NULL
  • Descriptions(JSON) (descriptions) — VARCHAR(5120) — NOT NULL
  • Enabled (enabled) — TINYINT — NOT NULL

Place Likes (Place_User)

  • Place_User ID (id) — BIGINT — Primary key — NOT NULL
  • Place ID (place_id) — BIGINT — Foreign key → Place.Place ID — NOT NULL
  • User ID (user_id) — BIGINT — Foreign key → User.User ID — NOT NULL
  • Enabled (enabled) — BOOLEAN
  • Create date (created_at) — TIMESTAMP
  • Update date (updated_at) — TIMESTAMP

Review

  • Review ID (id) — BIGINT — Primary key — NOT NULL
  • User ID (user_id) — BIGINT — Foreign key → User.User ID — NOT NULL
  • Place ID (place_id) — BIGINT — Foreign key → Place.Place ID — NOT NULL
  • Review rating (rating) — FLOAT
  • Review content (content) — VARCHAR(255)
  • Image (review_img) — VARCHAR(2047)
  • Likes (likes) — INT(10)
  • Source (source) — VARCHAR(20)
  • Create date (created_at) — TIMESTAMP

Review Likes (Review_User)

  • Review_User ID (id) — BIGINT — Primary key — NOT NULL
  • Review ID (review_id) — BIGINT — Foreign key → Review.Review ID — NOT NULL
  • User ID (user_id) — BIGINT — Foreign key → User.User ID — NOT NULL
  • Enabled (enabled) — BOOLEAN
  • Create date (created_at) — TIMESTAMP
  • Update date (updated_at) — TIMESTAMP

User

  • User ID (id) — BIGINT — Primary key — NOT NULL
  • Platform type (platform_type) — VARCHAR(20)
  • Email id (email) — VARCHAR(255) — UNIQUE
  • Password (password) — VARCHAR(255)
  • Platform id (platform_id) — BIGINT

User Profile (Profile)

  • User ID (id) — BIGINT — Foreign key → User.User ID — NOT NULL
  • Name (name) — VARCHAR(20)
  • Nickname (nickname) — VARCHAR(20)
  • Profile image (profile_img) — VARCHAR(1023)
  • Age (age) — TINYINT
  • Gender (gender) — VARCHAR(20)
  • Keyword (keyword) — VARCHAR(255)
  • Keyword vector (keyword_vector) — VARCHAR(40)
  • Keyword version (keyword_version) — FLOAT
  • Taste score (t) — FLOAT
  • Service score (s) — FLOAT
  • Cost score (c) — FLOAT
  • TSC Type (tsc_type) — VARCHAR(10)
  • Create date (created_at) — TIMESTAMP — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • Update date (updated_at) — TIMESTAMP — TIMESTAMP ON UPDATE CURRENT_TIMESTAMP