TravelDB

Tables (7)

Board (게시글)

  • board_id (게시글 id) — BIGINT — Primary key — NOT NULL
  • title (제목) — VARCHAR(100) — NOT NULL
  • content (본문) — TEXT — NOT NULL
  • category (카테고리) — ENUM — NOT NULL
  • views (조회수) — BIGINT — NOT NULL
  • reg_time (작성일) — DATE — NOT NULL
  • update_time (수정일) — DATE — NOT NULL
  • del_yn (삭제여부) — ENUM("Y","N") — NOT NULL
  • hashtag (해시태그) — VARCHAR(20)
  • member_id (회원 id) — BIGINT — Foreign key → Member.member_id — NOT NULL

Board_file (첨부파일)

  • board_file_id (첨부파일 id) — BIGINT — Primary key — NOT NULL
  • file_name (파일이름) — VARCHAR(255) — NOT NULL
  • file_url (파일경로) — VARCHAR(255) — NOT NULL
  • ori_file_name (원본파일이름) — VARCHAR(255) — NOT NULL
  • down_cnt (다운로드 횟수) — BIGINT — NOT NULL
  • file_size (파일용량(MB)) — BIGINT — NOT NULL
  • board_id (게시글 id) — BIGINT — Foreign key → Board.board_id — NOT NULL

Comment (댓글)

  • comment_id (댓글 id) — BIGINT — Primary key — NOT NULL
  • content (본문) — varchar(300) — NOT NULL
  • reg_time (작성일) — DATE — NOT NULL
  • update_time (수정일) — DATE — NOT NULL
  • board_id (게시글 id) — BIGINT — Foreign key → Board.board_id — NOT NULL
  • member_id (회원 id) — BIGINT — Foreign key → Member.member_id — NOT NULL

File_setting (첨부파일 설정)

  • file_setting_id (Key) — Primary key — NOT NULL
  • max_upload_cnt (최대 업로드 개수) — BIGINT — NOT NULL
  • file_max_upload_size (파일별 최대 업로드 용량) — BIGINT — NOT NULL
  • allowed_extension (업로드 허용 파일 확장자) — VARCHAR(255) — NOT NULL

Likes (좋아요)

  • member_id (회원 id) — BIGINT — Foreign key → Member.member_id — NOT NULL
  • board_id (게시글 id) — BIGINT — Foreign key → Board.board_id — NOT NULL

Member (회원)

  • member_id (회원 id) — BIGINT — Primary key — NOT NULL
  • ID (아이디) — VARCHAR(20) — NOT NULL
  • password (비밀번호) — VARCHAR(20) — NOT NULL
  • nickname (닉네임) — VARCHAR(20) — NOT NULL
  • email (이메일) — VARCHAR(30) — NOT NULL
  • birth (생년월일) — VARCHAR(10) — NOT NULL
  • phone_number (전화번호) — VARCHAR(11) — NOT NULL
  • zipcode (우편번호) — INT — NOT NULL
  • address (기본주소) — VARCHAR(100) — NOT NULL
  • address_detail (상세주소) — VARCHAR(100) — NOT NULL
  • role (구분) — ENUM("USER","ADMIN") — NOT NULL

Visitor_cnt (일별 방문자수)

  • visitor_day (날짜(일)) — DATE — Primary key — NOT NULL
  • cnt (방문자수) — BIGINT — NOT NULL