ERD

Tables (14)

board_likes

  • board_id — BIGINT — Foreign key → boards.board_id — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • created_at — DATETIME
  • big_board_member — VARCHAR(100)

boards

  • board_id — BIGINT — Primary key — NOT NULL
  • board_name — VARCHAR(200)
  • content — TEXT
  • hit_count — INT
  • image_url — VARCHAR(500)
  • comment_count — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME
  • big_board_member — VARCHAR(100)

comment_likes

  • comment_like_id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → boards.board_id — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id — NOT NULL

comments

  • board_id — BIGINT — Foreign key → boards.board_id — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • member_name — VARCHAR(100)
  • content — TEXT
  • created_at — DATETIME
  • datetime — DATETIME
  • big_comment_board — VARCHAR(100)

itinerary_days

  • day_number — INT — Primary key — NOT NULL
  • itinerary_plan_id — BIGINT — Foreign key → travel_plans.plan_id — NOT NULL
  • day_content — TEXT

itinerary_places

  • itinerary_place_id — BIGINT — Primary key — NOT NULL
  • plan_id — BIGINT — Foreign key → travel_plans.plan_id — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • day_number — INT
  • order_number — INT

media

  • media_id — BIGINT — Primary key — NOT NULL
  • media_type — VARCHAR(50)
  • media_base — VARCHAR(100)
  • media_name — VARCHAR(200)
  • popularity — DOUBLE
  • production_year — INT
  • director — VARCHAR(100)

media_locations

  • id — BIGINT — Primary key — NOT NULL
  • media_type — VARCHAR(50)
  • media_base — VARCHAR(100)
  • media_name — VARCHAR(200)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • hit_address — VARCHAR(255)

members

  • member_id — BIGINT — Primary key — NOT NULL
  • member_name — VARCHAR(100)
  • business_name — VARCHAR(100)
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • lat_modified — BOOLEAN
  • last_modified — DATETIME
  • role — VARCHAR(50)

places

  • place_id — BIGINT — Primary key — NOT NULL
  • category_name — VARCHAR(100)
  • place_name — VARCHAR(200)
  • address_name — VARCHAR(255)
  • road_address_name — VARCHAR(255)
  • x — DOUBLE
  • y — DOUBLE
  • phone — VARCHAR(50)
  • place_url — VARCHAR(500)

readings

  • id — BIGINT — Primary key — NOT NULL
  • media_id — BIGINT — Foreign key → media.media_id — NOT NULL
  • year — INT

reviews

  • review_id — BIGINT — Primary key — NOT NULL
  • place_id — BIGINT — Foreign key → places.place_id — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • review_image — VARCHAR(255)
  • content — TEXT
  • rate — DOUBLE

selected_places

  • place_id — BIGINT — Foreign key → places.place_id — NOT NULL
  • plan_id — BIGINT — Foreign key → travel_plans.plan_id — NOT NULL
  • place_name — VARCHAR(200)
  • address_name — VARCHAR(255)
  • order_number — INT

travel_plans

  • plan_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • theme_name — VARCHAR(100)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • is_public — BOOLEAN
  • last_modified — DATETIME
  • last_accessed — DATETIME
  • thumbnail — VARCHAR(500)
  • title — VARCHAR(200)