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