erd1

Tables (11)

bookmark

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content_id — BIGINT — Foreign key → content.content_id — NOT NULL
  • created_at — DATETIME — NOT NULL

comment_like

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • comment_id — BIGINT — Foreign key → comments.comment_id — NOT NULL
  • created_at — DATETIME — NOT NULL

comments

  • comment_id — BIGINT — Primary key — NOT NULL
  • content_id — BIGINT — Foreign key → content.content_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • parent_comment_id — BIGINT — Foreign key → comments.comment_id
  • content — VARCHAR(600) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

content

  • content_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content_type — VARCHAR(20) — NOT NULL
  • title — VARCHAR(60)
  • content — VARCHAR(2000)
  • visibility — VARCHAR(20) — NOT NULL
  • view_count — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

content_like

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content_id — BIGINT — Foreign key → content.content_id — NOT NULL
  • created_at — DATETIME — NOT NULL

course_detail

  • content_id — BIGINT — Foreign key → content.content_id — NOT NULL
  • entered_at — DATETIME

course_place

  • course_place_id — BIGINT — Primary key — NOT NULL
  • course_id — BIGINT — Foreign key → course_detail.content_id — NOT NULL
  • sequence_no — INT — NOT NULL
  • place_name — VARCHAR(100) — NOT NULL
  • latitude — DECIMAL(9,6)
  • longitude — DECIMAL(10,6)
  • visited_at — DATETIME

follow

  • follower_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • following_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • created_at — DATETIME — NOT NULL

photo

  • photo_id — BIGINT — Primary key — NOT NULL
  • content_id — BIGINT — Foreign key → content.content_id — NOT NULL
  • original_file_name — VARCHAR(255)
  • storage_path — VARCHAR(255) — NOT NULL
  • mime_type — VARCHAR(30)
  • sort_order — INT — NOT NULL

review_detail

  • content_id — BIGINT — Foreign key → content.content_id — NOT NULL
  • date_start — DATE — NOT NULL
  • date_end — DATE — NOT NULL
  • tour_loc — VARCHAR(255) — NOT NULL
  • tour_loc_main — VARCHAR(50) — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • password_hash — VARCHAR(128) — NOT NULL
  • introduce — VARCHAR(200)
  • profile_image — VARCHAR(255)
  • gender — VARCHAR(10)
  • grade — SMALLINT
  • created_at — DATETIME — NOT NULL