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