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