여행 커뮤니티
테이블 (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