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