ERD
Tables (9)
RESERVATION (예약)
- rvno (예약번호) — PRIMARY KEY — Primary key — NOT NULL
- rdate (예약날짜번호) — FOREIGN KEY — Foreign key → reservation_date.rdate — NOT NULL
- mod_time (수정시간) — NULL
- reg_time (등록시간) — NULL
- deposit_name (입금자명) — NULL
- email (이메일) — NULL
- member (인원) — PRIMARY KEY
- message (요청사항) — NULL
- money (금액) — PRIMARY KEY
- reg_date (예약날짜) — NULL
- reg_name (예약자명) — NULL
- region (지역) — NULL
- state (예약상태)
- tel (전화번호) — NULL
jowhang_board (조황게시판)
- jbno (조황게시판 번호) — PRIMARY KEY — Primary key — NOT NULL
- id (아이디) — FOREIGN KEY — Foreign key → member.id — NOT NULL
- mod_time (게시물 수정시간) — NULL
- reg_time (게시물 등록시간) — NULL
- created_by (등록자) — NULL
- modified_by (수정자) — NULL
- content (내용)
- reply_count (댓글 수)
- title (제목)
jowhang_board_img (조황게시판 이미지)
- jino (조황게시판 이미지 번호) — PRIMARY KEY — Primary key — NOT NULL
- jbno (조황게시판 번호) — FOREIGN KEY — Foreign key → jowhang_board.jbno — NOT NULL
- realfile_name (실제파일이름)
- uuidfile_name (랜덤생성파일이름) — NULL
jowhang_reply (조황게시판 댓글)
- jrno (조황게시판 댓글번호) — PRIMARY KEY — Primary key — NOT NULL
- jbno (조황게시판 번호) — FOREGIN KEY — Foreign key → jowhang_board.jbno — NOT NULL
- id (아이디) — FOREIGN KEY — Foreign key → jowhang_board.id — NOT NULL
- mod_time (게시물 수정시간) — NULL
- reg_time (게시물 등록시간) — NULL
- created_by (등록자) — NULL
- modified_by (수정자) — NULL
- text (내용)
- title (제목)
member (회원)
- id (아이디) — PRIMARY KEY — Primary key — NOT NULL
- email (이메일) — UNIQUE
- auth_provider (인증제공자) — NULL
- name (이름) — NULL
- nick_name (닉네임) — NULL
- password (패스워드) — NULL
- point (포인트) — NULL
- refresh_token (리프래쉬 토큰) — NULL
- role (역할) — NULL
- tel (전화번호) — NULL
notice_board (공지게시판)
- nbno (공지게시판 번호) — PRIMARY KEY — Primary key — NOT NULL
- id (아이디) — FOREIGN KEY — Foreign key → member.id — NOT NULL
- mod_time (게시물 수정시간) — NULL
- reg_time (게시물 등록시간) — NULL
- created_by (등록자) — NULL
- modified_by (수정자) — NULL
- content (내용)
- reply_count (댓글 수) — PRIMARY KEY
- title (제목)
notice_reply (공지게시판 댓글)
- nrno (공지게시판 댓글번호) — PRIMARY KEY — Primary key — NOT NULL
- nbno (공지게시판 번호) — FOREGIN KEY — Foreign key → notice_board.nbno — NOT NULL
- id (아이디) — FOREIGN KEY — Foreign key → notice_board.id — NOT NULL
- mod_time (게시물 수정시간) — NULL
- reg_time (게시물 등록시간) — NULL
- created_by (등록자) — NULL
- modified_by (수정자) — NULL
- text (내용)
- title (제목)
noticeboard_img (공지사항게시판 이미지)
- nino (공지게시판 이미지 번호) — PRIMARY KEY — Primary key — NOT NULL
- nbno (공지게시판 번호) — FOREIGN KEY — Foreign key → notice_board.nbno — NOT NULL
- realfile_name (실제파일이름) — NULL
- uuidfile_name (랜덤생성파일이름) — NULL
reservation_date (예약날짜)
- rdate (예약날짜번호) — PRIMARY KEY — Primary key — NOT NULL
- available (예약가능여부)
- exrtra_members (예약가능인원)
- fishing_money (금액)
- fishing_sort (종류) — NULL
- message (날짜별특이사항) — NULL
- reg_date (예약날짜) — UNIQUE
- date_modify (날짜수동변경여부)