여행 커뮤니티

테이블 (10)

Article (article)

  • id — BIGINT — 기본 키 — NOT NULL
  • memberId (member_id) — BIGINT — 외래 키 → Member.id — NOT NULL
  • categoryId (category_id) — BIGINT — 외래 키 → Category.id — NOT NULL
  • title — VARCHAR
  • content — BIGINT
  • good — INT
  • hit — INT
  • registerDate (register_date) — TIMESTAMP
  • updateDate (update_date) — TIMESTAMP
  • nation — VARCHAR — 국가
  • status — VARCHAR — enum{ TEMPORARY, PERMANENT }

ArticleLike (article_like)

  • id — BIGINT — 기본 키 — NOT NULL
  • articleId (article_id) — BIGINT — 외래 키 → Article.id — NOT NULL
  • memberId (member_id) — BIGINT — 외래 키 → Member.id — NOT NULL
  • registerDate (register_date) — TIMESTAMP — 좋아요를 누른 시간

Bookmark (bookmark)

  • id — BIGINT — 기본 키 — NOT NULL
  • memberId (member_id) — BIGINT — 외래 키 → Member.id — NOT NULL
  • articleId (article_id) — BIGINT — 외래 키 → Article.id — NOT NULL
  • registerDate (register_date) — TIMESTAMP
  • updateDate (update_date) — TIMESTAMP

Category (category)

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR
  • order — INT

Comment (comment)

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • articleId (article_id) — BIGINT(20) — 외래 키 → Article.id — NOT NULL
  • memberId (member_id) — BIGINT(20) — 외래 키 → Member.id — NOT NULL
  • content — TEXT
  • registerDate (register_date) — TIMESTAMP
  • updateDate (update_date) — TIMESTAMP
  • parentCommentId (parent_comment_id) — BIGINT — 대댓글일 경우, 이 값에 데이터가 있음.
  • good — INT

CommentLike (comment_like)

  • id — BIGINT — 기본 키 — NOT NULL
  • articleId (article_id) — BIGINT — 외래 키 → Article.id — NOT NULL
  • memberId (member_id) — BIGINT — 외래 키 → Member.id — NOT NULL
  • registerDate (register_date) — TIMESTAMP — 좋아요를 누른 시간

Member (member)

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • salt — VARCHAR(255) — 패스워드에 사용될 랜덤 변수.
  • registerDate (register_date) — TIMESTAMP
  • loginDate (login_date) — TIMESTAMP
  • role — VARCHAR(32) — enum{ 1 : USER, 2 : ADMIN}

Report (report)

  • id — BIGINT — 기본 키 — NOT NULL
  • memberId (member_id) — BIGINT — 외래 키 → Member.id — NOT NULL — 신고자
  • target — VARCHAR(32) — enum : Article, Comment
  • targetId (target_id) — BIGINT
  • registerDate (register_date) — TIMESTAMP
  • updateDate (update_date) — TIMESTAMP
  • infoId (info_id) — BIGINT — 외래 키 → ReportInfo.id — NOT NULL
  • content — VARCHAR(200)
  • process — BOOLEAN

ReportInfo (report_info)

  • id — BIGINT — 기본 키 — NOT NULL
  • content — VARCHAR(200)
  • order — BIGINT

UploadFile (upload_file)

  • id — BIGINT — 기본 키 — NOT NULL
  • articleId (article_id) — BIGINT — 외래 키 → Article.id — NOT NULL
  • fileName (file_name) — VARCHAR(255)
  • filePath (file_path) — VARCHAR(255)
  • contentType (content_type) — VARCHAR(10)
  • size — BIGINT
  • registerDate (register_date) — TIMESTAMP
  • updateDate (update_date) — TIMESTAMP