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