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 (날짜수동변경여부)