erd1

Tables (8)

board (게시글)

  • board_seq (게시글seq) — Primary key — NOT NULL
  • user_id (사용자id) — varchar — Foreign key → member.user_id — NOT NULL
  • contents (내용) — varchar
  • write_date (작성일) — date
  • delete_date (삭제일) — date
  • use_yn (삭제여부) — char
  • Field7

board_img (게시글 이미지)

  • img_seq (게시글이미지seq) — Primary key — NOT NULL
  • board_seq (게시글seq) — Foreign key → board.board_seq — NOT NULL
  • img_path (이미지 경로) — varchar
  • use_yn (삭제여부) — char
  • delete_date (삭제일) — date
  • Field5
  • Field6

board_like (게시글 좋아요)

  • board_like_seq (Key) — Primary key — NOT NULL
  • board_seq (게시글seq) — Foreign key → board.board_seq — NOT NULL
  • user_id (좋아요 누른 사용자 id) — varchar
  • Field

board_view (게시글 조회수)

  • board_view_seq (Key) — Primary key — NOT NULL
  • board_seq (Key2) — Foreign key → board.board_seq — NOT NULL
  • views (조회수) — int
  • Field

comment (댓글)

  • comment_seq (댓글 seq) — Primary key — NOT NULL
  • board_seq (게시글seq) — Foreign key → board.board_seq — NOT NULL
  • user_id (작성자) — varchar
  • contents (댓글내용) — varchar
  • use_yn (삭제여부) — char
  • write_date (작성일) — date
  • delete_date (삭제일) — date
  • Field7

comment_like (댓글 좋아요)

  • comment_like_seq (Key) — Primary key — NOT NULL
  • comment_seq (댓글 seq) — Foreign key → comment.comment_seq — NOT NULL
  • user_id (좋아요 누른 사용자 id)

follow (팔로우)

  • follow_seq (Key) — Primary key — NOT NULL
  • user_id (사용자id) — varchar — Foreign key → member.user_id — NOT NULL
  • follow_id (팔로우ID) — varchar
  • Field2

member (사용자정보)

  • user_id (사용자id) — varchar — Primary key — NOT NULL
  • password (패스워드) — varchar
  • name (사용자성명) — varchar
  • nickname (사용자별명) — varchar
  • join_date (가입일) — varchar
  • use_yn (사용여부) — varchar
  • sns_yn (마케팅동의여부) — char
  • delete_yn (탈퇴날짜) — date
  • img_path (프로필사진) — varchar2
  • Field