test
Tables (12)
Calendar
- calendar_id — BIGINT — Primary key — NOT NULL
- member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL
- calendar_start_date — DATETIME — NOT NULL
- calendar_end_date — DATETIME — NOT NULL
CalendarArea
- calendar_area_id — BIGINT — Primary key — NOT NULL
- calendar_id — BIGINT — Foreign key → Calendar.calendar_id — NOT NULL
- calendar_area_name — VARCHAR(255) — NOT NULL
Community
- community_id — BIGINT — Primary key — NOT NULL
- member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL
- community_type — VARCHAR(255) — NOT NULL
- community_create_time — DATETIME — NOT NULL
- community_update_time — DATETIME
- community_view — INT — NOT NULL
- community_title — VARCHAR(255) — NOT NULL
- community_vote — TINYINT — NOT NULL
- community_contents — TEXT — NOT NULL
CommunityComment
- community_comment_id — BIGINT — Primary key — NOT NULL
- community_id — BIGINT — Foreign key → Community.community_id — NOT NULL
- member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL
- community_comment_create_time — DATETIME — NOT NULL
- community_comment_update_time — DATETIME
- community_comment — TEXT — NOT NULL
- community_comment_parent_id — BIGINT — Foreign key → CommunityComment.community_comment_id
CommunityImage
- community_image_id — BIGINT — Primary key — NOT NULL
- community_id — BIGINT — Foreign key → Community.community_id — NOT NULL
- community_image_name — VARCHAR(255) — NOT NULL
- community_image_url — VARCHAR(500) — NOT NULL
- community_image_main — TINYINT — NOT NULL
CommunityLike
- community_like_id — BIGINT — Primary key — NOT NULL
- community_id — BIGINT — Foreign key → Community.community_id — NOT NULL
- member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL
Member
- member_id — VARCHAR(255) — Primary key — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- profileImage — VARCHAR(500) — NOT NULL
Review
- review_id — BIGINT — Primary key — NOT NULL
- member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL
- review_create_time — DATETIME — NOT NULL
- review_view — INT — NOT NULL
- review_title — VARCHAR(255) — NOT NULL
- review_area — VARCHAR(255) — NOT NULL
- review_cost — BIGINT — NOT NULL
- review_suggest — VARCHAR(255) — NOT NULL
- review_content — TEXT — NOT NULL
- review_free_tag — VARCHAR(255)
ReviewComment
- review_comment_id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → Review.review_id — NOT NULL
- member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL
- review_comment_create_time — DATETIME — NOT NULL
- review_comment_update_time — DATETIME
- review_comment — TEXT — NOT NULL
- review_comment_parent_id — BIGINT — Foreign key → ReviewComment.review_comment_id
ReviewImage
- review_image_id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → Review.review_id — NOT NULL
- review_image_name — VARCHAR(255) — NOT NULL
- review_image_url — VARCHAR(500) — NOT NULL
- review_image_main — TINYINT — NOT NULL
ReviewLike
- review_id — BIGINT — Foreign key → Review.review_id — NOT NULL
- member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL
Travel
- travel_content_id — BIGINT — Primary key — NOT NULL
- calendar_id — BIGINT — Foreign key → Calendar.calendar_id — NOT NULL
- travel_title — VARCHAR(255) — NOT NULL
- travel_latitude — VARCHAR(255) — NOT NULL
- travel_longitude — VARCHAR(255) — NOT NULL
- order — BIGINT — NOT NULL