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