triplog

Tables (15)

attraction_image

  • no — BIGINT — Primary key — NOT NULL
  • image_url — VARCHAR(1000) — NOT NULL
  • review_image_order — INT
  • attraction_no — BIGINT — Foreign key → attractions.no — NOT NULL
  • attraction_review_no — BIGINT — Foreign key → attraction_review.no

attraction_review

  • no — BIGINT — Primary key — NOT NULL
  • user_nickname — VARCHAR(100) — NOT NULL
  • rating — INT — NOT NULL
  • content — TEXT
  • create_at — DATETIME — NOT NULL
  • update_at — DATETIME — NOT NULL
  • attraction_no — BIGINT — Foreign key → attractions.no — NOT NULL
  • user_no — BIGINT — Foreign key → users.no — NOT NULL

attraction_types

  • name — VARCHAR(50) — Primary key — NOT NULL

attractions

  • no — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • title — VARCHAR(255) — NOT NULL
  • overview — VARCHAR(10000)
  • map_level — INT
  • latitude — DECIMAL(20, 17) — NOT NULL
  • longitude — DECIMAL(20, 17) — NOT NULL
  • tel — VARCHAR(20)
  • address — VARCHAR(100) — NOT NULL
  • address_detail — VARCHAR(100)
  • homepage — VARCHAR(1000)
  • api_id — INT
  • thumbnail — VARCHAR(1000)
  • ratingSum — DECIMAL(20, 17)
  • reviewCount — INT
  • attraction_type_no — VARCHAR(50) — Foreign key → attraction_types.name

bookmark

  • booknark_type_no — BIGINT — Foreign key → bookmark_types.no — NOT NULL
  • attraction_no — BIGINT — Foreign key → attractions.no — NOT NULL
  • order — INT — NOT NULL

bookmark_types

  • no — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • attraaction_count — Int
  • user_no — BIGINT — Foreign key → users.no — NOT NULL

follow_info

  • no — BIGINT — Primary key — NOT NULL
  • follow — BIGINT — Foreign key → users.no — NOT NULL
  • follower — BIGINT — Foreign key → users.no — NOT NULL
  • create_at — DATETIME

like_post

  • user_no — BIGINT — Foreign key → users.no — NOT NULL
  • plan_post_no — BIGINT — Foreign key → plan_post.no — NOT NULL
  • liked_at — DATETIME

my_daily_plan

  • no — BIGINT — Primary key — NOT NULL
  • visited_date — DATE — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL
  • move_time — BIGINT — 분 단위로 저장
  • attraction_title — VARCHAR(255) — NOT NULL
  • attraction_thumbnail — VARCHAR(1000)
  • attraction_latitude — DECIMAL(20, 17)
  • attraction_longitude — DECIMAL(20, 17)
  • attraction_rating — DECIMAL(20, 17)
  • memo — VARCHAR(255)
  • attraction_no — BIGINT — Foreign key → attractions.no — NOT NULL
  • my_plan_no — BIGINT — Foreign key → my_plan.no — NOT NULL

my_plan

  • no — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • user_no — BIGINT — Foreign key → users.no — NOT NULL

plan_attraction_detail

  • no — BIGINT — Primary key — NOT NULL
  • visite_date — DATE — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL
  • move_time — INT — 분단위로 저장
  • attraction_title — VARCHAR(255) — NOT NULL
  • attraction_thumbnail — VARCHAR(1000)
  • attraction_rating — DECIMAL(20, 17)
  • writer_rating — INT
  • plan_post_no — BIGINT — Foreign key → plan_post.no — NOT NULL
  • attraction_no — BIGINT — Foreign key → attractions.no — NOT NULL
  • review_no — BIGINT — Foreign key → attraction_review.no

plan_comment

  • no — BIGINT — Primary key — NOT NULL
  • content — VARCHER(1000) — NOT NULL
  • user_nickname — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • level — INT — NOT NULL — 최대 10
  • path — VARCHAR(60) — NOT NULL — 00000-0000-0000...형식으로 관리 / 부모 path + 부모 자식 댓글 개수 + 1
  • child_count — INT — NOT NULL — 최대 9999개
  • plan_post_no — BIGINT — Foreign key → plan_post.no — NOT NULL
  • user_no — BIGINT — Foreign key → users.no — NOT NULL
  • parent_no — BIGINT — Foreign key → plan_comment.no

plan_post

  • no — BIGINT — Primary key — NOT NULL
  • user_nickname — VARCHAR(100) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • totalMember — INT
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • user_no — BIGINT — Foreign key → users.no — NOT NULL
  • fork_count — INT
  • view_count — INT
  • liked_count — INT
  • thumbnail — VARCHAR(1000)
  • startDay — DATETIME
  • endDay — DATETIME

plan_post_tag

  • no — BIGINT — Primary key — NOT NULL
  • plan_post_no — BIGINT — Foreign key → plan_post.no — NOT NULL
  • name — VARCHAR(255) — NOT NULL

users

  • no — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — UNIQUE
  • password — VARCHAR(255)
  • social_type — VARCHAR(20)
  • social_id — VARCHAR(100)
  • nickname — VARCHAR(30) — NOT NULL — UNIQUE
  • profile_url — VARCHAR(1000)
  • created_at — DATETIME — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • phone — VARCHAR(20) — 010-0000-0000형식
  • address — VARCHAR(255)
  • address_detail — VARCHAR(255)
  • follow_count — INT
  • follower_count — INT