finalproject

Tables (8)

fp_board (게시판)

  • id (pk) — number — Primary key — NOT NULL
  • member_id (회원 번호) — number — Foreign key → fp_member.id — NOT NULL
  • title (제목) — varchar2(400) — NOT NULL
  • content (내용) — varchar2(5000) — NOT NULL
  • read_count (조회수) — number — NOT NULL
  • reg_date (등록일) — date — NOT NULL

fp_board_image (게시글 이미지)

  • id (이미지번호) — number — Primary key — NOT NULL
  • board_id (글 번호) — number — Foreign key → fp_board.id — NOT NULL
  • original_filename (원본명) — varchar2(400)
  • link (파일링크) — varchar2(500)

fp_comment (댓글)

  • id (pk) — number — Primary key — NOT NULL
  • board_id (글번호) — number — Foreign key → fp_board.id — NOT NULL
  • member_id (회원번호) — number — Foreign key → fp_member.id — NOT NULL
  • comment_text (댓글) — varchar2(4000) — NOT NULL
  • reg_date (등록일) — date — NOT NULL

fp_hobby (취미)

  • id (Key) — number — Primary key — NOT NULL
  • name (취미명) — varchar2(40) — NOT NULL

fp_like (좋아요)

  • id (Key) — number — Primary key — NOT NULL
  • board_id (게시글번호) — number — Foreign key → fp_board.id — NOT NULL
  • member_id (회원번호) — number — Foreign key → fp_member.id — NOT NULL
  • like_date (Field) — date — NOT NULL

fp_mail_auth (메일 인증)

  • id (pk) — number — Primary key — NOT NULL
  • member_id (회원번호) — number — Foreign key → fp_member.id — NOT NULL
  • key (인증키) — varchar2(200) — NOT NULL
  • complete (인증여부) — varchar2(1) — NOT NULL
  • complete_date (인증완료시간) — date

fp_member (회원)

  • id (pk) — number — Primary key — NOT NULL
  • user_id (아이디) — varchar2(20) — NOT NULL
  • user_pw (비밀번호) — varchar2(120) — NOT NULL
  • nickname (닉네임) — varchar2(20) — NOT NULL
  • gender (성별) — varchar2(1)
  • email (이메일) — varchar2(400) — NOT NULL
  • birth (생년월일) — date
  • phone (전화번호) — varchar2(20)
  • red_date (등록일) — date — NOT NULL

fp_member_hobby (회원-취미-링크)

  • id (Key) — number — Primary key — NOT NULL
  • id (회원번호) — number — Foreign key → fp_member.id — NOT NULL
  • id (취미번호) — number — Foreign key → fp_hobby.id — NOT NULL