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