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)