camping guide

Tables (7)

authority (권한)

  • 고유값 (authority_name) — varchar — Primary key — NOT NULL

board (게시글)

  • 고유값 (board_id) — bigint — Primary key — NOT NULL
  • 제목 (title) — varchar
  • 내용 (content) — varchar
  • 등록일 (regdate) — datetime
  • 수정일 (modify_date) — datetime
  • 고유값 (member_id) — bigint — Foreign key → member.고유값 — NOT NULL

camp (캠핑장)

  • 고유값 (camp_id) — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar
  • 장소 (place) — varchar
  • 비용 (money) — int
  • 설명 (explanation) — varchar
  • 번호 (phone_number) — varchar
  • 방 개수 (room_count) — TINYINT
  • 지역 (area) — varchar
  • 시작일 (start_date) — datetime
  • 마지막날 (end_date) — datetime

member (회원)

  • 고유값 (member_id) — bigint — Primary key — NOT NULL
  • 이름 (username) — varchar
  • 비밀번호 (password) — varchar
  • 등록일 (regdate) — datetime
  • 성별 (gender) — varchar
  • 생년월일 (date_of_birth) — varchar
  • 전화번호 (phone_number) — varchar

member_authority (회원 권한)

  • 고유값 (authority_name) — varchar — Foreign key → authority.고유값 — NOT NULL
  • 고유값 (member_id) — bigint — Foreign key → member.고유값 — NOT NULL

photo (사진)

  • 고유값 (photo_id) — bigint — Primary key — NOT NULL
  • 경로 (file_path) — varchar
  • 크기 (file_size) — bigint
  • 원본 이름 (orig_file_name) — varchar
  • 고유값 (board_id) — bigint — Foreign key → board.고유값 — NOT NULL

reservation (예약)

  • 고유값 (reservation_id) — bigint — Primary key — NOT NULL
  • 시작일 (start_date) — datetime
  • 마지막날 (end_date) — datetime
  • 총 비용 (money) — int
  • 고유값 (member_id) — bigint — Foreign key → member.고유값 — NOT NULL
  • 고유값 (camp_id) — bigint — Foreign key → camp.고유값 — NOT NULL