GpsArtFinder
Tables (6)
course_bookmarks
- id (bookmark_id) — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- course_id — BIGINT — Foreign key → courses.id — NOT NULL
- created_at — DATETIME — NOT NULL
course_review_images
- id (image_id) — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → course_reviews.id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- display_order — INT — NOT NULL
course_reviews
- id (review_id) — BIGINT — Primary key — NOT NULL
- course_id — BIGINT — Foreign key → courses.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- rating — INT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- helpful_count (like_count) — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
courses
- id (course_id) — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
review_helpful (review_like)
- id (like_id) — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → course_reviews.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
users
- id (user_id) — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- profile_image_url — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME