babel

Tables (9)

Category (Untitled9)

  • category_id (카테고리 순번) — Primary key — NOT NULL
  • category_name (카테고리 이름)

Comment (Untitled8)

  • comment_id (댓글 순번) — Primary key — NOT NULL
  • post_id (게시글 순번) — Foreign key → Post.post_id — NOT NULL
  • member_id (회원 순번) — Foreign key → Member.member_id — NOT NULL
  • comment_content (댓글 내용)
  • comment_date (댓글 작성일)

Eng (Untitled7)

  • jpn_id (번역 순번) — Primary key — NOT NULL
  • post_id (게시글 순번) — Foreign key → Post.post_id — NOT NULL
  • jpn_title (일본 제목)
  • jpn_content (일본 내용)

File (Untitled4)

  • file_id (파일 순번) — Primary key — NOT NULL
  • post_id (게시글 순번) — Foreign key → Post.post_id — NOT NULL
  • file_name (파일이름)
  • file_path (파일경로)
  • file_convert_path (파일변환 경로)

Follow (Untitled3)

  • follow_id (팔로우 순번) — Primary key — NOT NULL
  • follow_member_id (팔로워 순번) — Foreign key → Member.member_id — NOT NULL
  • follow_following_id (팔로잉 순번) — FK — NOT NULL
  • follow_follow_date (팔로우 날짜)

Jpn (Untitled6)

  • jpn_id (번역 순번) — Primary key — NOT NULL
  • post_id (게시글 순번) — Foreign key → Post.post_id — NOT NULL
  • jpn_title (일본 제목)
  • jpn_content (일본 내용)

Kor (Untitled5)

  • kor_id (번역 순번) — Primary key — NOT NULL
  • post_id (게시글 순번) — Foreign key → Post.post_id — NOT NULL
  • kor_title (한글 제목)
  • kor_content (한글 내용)

Member (Untitled)

  • member_id (회원 순번) — Primary key — NOT NULL
  • member_user_id (회원 ID)
  • member_pw (회원 비밀번호)
  • member_nick (Field)
  • member_lang (언어)
  • member_profile (회원 프로필)

Post (Untitled2)

  • post_id (게시글 순번) — Primary key — NOT NULL
  • member_id (회원 순번) — Foreign key → Member.member_id — NOT NULL
  • Category_id (카테고리 순번) — Foreign key → Category.category_id — NOT NULL
  • post_title (게시글 제목)
  • post_content (게시글 내용)
  • post_summary (게시글 요약)
  • post_date (게시글 작성일)
  • post_hits (조회수)
  • post_likes (좋아요수)