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